Right Data Right Time Right Data Right Time
- Slides: 13
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
- Right product right place right time right price
- Family time
- The right man on the right place at the right time
- Elapsed time
- Left left right right turn around go go go
- Put your right foot in
- Left left right right go go go
- Time right
- Christmas falls 25th december preposition
- Fill in the gaps using the right preposition of time
- Takt time vs cycle time
- Length bias vs lead time bias
- Length bias vs lead time bias
- Exponential vs polynomial