unable to integration sql server to salesforce
I want to integrate sql server to salesforce and update records in sfdc
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
There's a number of offerings on the app exchange for connecting SQL server to Salesforce. One of the well regarded ones is dbamp - there's full details of their offering at:
You could also achieve this via an ODBC driver - again there are a few providers - here's one example:
I've also seen that people have achieved this using the free Jitterbit dataloader, but that's not something I've done myself. There's more information on setting this up at:
There's also an open source offering for SSIS that has a Salesforce connector - I've never used this though:
Adding to the above answer a very good tool which is also open source is Talend that can connect sfdc and SQL servers
Talend provides outofbox connectors and drivers and you will need to just handle the mappings more like informatica on demand .Informatica is paid tool while basic version of Talend is open source and freely available .
Late to the party with this answer but hope it helps others...
Salesforce - SQL integration has been a key part of my job for the last 9 years for both on premise backups to SQL of Salesforce and SSIS packages to run adhoc / scheduled uploads to and extracts from Salesforce via SQL / SSIS.
...by Sesame Software has been very effective in both roles and comes highly recommended.
I did a review of the alternatives (including DBAmp) 12/18 months ago and still found Relational Junction to have many features which we consider essential that were missing or painfully implemented in other offerings.