Back to cases

Azure Data Factory

Azure Cloud
Azure Data Factory
Azure Database for MySQL
Microsoft SQL Server

Project goals:

  • Setup ETL process based on Azure Data Factory, to move data between OLTP
  • MS SQL Server DB (on-premises environment) and Data Mart based on Azure Database for MySQL.
  • Implement several aggregations and transformations into ETL


  • The ADF pipeline has been designed to move extract data from SQL Server, perform all required transformations and load the data into the Data Mart.
  • The service has been integrated with an on-premises monitoring system (Zabbix), to ensure robust, production-ready management and monitoring capabilities.
  • Azure AD roles and users have been set up to fit the enterprise security/access policies.

Project team:

  • Senior DevOps Engineer
  • Senior Data Engineer
60 hours

Need a similar project?

Book a free 30 min consultation & get a proper business consultation from a market leading expert. We are here to provide you a solution per your business need.

What our customers are saying

We are trusted by numerous companies from different businesses to meet their needs.

Wonderful and dedicated guys. They fixed all our system problems in a smart and proffesional way. Will definitely hire them for our future projects. Thanks for provding a great solution!

Kashif Ahmed
CEO, MediaLink

Alex is one of the best Oracle DBA’s I have worked with. Excellent communication skills, it was great to wirk with UCGP Consult.

Peter Thomas
CTO, Blue Lance

Upgrade consulting has designed the whole database solution for us and has led the project to the successful implementation. It’s a pleasure working with this team.

Adrienne Daly
Managing Director, Amos

Competent and confident at what they do. They go the extra mile to research and find the best solution to any problem. A great resource for specific projects or continious support.

Deepak Gupta
COO, Balluun

We can recommend Upgrade Consulting without any restrictions. They are, without any question, a shining star among the Oracle DBAs on the market.

Michael Schmidt
Managing Director, XR Systems

Get a quote in 24 hrs

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.