Business Opportunities

Integrating product data from newly acquired food brands was a slow and error-prone process and faced several challenges:

• Manual data entry: Overlapping ingredients with minor differences were scattered across various systems and historically entered manually, leading to many errors.
• Time-consuming search: Finding the right data and documents for cleansing was difficult and time intensive.
• High resource demand: The entire process required many internal resources.

Features

The eQ Integrator App, streamlined this process and delivered significant results. The app uses an intermediate data cache to reconcile differences between source systems and target systems like Oracle Agile PLM and SAP, enabling data cleansing and enrichment through a user-friendly interface.

• Automated Spec Creation: The app automatically creates various specification types (ingredients, formulations, packaging, etc.) in Oracle Agile and SAP.
• Simplified Data Cleansing: It presents data and documents directly to cleansers, eliminating the need for manual searching.
• Built-in Verification: The app enforces PLM processes with built-in verifications for mandatory attributes and more.
• Reusable for new acquisitions: The same app can be reused for future acquisitions with minimal changes.

eQube^® Benefits

The eQ Integrator App led to remarkable improvements:

• Integration time reduced by 75%
• Internal resource needs reduced by 50%, lowering overall costs
• Data integrity improved with automated, rules-based data transformation.

eQ Process

• Designed and launched a user-focused F&B integration app after conducting SME workshops and creating agile UI mock-ups.
• Reduced manual data management by implementing eQube^®-ADA with an intuitive UI for data cleansing and specification comparison.
• Ensured data integrity and process alignment by creating in-built workflows and validations for evolving PLM, pushing data to COTS PLM and ERP.
• Sequentially launched key modules (Ingredients, Formulations, Packaging, and Master Recipe) and continuously adapted based on performance analytics and evolving data conditions.

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 was used to sort data based on semantic similarities into match/no-match buckets