CODEWITHSUNDEEP
postgresqlazure-data-factory
Sonam
Sonam

Reputation: 83

Execute PostgreSql stored procedure in azure data factory

I have a requirement to execute Azure PostgreSQL stored procedure using Azure Data Factory. Is there any way to do the same. I found that Stored Procedure activity only supports SQL procedures.

Basically I have some staging tables in PostgreSQL and I want to load data into target tables(in PostgreSQL). I have written some stored procedures to apply transformations and load data. I want to run those stored procedures in ADF. Is there any other suggested option to achieve this. TIA!

Upvotes: 4

Views: 4727

Answers (2)

Purna Chandra Dash
Purna Chandra Dash

Reputation: 41

There is a way to execute the PostgreSQL function from Azure Synapse Analytics or Azure data factory. use lookup activity with query as "select function-name()"

Upvotes: 4

Steve Johnson
Steve Johnson

Reputation: 8660

Yes, Stored Procedure activity doesn't support Azure PostgreSQL stored procedure. It only supports Azure SQL Database, Azure Synapse Analytics and SQL Server Database. So you can try to delegate the call to PostgreSQL with Azure Function as Joel said.

Upvotes: 1

Related Questions