Case studies from across industries, domains and Bitwise solutions
Bitwise helped a large, US Insurance company successfully migrate their Data Integration (ETL) platform from DataStage to Microsoft SSIS. 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:
The Bitwise ETL Converter is customized based on the information captured that makes the automation highly cost-effective in terms of reducing the overall development efforts. The converter is additionally bundled with Data Validation automation that enormously reduces the turn-around time to productionalize the new solution.
A NASDAQ listed, $6 Billion company, providing affordable Insurance products across United States since 1925 with more than 5 million customer base.
The client had to move their entire data integration platform from IBM DataStage to Microsoft SSIS, covering the following aspects:
All of the above aspects had to be covered for about 700 Datastage jobs spread across 22 subject areas within the fixed timeline of 4 months to avoid Datastage license renewal. The jobs were of varied complexity with 42% jobs in the Medium-to-Complex category.