REST service for a sql database to access from Salesforce without using paid pipelines

ParxisConsult 21 Reputation points
2022-08-16T10:41:58.027+00:00

Hi all,

I have a requirement to retrieve/sync SQL database with Salesforce. The client does not wish to use the paid pipelines provided using Azure data factory.

My question is how is the SQL database exposed for a interaction with for example an apex HTTP callout?

In apex we use an endpoint url to do e.g. a get request. I am missing the part on how to get that URL endpoint for my SQL server database. In other words.. how to make my apex class be able to talk to the SQL database on azure.

I am really stumped on this one.

Any ideas are welcome.

Azure SQL Database
{count} votes

Accepted answer
  1. Oury Ba-MSFT 16,731 Reputation points Microsoft Employee
    2022-08-18T19:03:08.353+00:00

    Hi @ParxisConsult

    My question is how is the SQL database exposed for an interaction with for example an apex HTTP callout?

    The easiest way – today – to make Azure SQL reachable via HTTP is using Azure Function Bindings and create a simple Azure Function that allows an HTTP request to be received and then execute CRUD operation on the database. You can apply one or more output bindings to an Azure Function with an HTTP trigger to insert/update data in an Azure SQL Database.
    https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-azure-sql

    Hope this answers your question.

    Regards,
    Oury


0 additional answers

Sort by: Most helpful