Migrating data from On-premise to Azure Cloud
Dec 21, 2022
Helped client to reduce costs and to support a higher functioning it infrastructure. Also migrated their existing on-premise SSIS packages to azure cloud provider in various phases.
Solution
- Analysis of existing system for cloud migration
- Prepare plan for creating data bricks notebooks for each SSIS package
- Implement Kafka to get real time data from P21 systems and load to Data lake
- Implement Data Factory to get data from other sources and load to Data lake
- Implement data bricks notebooks to load incremental data in data lake to Azure SQL Data warehouse
- Migrate Power BI reports for Analytical data
- Update existing data model based on data/reporting needs
- Implement Audit Control and Balance
- Migrate Crystal reports for operational data
