function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
muralikrishna gondimuralikrishna gondi 

free tools for sql server integration with salesforce?

Currently i am using data loader for data import manually.
I have a requirement like to schedule data import nightly basis.So i  am trying to intigrate sqlserver with salesforce.is there any open source tools for intigration and schedule? Please give me suggestion ..
NagendraNagendra (Salesforce Developers) 
Hi Murali,

There is an open source tool offering for SSIS that has a Salesforce connector which might be of good help for you.

May I suggest you please check with below links which might help. Mark this as solved if it's resolved.

Thanks,
Nagendra.
Osvald MarkusOsvald Markus
If we speak about free tools, there is one, it is called Skyvia. With it, you can schedule data import nightly (or when you want) basis, but unfortunately, it is free only till 5k records and +100k CSV import/export, so check this out here is a link to it: https://skyvia.com/pricing
Billy JimenezBilly Jimenez
Thumbs up to Skyvia! We are using it to integrate Salesforce data with the database on SQL Server on a daily basis. The list of features: https://skyvia.com/data-integration/integrate-salesforce-sql-server
richard harding 1richard harding 1
I have a process/tool that exports Salesforce data to sql databases (MS,MYSQL or ORACLE).
 For a trial copy, email me at rhard2651@gmail.com
Juan Carlos NunezJuan Carlos Nunez
Been using Pentaho Community Edition for a few years now to do this (automated SFDC import/export) and it's 100% free.  You can leverage windows or sql server to schedule execution of Pentaho jobs/transformations as well.  I would suggest a dedicated server for it but you can get by with it living next to other resources. Community Edition is a bit hard to find, here's a quick link to the download: https://sourceforge.net/projects/pentaho/files/
SergeiSergei
Here you can find top 5 ways how to integrate Salesforce and SQL Server (including free methods): https://blog.skyvia.com/5-ways-to-connect-salesforce-to-sql-server/