ms-accessazure-virtual-machineazure-data-factoryon-premises-instances

Azure Data Factory - connect to onprem accdb


I need to retrieve data from Access onprem database by using adf. I have integration runtime installed on azure vm. Access database is on the other virtual machine. I know that on the azure virtual machine I should have a path to that Access database but how to do that?


Solution

  • I know that on the azure virtual machine I should have a path to that Access database but how to do that?

    Microsoft Access 2016 version of ODBC driver doesn't work with this connector. Use Microsoft Access 2013 or 2010 version of ODBC driver instead.

    Reference- Copy data from and to Microsoft Access using Azure Data Factory follow this official document.