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.
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
Apex
JDK 1.6
Toad tool
MySQL
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.
Support – The 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.
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
