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

# APOS

## Prerequisites

You must connect a data source to your Connect AI account. See [Sources](/en/Sources) for more information.

## Connect to Connect AI

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

<Steps>
  <Step>
    Log in to APOS Live Data Gateway Manager.
  </Step>

  <Step>
    In the APOS Live Data Gateway Manager, click **Add**.

    <Frame>
      <img src="https://mintcdn.com/cdata/8B5SN8TlQOoh6rM4/en/images/apos_client.png?fit=max&auto=format&n=8B5SN8TlQOoh6rM4&q=85&s=f828d41fd7420919c2ec0a9f52603d4c" alt="APOS Client" width="644" height="697" data-path="en/images/apos_client.png" />
    </Frame>
  </Step>

  <Step>
    Enter the connection information in the **Connection** tab of the dialog that appears.

    * **Data source**—select **Database**
    * **Database**—select **JDBC Generic**
    * **Connection String**—supply the connection string information in this format, where databaseName is the name of a configured connection in Connect AI: `jdbc:sqlserver://tds.cdata.com:14333;databaseName=MyConnectionName;`
    * **Driver Class**—set to `com.CData.connect.Driver` (this should be set by default)
  </Step>

  <Step>
    Click **Test Connection**.
  </Step>

  <Step>
    Click **Save** and give your connection a unique prefix.
  </Step>
</Steps>

Once your connection is created, it appears in the **Available Connection** table. Now you can use it to create semantic layer views in the APOS Live Data Gateway Web UI.