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
Vimal Bhavsar 6Vimal Bhavsar 6 

Connection between SQL server 2008 and Salesforce Object

Hi,

I want to do one functionality as below.

When i create any " New Account " to salesforce i want to insert that " Account Information " into the Account Table created  to my  SQL Server 2008 R2.

How can i develop this functionality ? can any one please suggest me easiest and simple way for the same.
SANKAR NSANKAR N
Hi,

 1. Best way to do integrate with informatica or any tool to insert into Server 2008. Like you can establish connectin between informatica to Server and informatica to salesforce. Then informatica pull data from sfdc and push it into sql server. 

 2. Using java, you can consume partner wsdl in java to establish connection as well using jdbc establish connection to sql server, then create wsdl to consume in salesforce. 

Regards,
SN
Deepak RamaDeepak Rama
You could use DBAmp (http://www.forceamp.com) for better control on the integration. Run a SQL Server job to monitor salesforce accounts and if any new account is created, it can be inserted into your sql server table. Informatica would work, however it is expensive. If you have in-house expertise on SQL Server, I would recommend using DBAmp.
Osvald MarkusOsvald Markus
I recommend you to take a look at Skyvia (https://skyvia.com/data-integration/integrate-salesforce-sql-server)- cloud-based solution where you can set up data transferring from Salesforce to SQL Server without any coding at all.