Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,637 questions
Access flexible postgresql database from data factory
![](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(44.800000000000004, 79%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Dominik Rieder (Ext.)
1
Reputation point
Hello Microsoft-Community,
we are trying to build some pipelines in Azure Data Factory that uses one of our postgresql databases as a source. This database is located in a virtual subnet. In addition, this subnet is delegated to Microsoft.DBforPostgreSQL/flexibleServers. This setup is a hard requirement for serveral reasons, so I can't make changes to this configuration.
When trying to setup the connection in datafactory, the server and the database appear as selectable options (for the Azure Database for PostgreSQL connector), but when trying to run a test-connection we get a "db-server.adress.com could not be resolved" error. We are using a Integration runtime that has the configuration for virtual networks enabled btw.
Some guides like this one suggest to create a private-link resource and link the respective virtual subnet to it. Unfortunately we can't create the private-endpoint for it, because for this subnet we get an "selected subnet has a delegation and cannot be used with a privat endpoint" error when trying to create it.
Has anyone experienced similar issues and knows a workaround for connecting to a flexible postgresql database that is inside a virtual subnet from data factory? Any hints are appreciated very much!
Best Regards,
Dominik
Azure Data Factory
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,430 questions
{count} votes
-
PRADEEPCHEEKATLA 90,646 Reputation points Moderator2022-11-17T10:33:59.63+00:00 Hello @Dominik Rieder (Ext.) ,
Thanks for the question and using MS Q&A platform.
Could you please share the complete error message which you are seeing when you click on test connection and also share the screenshot?
-
Dominik Rieder (Ext.) 1 Reputation point
2022-11-17T11:13:26.137+00:00 Hi @PRADEEPCHEEKATLA ,
thanks for your reply! Please find the screenshot of the error message attached.
-
PRADEEPCHEEKATLA 90,646 Reputation points Moderator
2022-11-28T06:48:02.297+00:00 Hello @Dominik Rieder (Ext.) ,
Apologize for the delay in response.
This issue looks strange. For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket
-
PRADEEPCHEEKATLA 90,646 Reputation points Moderator
2022-12-05T10:13:54.333+00:00 Hello @Dominik Rieder (Ext.) ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer