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

Thiyagarajan S 41 Reputation points
2022-03-22T04:44:55.18+00:00

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

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

Accepted answer
  1. Pratik Somaiya 4,201 Reputation points
    2022-03-23T04:00:35.637+00:00

    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

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful