function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Honey Bhatnagar.ax747Honey Bhatnagar.ax747 

Integration of Salesforce and SQL server using Sql Server Integration Services

Hi friends,

 

I need some information about the integration of Salesforce and SQL server using Sql Server Integration Services. If you have done it before in you rprojects. Could you please share the following information with me:-

 

1. Challenges faced

2. Complexity of the Integration

3. Sample Code

4. Level of Coding Required

5. New functionality you came acsross

 

If you could also share the details about your the project and the type of integration that will also be helpful.

Mr. E.Mr. E.

Been there and done that, but I don't work for free and am certainly not handing over my code.

 

But I will point you to Ivan's cool product:  http://www.cozyroc.com/ssis/salesforce-source

Honey Bhatnagar.ax747Honey Bhatnagar.ax747

Thanks for you reply. Its not just the sample code that I require. I want to undertstand the complexity of the work also.

Could you share your experience briefly.

danaledanale

I did a cursory search and found this thread on making SQL database connections via APEX. Maybe this will help?

http://community.salesforce.com/t5/Apex-Code-Development/Making-SQL-database-connections-from-APEX-code/m-p/99146

KingswaySoftKingswaySoft

Our company has just released a product called SSIS Integration Toolkit for Salesforce, which is available for download at http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-salesforce. You might find it useful. 

Thanks!

AmitSahaiAmitSahai

Hi Kingsway Soft newbie,

 

The product you have released seems to work within SQL server environment pulling data from Salesforce and updating data into Salesforce.

 

What about the scenario wherein Salesforce wants to pull and push data into SQL server..does the tool help in that direction or people need to resort to calling Webservices etc....Directly from Apex can connection be made to SQL server or not ??

KingswaySoft SalesKingswaySoft Sales

@AmitSahai, sorry for the slow response. The toolkit that we have developed supports both reading data from or writing data into Salesforce.com platform. SSIS itself supports virtually all data sources, so technically speaking, you can use SSIS Integration Toolkit for Salesforce to do integration between Salesforce and any other database or applications, including SQL Server itself. You won't need to write any web service code if you are using our toolkit. For further details, please check our website, or contact us using emails

 

Thanks for your interests in our offering. 

 

Kindest regards,

KingswaySoft Sales

Data Loader 5Data Loader 5
Hi! For bi-directional Salesforce and SQL Server Synchronization with no coding you can try a 3rd party service Skyvia (https://skyvia.com/data-integration/integrate-salesforce-sql-server).
JasonDJasonD
The topic is quite old but I'd like to recomend these SSIS Salesforce Data Flow components (https://www.devart.com/ssis/) They inlcude Salesforce Source, Lookup and Destination components, and awesomely easy to use
Nancy raiNancy rai
Hello, Honey
Check this out:  SSIS Salesforce (https://zappysys.com/products/ssis-powerpack/ssis-salesforce-integration-pack/)
This Article covered all of our required parameters.
Hope it will be helpful for you.
Brian Knight 20Brian Knight 20
Hi, 
I wrote a blog a while ago that will show you how to incrementally load from SalesForce into another component using SSIS. The code there should help build it out and please feel free to email me if you have any issues with it (email address is on the blog). 

http://blog.pragmaticworks.com/incrementally-loading-data-from-salesforce.com

I'm using a component called Task Factory to connect or write to SalesForce. You can find all the videos that walk you through it in the Resources section here: https://pragmaticworks.com/Products/Task-Factory/Feature/Salesforce-SSIS

Hope that helps!
 
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
Michael TomarMichael Tomar
Hi, we estimated that the most convenient way to integrate SF with SQL server is by using 3rd-party tools such as Skyvia (it's already mentioned here). It is a web-based platform, so you don't need to install it. Skyvia requires no coding and no complex configuration. It provides a few ways to connect SF with SQL server, learn more here: https://skyvia.com/blog/5-ways-to-connect-salesforce-to-sql-server
Millar DakkimMillar Dakkim
Alas, there is no detailed description when working with databases in the salesforce itself. My recommendation for you is to check the ado.net connection string (https://www.devart.com/dotconnect/connection-strings.html), which will provide an opportunity to explain with understanding dotConnect for Oracle supports two connection modes: OCI and Direct. In the OCI connection mode, dotConnect for Oracle uses Oracle Client software to connect to Oracle. In the Direct mode, dotConnect for Oracle connects directly and does not require Oracle Client.