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
cscordocscordo 

Q:Moving from SQL Server to SF

We currently have an internal application running off of a (somewhat) normalized SQL Server DB and we are evaluating a potential migration of the app/data over to SF. 

Question:  Is there a tool which will allow us to easily export all of our customers (4000+), leads (2000+) and vendors (500+) over to the SF platform directly from SQL? 

(ie. I'm assuming this would utilize a data junction). 

Thanks, Chris

adamgadamg

Yes, Data Junction would work.  You could also write your own ETL code in .NET or Java, or see if there is another partner solution that meets your needs at http://salesforce.com/crmsolutions.

You might also want to take a look at Custom Objects if there are data types you need to model that we don't have out of the box.

cscordocscordo
I guess what I want to find out:  Will Data Junction allow us to bulk export everything from our SQL DB to SF with mappings, or do we need to get one of the 3rd party tools?
adamgadamg
Data Junction is a third party tool, and my guess is that it should meet the requirements you describe..
openaccessopenaccess

You can use the OpenAccess ODBC Driver for Salesforce to give SQL Server direct access to the salesforce application.  This would allow you to connect Salesforce to SQL Server using the Linked Server feature of SQL Server.  Once linked, queries can be issued to select from SQL server table and insert into the corresponding Salesforce table.  This will allow you to use the power of SQL to perform all required mapping.

You are welcome to download a preview version of the OpenAccess ODBC Driver for Salesforce.com. It is available at:

http://www.OpenAccessSoftware.com/support/SalesF-Files-Index.asp

The preview version allows read/write access to Salesforce using the SQL commands SELECT, UPDATE, DELETE, and INSERT. It will expose all the objects you have acess to, including any custom objects/fields you have added. Please try it out and give us your feedback.

Using the OpenAccess ODBC Driver for Salesforce allows any application or development tool that is able to access data from databases like SQL Server and Oracle to access your data at Salesforce.com.

OpenAccess Team
http://www.OpenAccessSoftware.com

Osvald MarkusOsvald Markus
Take a look at Skyvia (https://skyvia.com/data-integration/integrate-salesforce-sql-server)- cloud-based no-coding integration service. With help of it, you can easily export all your data, literally in few clicks.