Unable to create a Linked Service connection from ADF to Azure Cosmos DB PostgreSQL Cluster

Question

Hi Team,

I am facing issue when creating a linked service from ADF for Azure Cosmos DB for PostgreSql CLuster.. Please help me to resolve the issue.

1. Cluster is running.
2. Public endpoint is enabled with ip range 0.0.0.0 to 255.255.255.255
3. The cosmos DB and ADF both are in same subscription and region.

Answer 1

@Abhijit Sarkar - Thanks for the question and using MS Q&A platform.

Could you please confirm if you are using Azure CosmosDB for NoSQL or Azure CosmosDB for PostgreSQL cluster?

The endpoint for Azure CosmosDB for NoSQL should be as shown below:

The endpoint for Azure CosmosDB for PostgreSQL should be as shown below:

Note: In case, if you are using Azure CosmosDB for PostgreSQL, you need to use Azure Database for PostgreSQL linked service and not Azure CosmosDB for NoSQL.

For more details, refer to How to ingest data by using Azure Data Factory in Azure Cosmos DB for PostgreSQL.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.