execute stored proc in postgress

Question

Hello
how is it possible in ADF, I execute a postgress stored procedure?

I can do this for the sql server stored proc but not sure how to do this for postgress stored proc.

Thank you

Answer 1

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

Azure Data Factory does not support a built-in PostgreSQL stored procedure.

According to the offical documetation: You can use the Stored Procedure Activity to invoke a stored procedure in one of the following data stores in your enterprise or on an Azure virtual machine (VM):

• Azure SQL Database
• Azure Synapse Analytics
• SQL Server Database.

As a workaround, you can checkout 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.