Seamless Integration of 22 ERPs with Centric System – Workato

In today’s fast-paced business environment, integrating multiple Enterprise Resource Planning (ERP) systems with a Centric system is crucial for streamlining operations and enhancing productivity. Our team successfully implemented a solution that integrates 22 ERPs with a Centric system, ensuring seamless data synchronization and minimizing manual errors.

Scope of Integration

The integration project involved:

• 22 ERP systems
• 4 modules per ERP system
• Centric system as the central hub for data integration

Centric System’s Shadow Table

The Centric system provides modified record data in a shadow table. We utilized the REST API to filter the shadow table data and identify the modified records. By filtering out the shadow table data, we ensured that only the most recent and relevant data was processed.

API Filtering and Sorting

By utilizing the default REST API’s filtering and sorting features, we were able to:

• Retrieve only the modified records, reducing data transfer and processing time
• Sort the data based on specific criteria, ensuring that the only changed records were processed.

Complex Data Transformation

One of the significant challenges was transforming data from the Centric system to each ERP system. The source data was stored in two tables, while the destination data required multiple tables. Our team successfully handled this complex JSON data transformation, ensuring seamless integration with the target ERPs.

Custom Scripting and 2-Way Integration

To achieve efficient data transformation, we utilized custom scripting blocks. Additionally, our solution integrated data returned by the ERPs back into the Centric system, maintaining record IDs and integration status. This ensured 2-way integration between the systems.

Recipe Flow for Efficient ERP Configuration

To efficiently configure the ERP systems, we built a recipe flow that:

• Set the active status of each module to true or false based on the configuration requirements
• Enabled or disabled each module accordingly
• Ensured seamless integration and synchronization of data across all ERPs

Error Handling and Retry Mechanism

To ensure reliability and minimize errors, our solution incorporates robust error handling and retry mechanisms. In case of errors, our system:

• Catches and logs errors for easy debugging
• Retries failed operations after a specified time interval
• Notifies administrators of persistent errors

Building Custom Connector for Reduced Task Consumption

To optimize performance and reduce task consumption, our team built a custom connector for the Centric system. This custom connector:

• Minimizes API calls, reducing the load on the Centric system
• Improves data retrieval efficiency, reducing task consumption
• Enhances overall system performance and reliability

Metadata Integration

Our solution went beyond data integration, incorporating metadata integration between the ERP systems and Centric. This ensured consistency in picklist enum values across systems, resulting in seamless integration, minimized failures, and reduced manual intervention.

The successful integration of 22 ERPs with the Centric system has significantly improved our client’s operational efficiency and productivity. Our team’s expertise in handling complex data transformations, custom scripting, error handling, and building custom connectors has ensured a seamless and efficient integration process.