+ Start a Discussion
Keith Stephens 18Keith Stephens 18 

salesforce to azure db

Hello All,
I need to be able to update an Azure database from Salesforce.  Mainly for Cases and Lawyers, when cases or lawyers get updated I need to update the Azure DB as well.
I have seen the examples that talk about Azure to Salesforce, but I have not seen anything talking about Salesforce to Azure.
I have looked at both the Salesforce WCF and RestAPI https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/
But again these go from Azure to Salesforce.

Is it possible to go the other way?  What would be the best approch to this as I have seen many differnt approches to connecting.
We don't want any syncing of data, just to make a .NET call when Salesforce records get updates ect.. to update our Azure DB.
Thanks,
K.
NagendraNagendra (Salesforce Developers) 
Hi Keith,

Below are some useful links which will help you to start.  
Hope this helps you!

Please accept my solution as Best Answer if my reply was helpful. It will make it available for other as the proper solution.

Thanks,
Nagendra
Keith Stephens 18Keith Stephens 18
Sorry, but I have seen these already, we do not want to pay for a 3 party app so Skyvia is out of the question as is apirise.
The Azure data-factory is more of a syncing tool that runs in a timly interval, I am needing a .NET WCF or Rest solution that when Salesforce information is updated, deleted, inserted ect.. It will do the same to our Azure DB, more realtime, from a Salesforce trigger or something.
All the posible solutions I have found go from Azure DB to Salesforce, but not Saleforce to Azure DB.

Has anyone done this?  What is the best option?  Are there any web sites that have examples of this?  Is there a better way without paying for 3rd party products.
Stojan FiedorStojan Fiedor
You can easily update Azure database from Salesforce with the help of Skyvia (https://skyvia.com/data-integration/integrate-salesforce-sql-azure). It is a code-free web service with flexible scheduling settings. Free plan available
Nikhil HariNikhil Hari
Hi Keith

Did you find a solution? I'm doing something very similar but I need to sync both ways i.e azure db to SF and SF to azure.

What did you use for syncing from azure db to SF?

Thanks
Nick
Keith Stephens 18Keith Stephens 18
Unknown to my knowledge we have an Enterprise edtion of a tool called CData, this is what I used. Then we just setup a job to run every 5 minutes.
aniroodha deodharaniroodha deodhar
Hi Keith,

Thanks for your update.
Can you please share some knowledge/link (even something brief) on this CData tool, it will be really kind of you.

Thanks in advance.

Regards,
Aniroodha
Keith Stephens 18Keith Stephens 18
https://www.cdata.com/ado/ - To download the .net ado drivers.
http://cdn.cdata.com/help/RFD/ado/ - documentation how how to use.
 
aniroodha deodharaniroodha deodhar
Thanks again. That was really fast!!