SFDC – Education – MySQL to Salesforce Data Migration – Success Story

Client Overview

The client is a US-based Education organization focused on developing ways to inspire students and people to participate in science and technology fields. The organization motivates people to pursue education and career in science, technology, engineering and mathematics and supports them in building self-confidence, knowledge and life skills.

Business Challenge

Client needed to migrate their entire organization data, which was stored on MySQL database to Salesforce platform. The data migration process had the following challenges:

  • Mapping and conversion of MySQL tables with Salesforce objects

  • Scripting for data conversion

  • Design of the data migration flow

  • Deduplication of data

  • Trigger handling for data migration

  • Creation of chunks of new records for migration

Technical Requirements

  • Apex

  • JDK 1.6

  • Toad tool

  • MySQL

Solution Strategy

Eternus Solutions reviewed the client objectives, collaboratively taking care of the entire database design and development. Eternus Solutions database expert team designed and implemented their innovative ETL (Extract-Transform-Load) method for successful data migration. Eternus Solutions team used the following methodology to achieve seamless Data Migration from MySQL to Salesforce:

  • The team reviewed the existing MySQL database source tables and the data stored within. Source tables and target objects combinations along with total record count for each recorded data were identified.

  • Client’s database experts used these results and analyzed the data that would not be needed to migrate. This analysis enabled the Eternus Solutions team to determine the actual number of migration job effort needed for the migration of MySQL database.

  • MySQL database backup was taken for all legacy data in the form of CSV files

  • Eternus Solutions database consultants wrote procedures and functions to hold the transformation views into the Toad tool using MySQL

  • Configuration workbook was created as a guide for migration scripting with conversion logic, case translation values to map objects.

  • Relational Junction tool was configured to create staging database with replication tables as a representative of Salesforce objects for data transformation

  • Translation object was created in Salesforce org to determine the values of the MySQL database tables after migrating to Salesforce

  • Relational Junction tool was used to push all the data of staging database to Salesforce in sequential order to complete the data migration process

Salesforce-Relational Junction Integration Eternus Solutions project team was responsible for the integration with Relational Junction for data replication and integration into Salesforce. The Salesforce-Relational Junction integration enabled the client to migrate legacy data and build a Salesforce-based reporting warehouse by creating and synchronizing a local database, which is an exact replica of their Salesforce data. The Salesforce-Relational Junction integration was bi-directional.

SupportThe project also involved provision of support for the data transformation process in order to create chunks of new data for data migration, for which the Eternus Solutions team was responsible.

Development Methodology

  • 3-Step development methodology that consisted of development of Procedures and functions using SQL scripting in Toad tool, testing in Sandbox or Production org and moving to the Production org

  • Design documents for procedures and functions written in SQL, along with source and target mapping documents and migration flow

  • Trigger handling for data migration process

  • Optimized joins for data deduplication

  • Removal of hardcoded values using transformation tables

  • Integration with data replication and integration tool Relational Junction

  • Coding using SFDC standards and best practices

Share This Case Study