Azure Data Factory

Azure Cloud

Azure Data Factory

Azure Database for MySQL

Microsoft SQL Server

Zabbix

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

Accomplishments:

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

Outsource

Need a similar project?

SCHEDULE A CALL

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.

SCHEDULE A CALL

What our customers are saying

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

5.0

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

5.0

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

5.0

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

5.0

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

5.0

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.