Share via

Need to connect the Azure PostgreSQL in ADF linked services

Aravind 20 Reputation points
2024-01-05T07:37:51.43+00:00

Hi Team,

I able to connect the Azure Postgresql in ADF linked service but we given public access to azure PostgreSQL so able to connect but now we have one another Azure Postgresql so there we won't give public access for all so I getting below error while trying to connect the db.

Error:

error details: The operation has timed out.

Activity ID: a512f4fd-1df3-4cf4-b9fd-43516309752f

so I want to know what are the things need to enable in azure postgresql. for accessing locally we whitelist ip's so able to access from pgadmin client tool so want to what are the things need to enable for accessing from ADF.

Thanks & Regards

Aravind

Azure SQL Database
Azure Storage
Azure Storage
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator
    2024-01-05T08:04:32.28+00:00

    Hey,

    ADF has a static range of IPs based on region in which it is hosted.

    https://feedback.azure.com/d365community/idea/43f8a7e0-7126-ec11-b6e6-000d3a4f032c

    You can whitelist all the IPs mapping to ADF region in the server to access Postgre from ADF.

    Else you can leverage a self hosted IR and try accessing it

    0 comments

Your answer

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