You need to sign in to do that
Don't have an account?
![Honey Bhatnagar.ax747 Honey Bhatnagar.ax747](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
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.
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
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.
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
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!
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 ??
@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
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.
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!
For a trial copy, email me at rhard2651@gmail.com