5

Is there any way to perform the CRUD operation on the SalesForce object and fields from SQL Server queries like SSIS, or anything?

  • I know about forceamp.com for one but it's paid. Never used it but my colleague seemed quite happy with it. No idea about free packages, search for "Salesforce.com ODBC connector"? Another thing that comes to mind is informatica on demand but sounds like overkill... Also: salesforce.stackexchange.com/questions/5002/… – eyescream May 30 '13 at 8:23
4

The free jitterbit salesforce data loader does that.

You can hook up the source as a SQL database, pick a table, create your query, and then set your target as your salesforce object. And then you can have it run on a schedule.

I currently have it grabbing data from a oracle11g database and upserting to SF every minute. Shockingly awesome that it's free.

http://www.jitterbit.com/solutions/salesforce-integration/salesforce-data-loader/

  • Not sure if this is the right URL, but it's saying that it's free for a 30 day trial. Is the URL still pointing to the right place? – AngryHacker Sep 5 '14 at 20:18
  • Looks like it may have changed. Used to be a downloadable thing. The cloud version is newer. – Shane McLaughlin Sep 6 '14 at 14:42
2

Informatica power-center or on demand can be used to connect SQL and sfdc.There are other integration tools such as Dell bhoomi or Cast iron with SQL connectors and SFDC connector that can help in data import and export

2

I have used Talend for such integration. It is free and there is Salesforce connector available out of the box. It is also great that you can export your integration job to a .bat file and schedule it with some tool i.e. Windows Scheduler so that your integration will run at a specified time daily or whenever you need.

0

For this reason I've been trying Skyvia data loader, this tool helped me to connect SQL Server with Salesforce. It's quite simple, online and free.

Also you can let all operations execute automatically on schedule or manually at any time.

New contributor
juliaM_01291 is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.