How to connect MySQL in digital ocean with Azure Data Factory

Ahluwalia, Nimai 0

MySql server resides on digital ocean and I want to pull data with the help of ADF.

How can i do it?

Sedat SALMAN 13,160 Reputation points

2023-05-25T14:50:27.56+00:00

Azure Data Factory needs a Self-Hosted Integration Runtime to connect to your on-premises network or a network that's behind a firewall. This includes a MySQL server that's hosted on a DigitalOcean droplet. You can create a Self-Hosted Integration Runtime in the Azure portal by going to your Data Factory instance > Author & Monitor > Manage > Integration Runtimes > New > Self-Hosted > Name it and create. Then you need to install the Integration Runtime software on a machine that has network access to your MySQL server.

You need to ensure that the MySQL port (default is 3306) is open in your DigitalOcean droplet's firewall settings. This will allow incoming connections from the Self-Hosted Integration Runtime to your MySQL server.

In Azure Data Factory, you'll create a new Linked Service for your MySQL server. Go to Author & Monitor > Manage > Linked Services > New > Compute > MySQL. Here, you will enter the details of your MySQL server (hostname, database name, username, password) and select the Self-Hosted Integration Runtime you created earlier.
Oury Ba-MSFT 16,081 Reputation points Microsoft Employee

2023-05-26T15:06:26.1333333+00:00

Ahluwalia, Nimai Wanted to check if the above was helpful.

Please comment below if you need additional clarification.

Regards,

Oury
Ahluwalia, Nimai 0 Reputation points

2023-05-26T15:26:49.5666667+00:00

@Oury Ba-MSFT Thank you for your detail explanation.

I wont be able to migrate to Azure MySQL due to the version issues, but I think I am working on it.
Oury Ba-MSFT 16,081 Reputation points Microsoft Employee

2023-05-26T18:05:32.8066667+00:00

Ahluwalia, Nimai

Please let me know if you want to migrate and if any help is needed. I will assist you with that.

Regards,

Oury
Oury Ba-MSFT 16,081 Reputation points Microsoft Employee

2023-05-26T18:25:47.5133333+00:00

Ahluwalia, Nimai

Could you please explore ODBC connector:

how to insert data into MySql using Azure data factory - Stack Overflow

This will definitely help connect. Please let me know the result.

Regards,

Oury
Oury Ba-MSFT 16,081 Reputation points Microsoft Employee

2023-05-30T16:21:18.1466667+00:00

Ahluwalia, Nimai

I wanted to check about the progress for the above scenario. Do you still need further assistance.?

Regards,

Oury

1 answer

Oury Ba-MSFT 16,081 Reputation points Microsoft Employee

2023-05-25T20:25:10.9933333+00:00

Ahluwalia, Nimai Thank you for reaching out.

My understanding is that you want to connect and pull data with the help of ADF from your MySQL located in digital ocean cloud.

For MySQL hosted on digital ocean, that connector is not yet available in Azure. See below screen shot.

It is only possible to do it with the below connector name below by following this doc https://learn.microsoft.com/en-us/azure/data-factory/connector-mysql?tabs=data-factory

These are the available connector see image on the doc

Also, you can do one thing try to migrate your database to Azure and use the Azure MySQL connector.

Regards,

Oury
Please sign in to rate this answer.

0 comments No comments
Sign in to comment