question

GabryelAndrzej-7119 avatar image
0 Votes"
GabryelAndrzej-7119 asked MikeUrnun edited

Logic app trigger on insert to client postgresql server

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?


azure-logic-apps
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MikeUrnun avatar image
0 Votes"
MikeUrnun answered MikeUrnun edited

Hello @GabryelAndrzej-7119 - 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://docs.microsoft.com/en-us/answers/questions/252204/can39t-connect-to-an-azure-database-for-postgresql.html

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@GabryelAndrzej-7119 Just following up on the answer above, I hope it brings clarity and helps you plan better for your Logic Apps workflow.

0 Votes 0 ·

HI @MikeUrnun
Yes this answer helped me a lot. I will try to develop Azure function. I was also wondering if I can somehow use "When an item is created" trigger for Nube IO DB?

0 Votes 0 ·
MikeUrnun avatar image MikeUrnun GabryelAndrzej-7119 ·

@GabryelAndrzej-7119 Glad to hear that it was helpful. I'm not able to find much on Nube IO DB but the SQL Connector is only for the SQL DB technology so I don't think it'll work with it. But if they provide REST API or any other interfacing services, I'm sure that there is an Azure service that can work with it.

1 Vote 1 ·