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
Dale GilbertDale Gilbert 

SQL Data, .Net, Data Integration to Salesforce

I believe management wants to integrate our SQL data into Salesforce.
Our data is in SQL Server and as a .Net C# Sql developer I am wondering what I need to learn on Salesforce to get it there.
All I have done in Salesforce is design input screens, layouts, create automated reports.

I know nothing about the API's, Apex, Visual Development.  Where do I start to do automated SQL to Salesforce integration.  I am just getting started and wondered if someone could point me in a logical direction.  Thanks !
SonamSonam (Salesforce Developers) 
Hi Dale,

To go forward with the integration from scratch, you would have get yourself acquainted with salesforce APIs(https://developer.salesforce.com/page/Salesforce_APIs) such that you can access Salesforce from your code and integrate your system with it. There are also available options like data loader(http://www.jitterbit.com/solutions/salesforce-integration/salesforce-data-loader/ & http://salesforce.stackexchange.com/questions/12217/sql-server-integration-with-salesforce) you can also check appexchange apps like informatica:https://community.informatica.com/community/marketplace?view=solution&blkCatIds=mh-tech-24-26+apps
 
Michael ShattuckMichael Shattuck
This is an issue I have run into recently. The answer depends on the type of integration you are looking for. For small amounts of data the soap api can help with insert and upsert. I believe the max is 200 records per transaction. What we wanted was a data upload (sync) that would happen every morning with several thousands of records. For this situation I would recommend using the bulk api which involves creating a bulk job (insert), adding batches of data, and closing the job. 

Because I was running into these issues before I wrote a library to fit all of the situations. https://github.com/clamidity/SalesforceMagic
Hopefully this will help. Good luck!