Logic app trigger on insert to client postgresql server

Question

Hi,

I need to ingest new data from customer postgre sql database to data lake. They have one table from which I should download data. I wanted to used logic app for this. It would trigger each time when the new row is inserted to database and insert new data to my data lake. I was thinking to use logic app to do it. However when I try to use "When an item is created" trigger for SQL Server I do not now how to fit these information.

end-point:
port:
db:
user:
pass:

I was able to connect to to this server using ADF so connection works correctly for sure. How can I set logic app to trigger when a new row is inserted. Or should I use different Azure resource to achieve this?

Answer 1

Hello @Gabryel, Andrzej - Welcome to MS QnA, and thank you for posting here!

MS SQL & PostgreSQL are different databases, and unfortunately, there is no trigger available in the PostgreSQL connector as of today. For more info, please review the answer to a similar question here: https://learn.microsoft.com/en-us/answers/questions/252204/can39t-connect-to-an-azure-database-for-postgresql.html