Devart Forums

Hi,

I am new to the Salesforce.com, I am trying to import data from Salesforce.com to SQL Server. Our SQL Server is a linked Server, can you please help us by giving steps how can I Connect to Salesforce.com using DevArt drivers from my linked SQL Servers and import data from Salesforce.com into my linked SQL Servers.

Any help is going to be very helpful, thanks in advance friends.

For your goal you can use the following 4 approaches:

1. Linked server to Salesforce
If you want to configure a linked server to Salesforce, you can use Devart ODBC Driver for Salesforce.
To create a link from SSMS to Salesforce, you should configure our ODBC driver https://www.devart.com/odbc/salesforce/docs/index.html on the computer with SQL Server (using DSN is required). Connect to the local server in SSMS, select Server Objects->Linked Server in the object tree, select New Linked Server in the shortcut menu, select Micosoft OLE DB Provider for ODBC Driver in the provider field, specify the created DSN in the Data Source field, specify any names in the Linked Serv and Product Name fields, click OK. If you haven't entered login and password in the DSN settings, you should specify them on the security tab (Remote Login With Password).

After this you can use dotConnect for SQL Server to query data from Salesforce objects as from any other linked server.

2. dotConnect for Salesforce and dotConnect for SQL Server
You can also use dotConnect Salesforce for reading data from Salesforce and then use dotConnect for SQL Server for write data to SQL Server.

3. Devart SSIS Data Flow Components for Salesforce.
You can use the SSIS Data Flow Components for Salesforce product for creating a SSIS package which will import data from Salesforce to SQL Server.

4. Devart Skyvia online tool.
If you want to import data from Salesforce to SQL Server you can use Skyvia - our cloud data integration, access, backup, and management platform. With it you can import data from and to various sources, including from SQL Server to Salesforce.

For more information about import packages in Skyvia, please refer to
https://skyvia.com/data-integration/import
https://skyvia.com/resources/docs/index.html?import.htm

Pinturiccio wrote:For your goal you can use the following 4 approaches:

1. Linked server to Salesforce
If you want to configure a linked server to Salesforce, you can use Devart ODBC Driver for Salesforce.
To create a link from SSMS to Salesforce, you should configure our ODBC driver https://www.devart.com/odbc/salesforce/docs/index.html on the computer with SQL Server (using DSN is required). Connect to the local server in SSMS, select Server Objects->Linked Server in the object tree, select New Linked Server in the shortcut menu, select Micosoft OLE DB Provider for ODBC Driver in the provider field, specify the created DSN in the Data Source field, specify any names in the Linked Serv and Product Name fields, click OK. If you haven't entered login and password in the DSN settings, you should specify them on the security tab (Remote Login With Password).

After this you can use dotConnect for SQL Server to query data from Salesforce objects as from any other linked server.

2. dotConnect for Salesforce and dotConnect for SQL Server
You can also use dotConnect Salesforce for reading data from Salesforce and then use dotConnect for SQL Server for write data to SQL Server.

3. Devart SSIS Data Flow Components for Salesforce.
You can use the SSIS Data Flow Components for Salesforce product for creating a SSIS package which will import data from Salesforce to SQL Server.

4. Devart Skyvia online tool.
If you want to import data from Salesforce to SQL Server you can use Skyvia - our cloud data integration, access, backup, and management platform. With it you can import data from and to various sources, including from SQL Server to Salesforce.

For more information about import packages in Skyvia, please refer to
https://skyvia.com/data-integration/import
https://skyvia.com/resources/docs/index.html?import.htm

can you help me by video?

inhaianhsaigon wrote:can you help me by video?

We do not provide such kind of service.
Please describe you scenario and we will try helping you. Besides, 4 different ways of importing data from Salesforce to SQL Server are listed above. Which of them are you most interested in?

I am getting the issue to install the SQL Server in my system. What should I do to resolve this issue? I also try on antivirus support number for the help purpose but did not get any response.

This question is beyond the scope of our support. For more information please refer to the Microsoft support.