pal.tech logo

Migrating data from On-premise to Azure Cloud

CONNECTORS | DATABASE MIGRATION
Paltech Icon

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

Key Features

  • Real-time Reporting
  • Notifications & Alerts
  • Data Migration from OnPrem to Cloud
  • Processing real time data
Key Metrics
30%

Faster batch cycle load

Reduction in unplanned downtimes

Accurate Real time data

90%

 Availability

Technology Stack