none
Can we copy data from file to MySQL Database using Azure Data Factory V2

    Question

  • Hi ,

    I have one sample text file which I want to load in MySQL Target database which is in On Premises.

    I dont see any option where I can copy data from file to MySQL DB using ADF V2


    Thankx & regards, Vipin jha MCP

    Friday, May 4, 2018 10:20 AM

All replies

  • Hi Vipin,

    MySQL is supported as a source, but not currently supported as a sink:

    https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview#supported-data-stores-and-formats

    Monday, May 7, 2018 11:23 PM
    Moderator
  • Hi Vipin,

    You can try OdbcSink as described in this doc: https://docs.microsoft.com/en-us/azure/data-factory/connector-odbc

    You will need to install MySQL ODBC driver on the machine hosting your IR.

    Regards,

    Dongjing

    Tuesday, May 8, 2018 5:16 AM