Retail

Converting Ab Initio ETL to Informatica for Leading Retail Company

Converting Ab Initio ETL to Informatica for Leading Retail Company

A $100B NYSE listed retail company needed a data management architecture and platform to help them to scale out in support of expansion plans and revenue goals of the business.

Client Challenges and Requirements

  • The strategy included a plan to move their entire Data Integration platform to Informatica within an aggressive fixed timeline to avoid license renewal costs of the existing tool.
  • The effort covered conversion of 1500 Ab Initio graphs across 40 subject areas within the project timeline. The graphs varied in complexity with 58% in the Medium-to-Complex category.

Bitwise Solution

  • The ETL Conversion service provided by Bitwise enabled the client to reduce time to market and save on licensing costs. Bitwise conversion solution helped in identifying the scope accurately and optimizing the conversion process with the help of features provided by this accelerator.
  • Automated Assessment with Dark Data Discovery framework
  • Phased Conversion Approach
  • Consistency and Standardization across the Data Integration Jobs
  • Automated Data Validation​
  • Repeatable Process​

Tools & Technologies We Used

ETL Converter
Ab Initio
Informatica PowerCenter

Key Results

Using its ETL Converter solution, Bitwise provided 70% automated conversion, achieving faster time-to-market.

Using its ETL Converter solution, Bitwise provided 70% automated conversion, achieving faster time-to-market.

60% Reduction during Assessment Phase and Inventory Clean Up

60% Reduction during Assessment Phase and Inventory Clean Up

40% Increase In Developer Productivity

40% Increase In Developer Productivity

30% Reduction In Data Validation Effort

30% Reduction In Data Validation Effort

Client Challenges and Requirements

  • The strategy included a plan to move their entire Data Integration platform to Informatica within an aggressive fixed timeline to avoid license renewal costs of the existing tool.
  • The effort covered conversion of 1500 Ab Initio graphs across 40 subject areas within the project timeline. The graphs varied in complexity with 58% in the Medium-to-Complex category.

Bitwise Solution

The ETL Conversion service provided by Bitwise enabled the client to reduce time to market and save on licensing costs. Bitwise conversion solution helped in identifying the scope accurately and optimizing the conversion process with the help of features provided by this accelerator.

Automated Assessment with Dark Data Discovery framework

Phased Conversion Approach

Consistency and Standardization across the Data Integration Jobs

Automated Data Validation​

Repeatable Process​

Tools & Technologies We Used

ETL Converter

Ab Initio

Informatica PowerCenter

Key Results

Using its ETL Converter solution, Bitwise provided 70% automated conversion, achieving faster time-to-market.

60% Reduction during Assessment Phase and Inventory Clean Up

40% Increase In
Developer Productivity

30% Reduction
In Data Validation Effort

Share

Download Case Study

Let's Engineer Your AI Advantage