> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cloud.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ThoughtSpot

> This page outlines the steps to connect ThoughtSpot to the Connect AI Virtual SQL Server API.

## Prerequisites

Before you connect, you must first do the following:

* Connect a data source to your Connect AI account. See [Sources](/en/Sources) for more information.
* Generate a Personal Access Token (PAT) on the [Settings](/en/Settings#personal-access-tokens) page. Copy this down, as it acts as your password during authentication.

## Connect to Connect AI

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

<Steps>
  <Step>
    Log in to ThoughtSpot.
  </Step>

  <Step>
    On the top navigation bar, click **Data**.
  </Step>

  <Step>
    Click **Create new** > **Connection**.

    <Frame>
      <img src="https://mintcdn.com/cdata/L-wC-3th9ZUn-60n/en/images/thoughtspot_client_01.png?fit=max&auto=format&n=L-wC-3th9ZUn-60n&q=85&s=38f016b64d928f8a71896cebe453ae2c" alt="ThoughtSpot Client 01" width="286" height="270" data-path="en/images/thoughtspot_client_01.png" />
    </Frame>
  </Step>

  <Step>
    Name the connection and click "SQL Server".

    <Frame>
      <img src="https://mintcdn.com/cdata/L-wC-3th9ZUn-60n/en/images/thoughtspot_client_02.png?fit=max&auto=format&n=L-wC-3th9ZUn-60n&q=85&s=45af089b6abd57b9c2065cd738e3fda0" alt="ThoughtSpot Client 02" width="1370" height="922" data-path="en/images/thoughtspot_client_02.png" />
    </Frame>
  </Step>

  <Step>
    Click **Continue** on the top right.
  </Step>

  <Step>
    Enter the connection settings.

    * **Host**—*tds.cdata.com*
    * **Port**—*14333*
    * **User**—enter your Connect AI username. This is displayed in the top-right corner of the Connect AI interface. For example, *[test@cdata.com](mailto:test@cdata.com)*.
    * **Password**—enter the PAT you generated on the [Settings](/en/Settings#personal-access-tokens) page.
    * **Database**—enter the Connection Name of the Connect AI data source you want to connect to (for example, *Salesforce1*).

    <Frame>
      <img src="https://mintcdn.com/cdata/L-wC-3th9ZUn-60n/en/images/thoughtspot_client_03.png?fit=max&auto=format&n=L-wC-3th9ZUn-60n&q=85&s=acd7f9ec74b71dc0d09ca72e8a4e1b57" alt="ThoughtSpot Client 03" width="979" height="450" data-path="en/images/thoughtspot_client_03.png" />
    </Frame>
  </Step>

  <Step>
    Click **Continue**.
  </Step>

  <Step>
    If the connection succeeds, a list of tables is displayed as shown below.

    <Frame>
      <img src="https://mintcdn.com/cdata/L-wC-3th9ZUn-60n/en/images/thoughtspot_client_04.png?fit=max&auto=format&n=L-wC-3th9ZUn-60n&q=85&s=a45dc99167a496ef67bd59858de043cd" alt="ThoughtSpot Client 04" width="979" height="454" data-path="en/images/thoughtspot_client_04.png" />
    </Frame>
  </Step>

  <Step>
    Click **Create Connection**.
  </Step>
</Steps>