Informatica and PL/SQL Conversion to Azure Data Factory

A Global Research and Advisory Company is in a journey to migrate data from on-premise applications to Azure to maintain and enhance its EDW, reporting and analytics applications in order to provide accurate and timely data to users and ensure data availability for Reporting and BI functions.

Client Challenges and Requirements

• Limited capacity to convert legacy ETL code from Informatica jobs and PL/SQL procedures to Azure Data Factory (ADF) on Azure within defined timeframe.
• Over 800 Informatica jobs to convert to ADF.
• Over 300 PL/SQL procedures to convert to T-SQL.
• Need to match Orchestration features and functionality in ADF.

Tools & Technologies We Used

Key Results

1 hour effort savings per ADF pipeline using Bitwise utility for ARM template splitting

0.5 effort savings per ADF pipeline using Bitwise utility for adding activity to pipelines in ADF

Fully converted and unit tested code delivered with ~40% overall time efficiency