Connect to Clients Mysql database via ADF

Mark 20 Reputation points
2024-01-30T06:13:46.2266667+00:00

I am new to Azure and Azure Data Factory. I need to access a client's MySQL database (on-premises - we only have database access and cannot access the server that hosts the database) to extract data via ADF and store it in an Azure SQL database. Could you please explain which type of runtime integration I need? Do I need a separate virtual machine or server to install the Integration Runtime (IR), and do I have to install the IR on the client's server as well? Thank You

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,139 questions
0 comments No comments
{count} votes

Accepted answer
  1. BhargavaGunnam-MSFT 24,106 Reputation points Microsoft Employee
    2024-02-16T22:21:18.9566667+00:00

    Hello Mark

    No, you do not need to install the self-hosted integration runtime on the same server as the MySQL database. You can install it on a separate machine that has network connectivity to the MySQL database. This machine can be an on-premises machine or a virtual machine inside a private network. If you cannot install the self-hosted integration runtime on the client’s server or network, you can use the managed virtual network feature to set up a private endpoint for the self-hosted integration runtime. This will allow you to securely access the on-premises MySQL database from the Azure Data Factory service.

    I hope this answers your question.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Amira Bedhiafi 12,406 Reputation points
    2024-01-30T09:30:46.88+00:00

    You need use the specialized Azure Database for MySQL connector. Based on the documentation :

    If your data store is located inside an on-premises network, an Azure virtual network, or Amazon Virtual Private Cloud, you need to configure a self-hosted integration runtime to connect to it.If your data store is a managed cloud data service, you can use the Azure Integration Runtime. If the access is restricted to IPs that are approved in the firewall rules, you can add Azure Integration Runtime IPs to the allow list.You can also use the managed virtual network integration runtime feature in Azure Data Factory to access the on-premises network without installing and configuring a self-hosted integration runtime.