Data Migration for a leading publishing company reduced solution cost by 65%

Authored by Ameex Technologies on 05 Nov 2019

Client is a leading media and communication company and wanted to migrate from Salesforce to AWS.

Current State:

  • There were two source systems primarily – one to hold subscription details and another to hold customer details. These 2 systems were holding 20 plus tables.
  • There were few other systems such as Demand Tools which was used for cleansing and data deduping.
  • Millions of rows of data were generated daily between these two systems and this was pushed into Salesforce through a nightly batch process after applying different transformations.
  • Domo was the platform used to meet the reporting needs of the various stakeholders.

Gaps:

  • Salesforce license was expiring within 3 months of the project initiation.
  • Over 350GB of data from Salesforce had to be migrated to the new environment.
  • Salesforce had complex transformation rules (50+ Apex Triggers) which had to be understood and replicated.
  • There was no prior documentation available, making the understanding of business rules complex.

Future state:

  • All the historical data (350+GB) is migrated from Salesforce into AWS.
  • All the data transformation rules used in Salesforce have been replicated in AWS.
  • Data from the two primary source systems and other systems (as appropriate) is now flowing seamlessly into AWS daily.

Business impact:

  • Overall Solution Cost was reduced by 65% ( Salesforce License Cost vs Our New Solution). Open Source technologies were used as much as possible to reduce the cost.
  • Daily Upsert process speed was increased by 30%.
  • Error Management in the new solution reduced manual effort.

Want to learn more about how we have helped our clients with their analytics journey? let’s connect!

Related Case Studies

Built an interactive dashboard for a global nutrition company which helped them track customer behavior effectively

Client is a leading consumer goods conglomerate dealing with healthcare, hygiene and home products… Read More

Helped a leading healthcare company with insights on customer perception about their brand

Client is a leading consumer goods conglomerate dealing with healthcare, hygiene and home products… Read More

Case Studies