How to access Azure PostgreSQL database from salesforce ?

Question

Client's Salesforce application need to access Azure PostgreSQL database from Salesforce External Data Source. There are no such readymade connector available in Salesforce. Now questions is how we can allow SF external data source to access Azure PGSQL db. If we need to build some short of OData service for Azure PostgreSQL database, Please share the reference/detailed implementation of this.

Answer 1

Hi @Anonymous ,

Welcome to Microsoft Q&A forum and thanks for using Azure services.

As I understand from the question, you want to connect to Azure PostgreSQL Database from Salesforce.

Regarding connection and data, Azure Data Factory could be used in Azure Portal as described here: https://learn.microsoft.com/en-us/azure/data-factory/connector-salesforce?tabs=data-factory

https://learn.microsoft.com/en-us/azure/data-factory/connector-postgresql?tabs=data-factory

Additionally, you could use STRIIM for data migration from Salesforce to Azure PostgreSQL.

If you are looking specifically to access data from Salesforce, then I would recommend you to raise request in Salesforce Q&A Community forum so that you could get the apt solution with respect to Salesforce.

Hope this helps. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer 2

@Anupam Maiti Thanks for reaching out. As you want to perform CURD operation to postgresql using logic app then logic app does have postgresql connector which you can leverage in your workflow to perform the action listed in here.

So, for individual operations (CURD operation like get row, delete row, insert row and update row) you need to create an individual logic app.

Workflows:

Request Trigger --> Delete row --> Response

Request Trigger --> Insert row --> Response and soon

The individual action document talks about what is the input parameter along with the output if any or dynamic output.

Now you will have different HTTP logic app URL (by creating different workflow) and you can now call your workflow using the HTTP URL that is regenerated by the request trigger.

Let me know if you need any assistance or have any queries or concerns.