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
suresh dupadasuresh dupada 

Sql Server to salesforce Integration

Hello Everybody!

           I am new to integration part, Now i have an requirement  I have an Sql Server 2012 on Premise, So I would like to pull the data from sql server database to salesforce automaticlly on regular interval basis( 2 to 3 times a day)....... Is there any better approach for this 

We need to move data from sql server to salesforce........... 
     Please specify is there any open source tools or paid tools......

I would appriciate for any kind of replay
 
NagaNaga (Salesforce Developers) 
Dear Suresh,

SIS Integration Toolkit for Salesforce takes advantage of the flexibility and power of Microsoft SQL Server Integration Services (SSIS) platform, which made it possible to integrate with virtually any application or data source that you may need to work with. 

SSIS Integration Toolkit for Salesforce is extremely easy to use. It comes with the following three major components to help facilitate the integration development. 

Salesforce Connection Manager
Salesforce Source Component
Salesforce Destination Component

The ultimate goal of the toolkit is to simplify the integration development work, so that you can spend more time focusing on resolving business issues. A data migration / integration development can be done as quickly as a few minutes, instead of weeks or months

Please follow the below link for more info

https://www.kingswaysoft.com/products/ssis-integration-toolkit-for-salesforce

Best Regards
NagaKiran
 
Osvald MarkusOsvald Markus
To pull your data from SQL server to Salesforce automatically on a regular interval basis ( 2 to 3 times a day) try cloud-based service - Skyvia (https://skyvia.com/data-integration/integrate-salesforce-sql-server). It`s a no-coding solution where you can set-up updates ( up-to-one minute) with no additional efforts.
 
James CrennanJames Crennan
Hey all - I'm chairman at DreamFactory.com. We have a secure, cloud hosted, HTTPS proxy built for API integration with behind-the-firewall data stores like SQL Server. DreamFactory is OSS and you can kick the tires or reach out and our team will be happy to get your data flowing.
Michael TomarMichael Tomar
There are several ways to intehrate SQL Server to Salesforce: https://skyvia.com/blog/5-ways-to-connect-salesforce-to-sql-server