How to insert data in to MySQL Using Azure data factory?

Question

Hi Team,
We need to setup export data from excel to MySql using Datafactory. I was able to create data set for MySQL but it doesn't shows up in sink data source to copy the excel data in to MySql. Its a PAAS system so we don't have any hand on the server other than the connection.
Thought of using ODBC but it needs integration run time to be installed in the server.

Help much appreciated.

Thanks & Regards,
Thiyagarajan.S

Answer 1

Hello @Thiyagarajan S

MySQL is not supported as a sink in Azure Data Factory

Azure MySQL would be supported but not a general MySQL DB

This can be found under the documentation: https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-overview#supported-data-stores-and-formats

Here, if you see MySQL, it's mentioned that it won't support as a sink