'eQ Integrator' App reduces need for specialist resources
Highlights
Rapid development of 'eQ Integrator' App
Intuitive data enrichment workflows
Resource needs reduced by 50%
Business Opportunities
- Integrating the Material and Product Specification system from acquired packaged foods brands
- Integrating the Material and Product specification systems took too long
- Many overlapping ingredients get used in Source and Target systems with minor differences. Details are scattered across applications
- Integrating the Material and Product specification systems took too long
- Historically, Source systems data was entered/edited manually causing errors
- Searching for the right data and documents was time consuming
- Large number of resources needed
Features
- eQ Integrator App enabled data enrichment and cleansing through user friendly UI
- Intermediate data cache was created to reconcile differences between source systems with Oracle Agile PLM and for data enrichment
- Creates various types of specifications in Oracle Agile for Process and SAP - Ingredients, Formulations, Trade Specs, Packaging, Master Recipe etc.
- At a glance comparison between existing and incoming specs - including extended attributes such as chemical and physical properties
- In built verifications to enforce PLM processes (e.g. mandatory attributes, LOVs from PLM etc.)
- Same eQ Integrator App can be re-used for new acquisitions by changing eQube®-TM maps with minimal changes to the App
eQube® Benefits
- Material and Product Specification system Integration time reduced by 75%
- Target system 1: Oracle Agile PLM for Process - Ingredients, Formulations, Trade Specs, Packaging, Master Recipe etc.
- Target system 2: SAP ECC6 - Ingredients, Packaging, Master Recipe etc.
- Internal resource needs reduced by 50%, lowering the overall costs
- Data and documents are presented to cleansers without searching
- Appropriate data elements automatically created in Oracle Agile and in SAP using transformation rules
eQube® Products Used
- eQube®-BI, eQube®-ADA, eQube®-TM, and eQube®-MI
- eQube® Connectors used: Oracle Agile PLM for Process, SAP ECC6, Databases, Excel, and files
- eQ Integrator - "For-Purpose" App built using eQube®-API gateway and eQube® UI services
- ADA (augmented data analytics) analysis sorts data based on semantic similarities into match/no-match buckets
- Review, resolve, verify and commit approach
- Most-used and high-impacting specs were prioritized for migration