CODEWITHSUNDEEP
azure-data-factory
Tuan Le PN
Tuan Le PN

Reputation: 384

how to insert data into MySql using Azure data factory

In Azure Data Factory, the Copy activity doesn't support MySQL table in Sink setting (link). I need to copy some data from another database's table into a relevant MySQL table. Do we have any other Activity that can do the MySQL's insertion? Thanks.

Upvotes: 0

Views: 2198

Answers (1)

Nick.Mc
Nick.Mc

Reputation: 19205

Here's a guide to using an ODBC sink/source

https://learn.microsoft.com/en-us/azure/data-factory/connector-odbc?tabs=data-factory

  • Install a self hosted runtime on a server
  • Connect the self hosted runtime to the ADF instance
  • Install the MySQL ODBC driver on the server, set up a DSN and test it
  • Test it in the self hosted runtime console
  • Set up an ODBC linked service in ADF. Test it

Upvotes: 2

Related Questions