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

Question

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.

Answer 1

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