question

Jannick-7987 avatar image
0 Votes"
Jannick-7987 asked AnuragSharma-MSFT commented

Can't connect to an Azure Database for PostgreSQL server via Azure Logic App

Hi everyone,

I am having trouble connecting to my Azure Postgres database via an Azure Logic App.
When connecting from my PC everything works fine !

For testing purposes I've configured the database as seen here:
62135-connection-security.png
This is how I try to connect and the error I get:
62122-logic-apps-designer.png



Does anyone have an idea? I am really stuck here...



Thanks in advance,
Jannick

azure-sql-databaseazure-logic-appsazure-database-postgresql
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.

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered AnuragSharma-MSFT commented

Hi @Jannick-7987, welcome to Microsoft Q&A forum.

As per the screenshot, you are trying to use the SQL connector to connect to Azure PostgreSQL. The issue here is currently there is no connector or trigger available to connect Azure logic apps with Azure Database for PostgreSQL. The connector which is available for PostgreSQL can only connect with on-premise version of PostgreSQL.

You can refer to stack thread for more details where it provides a way to connect Azure PostgreSQL through Azure function and call it from Azure Logic App. Article mentions couple of alternatives for the same.
https://stackoverflow.com/questions/55870598/how-can-i-use-a-azure-database-for-postgresql-in-a-azure-logic-app

You can also upvote the feature on the user voice:
https://feedback.azure.com/forums/287593-logic-apps/suggestions/36672061-add-trigger-and-connector-for-azure-postgre-sql


If answer helps, please mark it 'Accept Answer' as it could help other community members having similar queries.



· 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.

Okey that's bad :D
Is there an connector for other databases than Azure Database for PostgreSQL like Azure Database for MySql or Azure Database for MariaDB ?
So can I connect to any serverless Azure database from Logic apps ?

0 Votes 0 ·

Azure SQL DB has a serverless tier - can you use that?

When using serverless - you also need to ensure the correct logic to wait for it to start up if it has been dormant.

0 Votes 0 ·

Unfortunately some of these databases don't have connectors available as of now to directly connect with Azure Logic Apps. However, we can connect using the same way by using Azure functions and call the functions from Azure Logic Apps until we have these connectors available.

You can refer to below link for connectors which are available as of now:
https://docs.microsoft.com/en-us/azure/connectors/apis-list

For MySQL as well you can upvote the feature on user voice:
https://feedback.azure.com/forums/287593-logic-apps/suggestions/32348629-azure-mysql-connector


0 Votes 0 ·
learn2skills avatar image
0 Votes"
learn2skills answered Jannick-7987 commented

Hi @Jannick-7987

Please check if it could help at your side:
Automate workflows for a SQL database by using Azure Logic Apps

Steps to resolve persistent connectivity issues


If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.


· 1
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.

No, unfortunately this doesn't help

0 Votes 0 ·