Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
How to Install a ODBC driver on the Azure Integration Runtime machine?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 1%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Frank Admin
1
Reputation point
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 Stack Hub
Azure Stack Hub
An extension of Azure for running apps in an on-premises environment and delivering Azure services in a datacenter.
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator2020-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).
Reference:
-
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
2020-12-09T01:47:04.593+00:00 @Frank Admin Please let me know if you having any questions.
-
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
2020-12-16T18:30:33.777+00:00 @Frank Admin Please let me know if you find above reply useful. If yes, do click on 'Mark as answer' link in above reply. This will help other community members facing similar query to refer to this solution. Thanks.
Sign in to comment -