Skip to content
  • Solutions
    • Cloud Solution
      • Cloud Data Migration
      • Application Modernization
      • Advanced Analytics
    • QA and Testing Solutions
      • Functional & Mobile Testing
      • Performance Testing
      • SOA Testing
      • Agile Testing
      • Web Testing
      • End-to-End Test Automation
    • Data and Analytics Solutions
      • Data Integration & Business Intelligence
      • Automated ETL Migration
      • Data Governance & Data Quality
    • Digital and Application Development Solutions
      • API development
      • Web & Mobile
      • Sharepoint
      • DevOps
  • Products
    • QualiDI
    • Hydrograph
    • ETL Converter
  • Why Bitwise
Menu
  • Solutions
    • Cloud Solution
      • Cloud Data Migration
      • Application Modernization
      • Advanced Analytics
    • QA and Testing Solutions
      • Functional & Mobile Testing
      • Performance Testing
      • SOA Testing
      • Agile Testing
      • Web Testing
      • End-to-End Test Automation
    • Data and Analytics Solutions
      • Data Integration & Business Intelligence
      • Automated ETL Migration
      • Data Governance & Data Quality
    • Digital and Application Development Solutions
      • API development
      • Web & Mobile
      • Sharepoint
      • DevOps
  • Products
    • QualiDI
    • Hydrograph
    • ETL Converter
  • Why Bitwise
Search
Close
  • Resources
    • Case Study
    • Webinar
    • News
Menu
  • Resources
    • Case Study
    • Webinar
    • News
Contact Us
  • Solutions

    Cloud Solution

    • Journey to the Cloud
    • Cloud Data Migration
    • Application Modernization
    Menu
    • Journey to the Cloud
    • Cloud Data Migration
    • Application Modernization

    Data and Analytics Solutions

    • Data Warehouse and Business Intelligence
    • Automated ETL Migration
    • Hadoop & NoSQL
    • Big Data Analytics and Data Science
    Menu
    • Data Warehouse and Business Intelligence
    • Automated ETL Migration
    • Hadoop & NoSQL
    • Big Data Analytics and Data Science

    Data Governance Solutions

    • Data Quality
    • Master Data Management
    • Data Security
    • Metadata Management
    Menu
    • Data Quality
    • Master Data Management
    • Data Security
    • Metadata Management

    QA Testing Solutions

    • Functional and Mobile Testing
    • Performance Testing
    • SOA Testing
    • API Automation Testing
    • Web Automation Testing
    Menu
    • Functional and Mobile Testing
    • Performance Testing
    • SOA Testing
    • API Automation Testing
    • Web Automation Testing

    Digital and Application Development Solutions

    • Enterprise Applications
    • Web and Mobile
    • SharePoint
    • DevOps
    Menu
    • Enterprise Applications
    • Web and Mobile
    • SharePoint
    • DevOps
    Explore More Solutions
    HOW WE ENGAGE
  • Products

    QualiDI

    Reduce ETL testing cycles and ensure data quality

    Hydrograph

    Engineered to accelerate ETL development in the big data ecosystem

    Test Data Management

    Generate realistic and reliable test data

    ETL Converter

    Convert any ETL to any ETL

    Hadoop Adaptor For Mainframe Data

    Convert Any Mainframe Data to Any Hadoop-Friendly Format

    Explore More Products
    HOW WE ENGAGE
  • Why Bitwise
Search
Close
  • Resources

    Blogs

    Bitwisers’ perspectives on the latest technology trends and happenings

    Case Studies

    Get a closer look at our customer stories and results

    News & Events

    See our latest event, news and conference information

    Solution Summary

    Explore our industry and domain-specific solutions

    Webinars

    Hone your skills and obtain new knowledge with our upcoming and on-demand webinars

Contact Us
Search
Close
  • Resources

    Blogs

    Bitwisers’ perspectives on the latest technology trends and happenings

    Case Studies

    Get a closer look at our customer stories and results

    News & Events

    See our latest event, news and conference information

    Solution Summary

    Explore our industry and domain-specific solutions

    Webinars

    Hone your skills and obtain new knowledge with our upcoming and on-demand webinars

Contact Us
  • Solution
    • Cloud Solution
      • Journey to the Cloud
      • Cloud Data Migration
      • Application Modernization
    • Data and Analytics Solutions
      • Data Warehouse and Business Intelligence
      • Automated ETL Migration
      • Hadoop & NoSQL
      • Big Data Analytics and data science
    • Data Governance Solutions
      • Data Quality
      • Master Data Management
      • Data Security
      • Metadata Management
    • QA and Testing Solutions
      • Functional and Mobile Testing
      • Performance Testing
      • SOA Testing
      • API Automation Testing
      • Web Automation Testing
    • Digital and Application Development Solutions
      • Enterprise Applications
      • Web and Mobile
      • SharePoint
      • DevOps
  • Products
    • Qualidi
    • Hydrograph
    • Test Data Management
  • Resources
    • Blogs
    • Case studies
    • News and events
    • Solution summary
    • Webinar
  • Why Bitwise
  • Contact Us
Menu
  • Solution
    • Cloud Solution
      • Journey to the Cloud
      • Cloud Data Migration
      • Application Modernization
    • Data and Analytics Solutions
      • Data Warehouse and Business Intelligence
      • Automated ETL Migration
      • Hadoop & NoSQL
      • Big Data Analytics and data science
    • Data Governance Solutions
      • Data Quality
      • Master Data Management
      • Data Security
      • Metadata Management
    • QA and Testing Solutions
      • Functional and Mobile Testing
      • Performance Testing
      • SOA Testing
      • API Automation Testing
      • Web Automation Testing
    • Digital and Application Development Solutions
      • Enterprise Applications
      • Web and Mobile
      • SharePoint
      • DevOps
  • Products
    • Qualidi
    • Hydrograph
    • Test Data Management
  • Resources
    • Blogs
    • Case studies
    • News and events
    • Solution summary
    • Webinar
  • Why Bitwise
  • Contact Us

ETL Migration

Automate ETL from DataStage to Microsoft SSIS

Case Study Summary

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:

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

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.

 

The Client

A NASDAQ listed, $6 Billion company, providing affordable Insurance products across the United States since 1925 with more than 5 million customer base.

 

The Challenge

The client had to move their entire data integration platform from IBM DataStage to Microsoft SSIS, covering the following aspects:

  • Development of the SSIS ETLs after analyzing the original DataStage jobs
  • Unit testing, which involved the extensive field level comparison of DataStage outputs against those generated by newly developed SSIS ETLs
  • System integration and performance testing
  • Deployment to stage environment followed by the production environment

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% of jobs in the Medium-to-Complex category.

 

 To find out how to Automate ETL from DataStage to Microsoft SSIS, download here.

    Download Case Study



    Never Miss Bitwise Updates!

      Products
      • QualiDI
      • Hydrograph
      • Test Data Management
      • ETL Converter
      • Hadoop Adaptor for Mainframe Data
      Menu
      • QualiDI
      • Hydrograph
      • Test Data Management
      • ETL Converter
      • Hadoop Adaptor for Mainframe Data
      Digital and Application Development Solutions
      • Enterprise Applications
      • Web and Mobile
      • SharePoint
      • DevOps
      Menu
      • Enterprise Applications
      • Web and Mobile
      • SharePoint
      • DevOps
      Data and Analytics Solutions
      • Data Warehouse and Business Intelligence
      • Automated ETL Migration
      • Hadoop & NoSQL
      • Big Data Analytics and Data Science
      Menu
      • Data Warehouse and Business Intelligence
      • Automated ETL Migration
      • Hadoop & NoSQL
      • Big Data Analytics and Data Science
      Cloud Solutions
      • Journey to the Cloud
      • Cloud Data Migration
      • Application Modernization
      Menu
      • Journey to the Cloud
      • Cloud Data Migration
      • Application Modernization
      QA and Testing Solutions
      • Functional and Mobile Testing
      • Performance Testing
      • SOA Testing Services
      • API Automation Testing
      • Web Automation Testing
      Menu
      • Functional and Mobile Testing
      • Performance Testing
      • SOA Testing Services
      • API Automation Testing
      • Web Automation Testing
      Data Governance Solutions
      • Data Quality
      • Master Data Management
      • Data Security
      • Metadata Management
      Menu
      • Data Quality
      • Master Data Management
      • Data Security
      • Metadata Management
      Company
      • About Us
      • Life@Bitwise
      • Current Openings
      • Contact Us
      Menu
      • About Us
      • Life@Bitwise
      • Current Openings
      • Contact Us
      Resources
      • Blogs
      • Case Studies
      • News and Events
      • Solution Summary
      • Webinars
      Menu
      • Blogs
      • Case Studies
      • News and Events
      • Solution Summary
      • Webinars
      bitwise footer
      Facebook
      Twitter
      Linkedin
      Youtube
      Certificates
      • tickCreated with Sketch. ISO 9001:2015
      • tickCreated with Sketch. ISO/IEC 27001:2013
      • tickCreated with Sketch. ICO Registered:ZA581909
      Cyber Essentials Badge
      Privacy Policy
      Site Map

      All Rights Reserved @ Bitwise 2021

      ^

      Download this case-study

        By continuing to use this website, you consent to the use of cookies in accordance with our Cookie Policy .

        Accept