Case studies from across industries, domains and Bitwise solutions

Achieve 60% Touch Free Migration using ETL Converter

Case Study Summary

Bitwise helped a Fortune 500, US financial company successfully migrate their Data Integration (ETL) from a leading expensive ETL tool to Hydrograph, an ELT tool based on Hadoop platform. The first and primary step in this migration was to complete the inventory analysis, and then scope the exact ETL jobs to be migrated. The approach included a collaborative effort with client teams and the STIMA utility (an automated assessment tool put together by Bitwise), which helped in laying the foundation for the ETL Converter by analyzing the items below:

  • Complexity definition of each ETL job
  • Identification of common features across all the ETL jobs

The Bitwise ETL Converter enables the automation of the migration process, thereby minimizing the time-to-production and brings in better quality within the new Data Integration platform. Its support for various Data Integration platforms and easy customization, based on the client’s needs, enables it to lead the market in offering a dynamic and complete migration toolset.

The Client

A NYSE listed, $25 Billion Company, offering broad array of financial products and services to consumers, small business and commercial clients.

The Challenge

The client had to move their data integration platform from a leading expensive ETL tool to Hydrograph ELT platform and wanted to ensure the following:

  • Reduction in time and efforts to adopt Hadoop platform
  • Provide results to save expensive ETL tool licensing costs in the long run
  • Unit testing of migrated ETL jobs on Hadoop platform
  • System integration and performance testing
  • Deployment to stage environment followed by production environment

All of the above aspects had to be covered for about 100 graphs from one of the critical application area related to Recoveries.

 To find out how to Achieve 60% Touch Free Migration using ETL Converter, download here.