Azure Synapse Analytics | Pipeline | Linked Service to "Azure Database for PostgreSQL" not available in 'Stored Procedure'

Question

Hi everyone,

I am trying to create a simple pipeline in Azure Synapse Analytics which should write some files' metadata fields into a Database.

To do so, I first created a linked service to a postresql database instance hosted on Azure:

I am now trying to reference the linked service above from a 'Stored Procedure' block within my Pipeline, but unfortunately it does not appear as available:

I guess the reason for this is that "Azure Database for PosgreSQL" in not among the resources list that can be referenced from a "Stored Procedure" block.

In fact, if I try to create a new linked service from the dialogue box above, "Azure Database for PostresSQL" is not listed as a possible choice.

Is there an alternative way to reference an "Azure Database for PostresSQL" Linked Service from within a 'Stored Procedure' block of a pipeline?

I am new to Azure Synapse Analytics, any help is highly appreciated :)

Cheers!

Answer 1

Hi @Lorenzo Perino

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

As per the Azure Synapse Analytics documentation, the Stored Procedure activity only supports Azure SQL Database, Azure Synapse Analytics, and SQL Server Database. Therefore, you cannot directly reference an "Azure Database for PostgreSQL" linked service from within a 'Stored Procedure' block of a pipeline.

As a workaround, you can check out the below threads which addressing similar issue:

• Execute PostgreSql stored procedure in azure data factory
• Cannot run stored procedures for postgreSQL in azure

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.