Optimizing real-time data synchronization

Our client is a leading LTL (Less than Truck Load) service provider in Pennsylvania, USA and has been in the industry for more than 8 decades. They provide one-stop freight services throughout the western, mid-western, and southeastern parts of the US.

Reading time: 1 min(s)

Business Challenge

Suffered continuous data mismatch and discrepancies while syncing all business data between Salesforce and AS400 on a daily basis
They encountered security lapses while transferring financial data.
Inadequate batch transfers and a long sync process time were the major setbacks.
Error notifications they received were ineffective.
Administrators did not have any visibility over AS400 and integration server parameters
Due to all of these challenges, they wanted to optimize their current process of syncing financial and shipping data between AS400 and Salesforce.

How Avasoft Helped?

We understood their pain points and did the following to help them beat the manual process:

Re-architected the Data Synchronization process for accurate financial and shipping data in the Salesforce.
Optimized the execution priority of sync processes based on the business data type and volume.
Designed reusable notification templates for better exception handling.
Implemented parallel processing for better execution.
Siloed unwanted datasets through optimized queries in AS400.
Implemented security protocols for real-time sync.
Streamlined a process for continuous integration and delivery.