Search

SQL Server Linked Server

SQL Server Linked Server

This page outlines the steps to connect SQL Server Linked Server to the CData Connect Virtual SQL Server API.

Prerequisites

Before you connect, you must first do the following:

  • Connect a data source to your CData Connect account. See Connections for more information.
  • Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

Connecting to CData Connect

To establish a connection from SQL Server Linked Server to the CData Connect Virtual SQL Server API, follow these steps.

  1. Open Microsoft SQL Server Management Studio.

  2. In the Object Explorer pane, open Server Objects, right-click Linked Servers, and select New Linked Server.

  3. The New Linked Server dialogue opens. On the General page, enter the following information:

    • Enter a memorable name for the server in the Linked server field.

    • Select the radio button Other data source and select Microsoft OLE DB Driver for SQL Server as the provider.

    • In the Data source field, enter tds.cdata.com,14333

    • In the Catalog field, enter enter the Connection Name of the CData Connect data source you want to connect to (for example, Salesforce1).

  4. Select the Security page. At the bottom, select the radio button labelled Be made using this security context and enter the following information:

    • Remote login—enter your CData Connect username. This is displayed in the top-right corner of the CData Connect interface. For example, test@cdata.com.

    • With password—enter the PAT you generated on the Settings page.

  5. Click OK to create the server.

Your linked server can now be used to access the data in the data source you specified. If you need to access data from more sources, create another linked server for each one.