Right Data Right Time Right Data Right Time

Right Data, Right Time, Right Data. Right Time. Real Time © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. 1

What is IDEA Fusion Instance of SQL Server 2017 Hosted in IDEA’s cloud environment One database with all your authorized IDEA Connector content Updated nightly by IDEA © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. 22

What is IDEA Fusion Can connect to it via any ODBC client or Native SQL Server Client You own the database © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. 33

What IDEA Fusion is not Product Information Management System (PIM) Master Data Management System (MDM) No User Interface! Not intended for direct access queries from your customer facing systems © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. 44

Extendable copy of your IDEA data hosted in the Cloud © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. 5

Distributor Bi-Directional ERP Updates Product Info Attribution Pricing © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. Company Specific Augmentation Attributes Product Numbers Marketing Customer Info Authorizations Enrichment 66

Manufacturer – Send your data E-Comm Bi-Directional ERP Updates Excel Sell Sheets Web Site © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. Product Info Attribution Pricing Company Specific Augmentation Attributes Product Numbers Marketing Customer Info Authorizations Enrichment Analytics 77

Manufacturer – Receive your data back E-Comm Bi-Directional ERP Updates Excel Sell Sheets Product Info Attribution Pricing Web Site Company Specific Augmentation Plant codes Shipping info Engineering © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. Analytics 88

Conventions used in IDEA Fusion • Field names start with high level data type • ‘s’ for text string data (s. Name) • ‘n’ for number data (n. Prc) • ‘v’ for dates (v. Update. Dt) • ‘b’ for bit data (b. Returnable) • Primary keys • n. Item. Id – identifies the item • n. Id. Pub – identifies the Manufacturer (tb. Co) • s. Lang – language identifier • s. Txt. Type – identifies field © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. 99

Conventions used in IDEA Fusion • Multi-value data is stored in its own table • tb. Cert – Certification Agency data • tb. Pak – Packaging • tb. Prc - Pricing • tb. Item. Txt - Multilanguage Text Fields and Urls • tb. Item. Attr – CAS Attributes • tb. Non. Std. Attr – Non-Standard Attributes © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. 1010

Schema © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. 1111

Right Data, Right Time, Real Time © 2020 Industry Data Exchange Association, Inc. All Rights Reserved. DEMO 12