Thank you for reaching out to the community forum with your query.
I understand that you are trying to execute a stored procedure in a PostgreSQL server within an Azure Data Factory (ADF) pipeline, but your linked service does not appear as an option. Unfortunately, ADF does not currently support stored procedures in PostgreSQL.
However, there are a few workarounds that you can try to execute your PostgreSQL stored procedure within an ADF pipeline:
- Use an Azure Function to execute the stored procedure: You can create an Azure Function that connects to your PostgreSQL server and executes the stored procedure. Then, you can call this Azure Function from your ADF pipeline using the Azure Function activity.
- Use a custom activity: You can create a custom activity in ADF that connects to your PostgreSQL server and executes the stored procedure. You can use a .NET custom activity or a Python custom activity to achieve this.
- Use a third-party connector: You can use a third-party connector like the CData PostgreSQL Connector for ADF to connect to your PostgreSQL server and execute the stored procedure.
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.