ResourceDownloadModal

'eQ Integrator' App reduces need for specialist resources

'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
  • 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
A Packaging food company integration | eqube