Using 32-bit ODBC driver from Azure Data Factory

Question

I need to extract information from al old Progress database (9.1E), which only works with a 32-bit driver.
From Data Factory, we have extracted data using ODBC connections, but I wanted to check if Data Factory will use a 32-bit driver (if installed on the integration runtime server).

Is this a supported approach?

Thank you.

Answer 1

Hi @Nestor ,

Thanks for posting your query.

As per the documentation it is required to install the 64-bit ODBC driver for the data store on the Integration Runtime machine. Hence 32 bit driver is not a supported approach for ADF V2 ODBC connection.

Doc link: https://learn.microsoft.com/en-us/azure/data-factory/connector-odbc?tabs=data-factory#prerequisites

Here is another thread where a similar topic was discussed : https://social.msdn.microsoft.com/Forums/azure/en-US/7849e067-e5b0-4bdb-843d-e3d58be2e6db/32bit-support-for-datamanagementgateway-and-integrationruntime

If you any additional feedback or product improvement request, we encourage you to please log a feature request in Azure feedback forum here: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c

Please do share the feedback link once it is posted.

Hope this info helps.

----------

• Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators