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.