> ## 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.

# Geckoboard

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

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

  <Step>
    Click **Add widget**.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/geckoboard_client_01.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=b43bd74676d5f58e17bd3ed55f11016e" alt="Geckoboard Client 01" width="2135" height="1190" data-path="en/images/geckoboard_client_01.png" />
    </Frame>
  </Step>

  <Step>
    Search for "Databases" and click the resulting option.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/geckoboard_client_02.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=302e345d1f9dcab90dd1d727862c282b" alt="Geckoboard Client 02" width="937" height="710" data-path="en/images/geckoboard_client_02.png" />
    </Frame>
  </Step>

  <Step>
    Select **SQL Server** as the database type.

    <Frame>
      <img src="https://mintcdn.com/cdata/6FDv4aMDihHt3ws_/en/images/geckoboard_client_03.png?fit=max&auto=format&n=6FDv4aMDihHt3ws_&q=85&s=b4239656372b0f9a0fc73657e4b9471a" alt="Geckoboard Client 03" width="1215" height="1170" data-path="en/images/geckoboard_client_03.png" />
    </Frame>
  </Step>

  <Step>
    Fill in the connection details:

    * **Connection name**—enter a name for the connection to Connect AI.
    * **Host**—enter *tds.cdata.com*
    * **Port**—enter *14333*
    * **Database name**—enter the Connection Name of the Connect AI data source you want to connect to (for example, *Salesforce1*).
    * **Username**—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.

    <Frame>
      <img src="https://mintcdn.com/cdata/6FDv4aMDihHt3ws_/en/images/geckoboard_client_04.png?fit=max&auto=format&n=6FDv4aMDihHt3ws_&q=85&s=b0e45a077283f8f0c094af8c2b6037dd" alt="Geckoboard Client 04" width="1335" height="1370" data-path="en/images/geckoboard_client_04.png" />
    </Frame>
  </Step>

  <Step>
    Click **Connect**.
  </Step>
</Steps>