Blog Post

Azure Data Factory Blog
1 MIN READ

ADF adds Azure Database for MySQL connector in Data Flow

Linda_Wang's avatar
Linda_Wang
Icon for Microsoft rankMicrosoft
Mar 11, 2021

Azure Data Factory now enables Azure Database for MySQL connector in Data Flow for you to build powerful ETL processes.

 

With Azure Database for MySQL as source in data flows, you are able to pull your data from a table or via custom query, then apply data transformations or join with other data. When using Azure Database for MySQL as a sink, you can perform inserts, updates, deletes, and upserts so as to publish the transformation result set for downstream consumption.

 

You can point to Azure Database for MySQL data using either a dataset or inline mode in data flow.

Learn more from Azure Database for MySQL connector documentation.

Published Mar 11, 2021
Version 1.0
azure data factory
Azure ETL
Mapping Data Flows

2 Comments

  • DonnaKelly's avatar
    DonnaKelly
    Copper Contributor
    Apr 13, 2023

    My understanding now is this:  if the source data is in Azure Database for MySQL then this is equivalent to Azure SQL Database. Connectivity is straightforward and an ADF could use this as the source system without any issue. 

    On the other hand, if the MySQL database has simply been copied into a (say, Linux) VM, then there will be a lot more hoops to jump through, like standing up a Self-Hosted Inetgration Runtime (and a VM to run it in) to get at the MySQL data from an ADF MySQL source connector.

  • DonnaKelly's avatar
    DonnaKelly
    Copper Contributor
    Feb 15, 2023

    When would you choose to use this over the MySql Connector (for creating a Linked Service in Data Factory)?  What would be the advantages of one over the other?