How to Install a ODBC driver on the Azure Integration Runtime machine?

Frank Admin 1 Reputation point
2020-11-30T22:00:20.937+00:00

The following link states that a prerequisite for copying data sources using Azure Data Factory is to install an ODBC driver in the Azure Runtime Environment.

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

However, I can't find anything that documents how to do this. I would expect that many, many people have either done this or need this information. Please help! I'm stuck

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,160 questions
Azure Stack Hub
Azure Stack Hub
An extension of Azure for running apps in an on-premises environment and delivering Azure services in a datacenter.
191 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Rich S Jeantheau 6 Reputation points
    2021-03-17T15:21:02.393+00:00

    You didn't answer his question. He knows he needs an ODBC driver and wants to know how to install it on an I.R.

    1 person found this answer helpful.
    0 comments No comments

  2. Saurabh Sharma 23,826 Reputation points Microsoft Employee
    2020-12-01T00:05:56.743+00:00

    @Frank Admin Thanks for using Microsoft Q&A.
    Which data source you want to connect to using ODBC ? In order to connect using ODBC you need to install specific ODBC drivers on your machine. ODBC drivers are different for different sources so if you would like to connect to a SQL Server using ODBC you need to install ODBC driver(64-bit) and if you want to connect to Microsoft Access source then you need to install ODBC driver for Microsoft Access. Also, you can find installed ODBC drivers in your system by going to Administrative Tools > Data Sources (ODBC). 43818-image.png

    Reference:


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.