Search

Mode

Mode

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

Prerequisites

Before you connect, you must first do the following:

  • Connect a data source to your CData Connect Cloud 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 Cloud

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

  1. Log into Mode.

  2. On the Discover page of Mode, click Connect a Database.

  3. On the next screen, select Microsoft SQL Server.

  4. Enter the following Microsoft SQL Server settings.

    • Display name—enter the name of your connection for display purposes.
    • Host—tds.cdata.com
    • Post—14333
    • Database name—enter the Connection Name of the CData Connect Cloud data source you want to connect to (for example, Salesforce1).
    • Username—enter your CData Connect Cloud username. This is displayed in the top-right corner of the CData Connect Cloud interface. For example, test@cdata.com.
    • Password—enter the PAT you generated on the Settings page.

    Leave the rest of the connections settings at their default values unless you need to modify them.

  5. Click Connect. If the connection succeeds, a success message appears. Your connection is now available for use in Mode.

  6. Repeat the steps above to connect to additional CData Connect Cloud sources, changing the Database name for each one.

You can now create a Mode visualization with the CData Connect Cloud data. Follow the steps below.

  1. After your connection succeeds, click New Report. The SQL query text editor appears.

  2. Enter a SQL query for your data, such as SELECT * FROM [Sharepoint].[MyCustomList];.

  3. Click Run to run the query. The data appears below.

  4. Click +New chart to create visualizations from the data.