Search

Redash

Redash

This page outlines the steps to connect Redash 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 Redash to the CData Connect Virtual SQL Server API, follow these steps.

  1. Log into Redash.

  2. Click the settings widget on the top right.

  3. Click New Data Source.

  4. Select Microsoft SQL Server as the Data Source Type.

  5. On the configuration tab, set the following properties:

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

    • Server: enter the virtual SQL Server host name (tds.cdata.com)

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

    • Password: enter the PAT you generated on the Settings page.

    • Port: enter 14333

  6. Click Create.

  7. Click Test Connection to ensure that the connection is configured properly.