All case studies
Case study
ETL from on-premises SQL Server to a MySQL data mart with Azure Data Factory
We built an Azure Data Factory ETL pipeline from on-premises SQL Server to a MySQL data mart, with Zabbix monitoring and Azure AD access control.
- Effort
- 60 hours
- Engagement model
- Outsource
- Client
- Enterprise
Project goals
- Set up an ETL process on Azure Data Factory to move data from an on-premises OLTP database on Microsoft SQL Server to a data mart on Azure Database for MySQL.
- Build a number of aggregations and transformations into the ETL process.
What we delivered
- Designed an ADF pipeline that extracts data from SQL Server, applies all the required transformations and loads the results into the data mart.
- Integrated the service with the client's on-premises monitoring system, Zabbix, for reliable, production-ready management and monitoring.
- Set up Azure AD roles and users in line with the company's security and access policies.
Project team
- Senior DevOps Engineer
- Senior Data Engineer
Need a similar project?
Book a free 30-minute consultation and we will explain how we would approach it.