How can I use a Azure Database for PostgreSQL in a Azure Logic App?

Question

To simulate a device I want to use a Logic App to fill a Azure Database for PostgreSQL with test data.

I found the two connectors PostgreSQL and SQL server but unfortunately both don't work for me. The PostgreSQL connector does only support onpremise databases and neither the autodetection nor the manually input of the connectionstring works with SQL Server.

Would great if somebody could give me a hint how to write data into a Azure Database for PostgreSQL from a Logic app.

Answer 1

Unfortunately, there is no connector available for this as of today.

The current alternatives would be

• Use Azure Functions (which can be called from Logic Apps if required)

• Create Custom APIs and a Custom Logic App Connector

Also, there is a feature request on UserVoice that you may upvote to gain traction.