Create a new connection

Create a new connection to the linked data mart.

  1. Select the Data Sources tab.
  2. Right click on All Connections and select Edit Connections.
  3. In the System Connections window, click the plus sign to add a new connection.
  4. Create a connection to the linked server.
    Connection Name

    Enter the name for the linked data mart.

    Database Platform

    Select the platform of the linked Data Mart database.

    Servers

    From the drop-down field, select the linked server.

    This connection will be used as

    Select Data Mart from the drop-down list.

  5. Click Test Connection to test the new connection. Click OK to save.