2021 Application Innovation Award Nomination: Adobe: Migrate data into Salesforce

What were the underlying reasons or business implications for the need to innovate and transform the business? Describe the business and technical challenges the customer was facing.

We have used SnapLogic pipeline to migrate data from External system called CP BIE to Salesforce. With existing implementation we migrated data by processing all the records. Now with new implementation we are processing only limited data and migrating only changed data.

Describe your strategy and execution to solve the business challenge. Include details on how SnapLogic played a role in the strategy and execution, including Snaps and other SnapLogic products/features.

We have used sql select to get all the data but now we are using sql server execute to fetch distinct data to process with limited number of records.

Who was and how were they involved in building out the solution? (Please include the # of FTEs, any partners or SnapLogic professional services who were involved on the implementation)

1 FTE 2Temps

What were the business results after executing the strategy? Describe how your company, departments, and/or employees/customers benefit from the application integrations. Include any measurable metrics.

Instead of processing 3 laks records now we are processing 50k-60k records

What was the ROI the customer gained from executing the strategy? Include any additional measurable metrics (ie. productivity improvement, speed improvement, % reduced manual inefficiencies, etc.)

Wait time reduced from 60 hours to 8hours