How to update the azure PostgreSQL table using Data Factory?

Question

How to update the azure PostgreSQL table using Data Factory?

Venkateswara Tolla 1

Is possbile to update the azure PostgreSQL table using Data Factory?

HarithaMaddi-MSFT 10,146 Reputation points

2020-09-19T10:19:12.653+00:00

Hi @Venkateswara Tolla ,

We have not received a response from you. Please suggest if any of the below answers helped clarify the question. Otherwise, let us know and we will continue to engage with you on it.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
HarithaMaddi-MSFT 10,146 Reputation points

2020-09-21T13:49:31.767+00:00

Hi @Venkateswara Tolla ,

We still have not heard back from you. Following up to check if any of the below answers helped clarify the question. Otherwise, let us know and we will continue to engage with you on it.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

2 answers

Your answer

HarithaMaddi-MSFT 10,146 Reputation points

2020-09-19T10:19:12.653+00:00

Hi @Venkateswara Tolla ,

We have not received a response from you. Please suggest if any of the below answers helped clarify the question. Otherwise, let us know and we will continue to engage with you on it.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
HarithaMaddi-MSFT 10,146 Reputation points

2020-09-21T13:49:31.767+00:00

Hi @Venkateswara Tolla ,

We still have not heard back from you. Following up to check if any of the below answers helped clarify the question. Otherwise, let us know and we will continue to engage with you on it.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Answer 1

Evgeny Grishchenko 486

Based on this matrix the answer is no

Answer 2

HarithaMaddi-MSFT 10,146

Hi @Venkateswara Tolla ,

Yes, As @Evgeny Grishchenko mentioned, there is no direct provision to update data in PostgreSQL table from Azure Data Factory(ADF). I am assuming you are planning to use ADF to load data from other data sources into PostgreSQL. If that's the case, I can think of an approach of maintaining a staging table on which triggers can be enabled every time to run upsert logic on actual table in the PostgreSQL.

I would recommend you to provide feedback at the feedback forum. All the feedback you share, is closely monitored by the Data Factory Product team and implemented in future releases.

Please suggest for more queries on specific requirement and we will be glad to assist.

Baiju Thakkar 0 Reputation points

2024-01-30T13:33:21.29+00:00

We have similar requirement where we extract/copy rows from postgresql database and then have to timestamp the rows that it has been extracted successfully. So steps are, in ADF using copy activity we copy the rows from postgresql database and then go back to the table and flag that it has been extracted successfully. ADF do not support postgresql connector as sink, so what will be the alternative solution in that case. Thanks and sorry to piggyback on the old thread.

Share via

How to update the azure PostgreSQL table using Data Factory?

2 answers

Your answer