I need help here, so my task is to perform upsert in the ADF pipeline for PostgreSQL. The way that I tried to do is with simple copy activity but is not allowing me to do write behavior for the postgre db. So the way that I'm tring now is with stored procedure activity, but the activity is not allowing me to create a linked service to the postgre db. If not with stored procedure then how is possible to do upsert? Anyone who can help? Thanks in advance!

CodePudding user response：

Add a data flow activity to your pipeline canvas and in there add your Postres source, then us an Alter Row activity to define your upsert rules.