Connecting the postgres sql server running on linux machine to azure data factory

Question

My on-prem postgres Sql server is running on linux machine. what are the possible way to connect to azure data factory and what is the integration should be used to connect the linux machine?

Answer 1

Hello @pavan rakesh ,

Thanks for the question and using MS Q&A platform.

As I understand the ask is that you would want to know if you can connect to Postgres sql server running on linux machine using ADF. Please correct if I'm not accurate.

I don't think it is possible to connect to Postgres Sql server running on Linux using ADF connector as ADF Postgres connector requires SHIR to establish connection. And SHIR is currently available only on windows (see system requirements at https://www.microsoft.com/en-us/download/details.aspx?id=39717).

We recommend you to please up-vote and comment on this feature request submitted by another user in IDEAS forum - Create self-hosted integration runtime capable of running on Linux

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or 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