+ Start a Discussion
Sreejith KalarikkalSreejith Kalarikkal 

How can i do a bi-directional integration between sql server and salesfoce ? It has to be real time bi-directional sync ..

Raj VakatiRaj Vakati
Hello Sreejith,

If you are planning to use ETL link Informatica or snap logic, you can schedule bi-directions sync using the ETL. 

If you wanted to implement on your own, you can use SOAP API from Salesforce and Use any other API to connect to SQL server. Schedule your code execution by using any Schedule options. 

Note: - Maku sure you sync only the unmatched data to avoid overhead. 

Darley Stephen PMDarley Stephen PM
you can try Trueloader  https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000EiPC4UAN, you have to make sure your conditions are good enough to do the bi-directional sync otherwise you might get duplicates or overhead on extraction.
Osvald MarkusOsvald Markus
To do real-time bi-directions sync between Salesforce and SQL server (https://skyvia.com/data-integration/integrate-salesforce-sql-server) I recommend you to use service like Skyvia. With help of it, you can easily set-up synchronization, literally in few clicks and without any coding at all.
Michael TomarMichael Tomar
As Osvald mentioned, the most time-efficient way to connect SF with SQL Server is by using 3rd-party tools such as Skyvia. It provides near real-time integration and has a simple user-friendly UI. To create this connection, follow the steps described in this tutorial: https://skyvia.com/blog/5-ways-to-connect-salesforce-to-sql-server