Need help to connect to the SQL Server Linked Servers

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Microsoft SQL Server
Post Reply
abdul.aleem
Posts: 2
Joined: Tue 18 Jul 2017 22:51

Need help to connect to the SQL Server Linked Servers

Post by abdul.aleem » Tue 18 Jul 2017 23:53

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.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Need help to connect to the SQL Server Linked Servers

Post by Pinturiccio » Fri 21 Jul 2017 13:05

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

inhaianhsaigon
Posts: 1
Joined: Sun 29 Oct 2017 12:35

Re: Need help to connect to the SQL Server Linked Servers

Post by inhaianhsaigon » Sun 29 Oct 2017 12:42

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?
Last edited by inhaianhsaigon on Fri 14 Sep 2018 07:29, edited 12 times in total.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Need help to connect to the SQL Server Linked Servers

Post by Pinturiccio » Tue 31 Oct 2017 17:07

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?

aricamartin
Posts: 1
Joined: Wed 31 Oct 2018 09:40

Re: Need help to connect to the SQL Server Linked Servers

Post by aricamartin » Wed 31 Oct 2018 09:47

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.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Need help to connect to the SQL Server Linked Servers

Post by Pinturiccio » Fri 02 Nov 2018 13:49

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

Post Reply