Data Warehouse Modernization
Migrate Informatica PowerCenter ETL to Microsoft Fabric Warehouse
A US-based IT company needed to modernize its on-premise legacy data warehouse built on Informatica PowerCenter and Oracle to Microsoft Fabric with the objective to leverage the advanced features of Microsoft Fabric for improved data integration and workflow orchestration.
Client Challenges and Requirements
- Comprehensive evaluation of the legacy system which had been in operation for over 20 years.
- Transition from Informatica PowerCenter to Microsoft Fabric Pipelines / Fabric-PySpark Notebooks as part of a pilot project.
- Migration of the associated database objects along with the workflows.
- Limited Microsoft Fabric awareness with stakeholders.
Bitwise Solution
Automated ETL Migration services using Bitwise’s proprietary ETL Converter suite to accelerate project execution within defined cost and timeline constraints.
- Conduct detailed assessment using Bitwise Source ETL Analyzer to uncover the complexities of the existing legacy jobs.
- Use assessment reports throughout the project to reduce turnaround time and enhance accuracy with analysis for source and target information used within ETL, pattern findings, lineage, and schedule information.
- Comprehensive solution design that includes generic frameworks, migration strategy, and design considerations for transitioning Informatica workflows and mappings to Microsoft Fabric Data Pipelines and Notebook.
- Recommendation of a workaround to ensure seamless data integration of Microsoft Fabric with SAP legacy tables.
- Conduct a demo of the converted code along with validation results to ensure a smooth handover and confidence.
Tools & Technologies We Used
Bitwise Source ETL Analyzer & ETL Converter
Informatica PowerCenter
Oracle
SAP Legacy tables
Microsoft Fabric Pipeline
PySpark
Fabric Lakehouse
Fabric Warehouse
Key Results
70% reduction of Assessment using Bitwise Source ETL Analyzer
Highly efficient and accurate migration using Bitwise’s automated migration IP
65% automation in converting Informatica mappings to Microsoft Fabric Notebooks
30% reduction in overall migration
