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

# SnapLogic

## Prerequisites

Before you can configure and use SnapLogic with Connect AI, you must first connect a data source to your Connect AI account. See [Sources](/en/Sources) for more information.

You must also 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.

<Steps>
  <Step>
    Download and install the Connect AI JDBC driver.

    a. Open the **Integrations** page of Connect AI.

    b. In the **Dev Tools** section, click **JDBC**.

    c. Download and run the setup file.

    d. When the installation is complete, the JAR file can be found in the installation directory. The default directory is `C:/Program Files/CData/CData Connect JDBC driver/lib`.
  </Step>

  <Step>
    Log in to SnapLogic.
  </Step>

  <Step>
    Click the **Manager** tab.
  </Step>

  <Step>
    Select a folder on the left to add the JDBC JAR file to.

    <Frame>
      <img src="https://mintcdn.com/cdata/L-wC-3th9ZUn-60n/en/images/snaplogic_client_01.png?fit=max&auto=format&n=L-wC-3th9ZUn-60n&q=85&s=fa9728aeea2474855ccec4bc256466ee" alt="" width="1310" height="655" data-path="en/images/snaplogic_client_01.png" />
    </Frame>
  </Step>

  <Step>
    Click the **Files** tab.

    <Frame>
      <img src="https://mintcdn.com/cdata/L-wC-3th9ZUn-60n/en/images/snaplogic_client_02.png?fit=max&auto=format&n=L-wC-3th9ZUn-60n&q=85&s=6ff9e5b6a28a9eea4a6ab7b8c479914a" alt="" width="818" height="481" data-path="en/images/snaplogic_client_02.png" />
    </Frame>
  </Step>

  <Step>
    Click the "+" button in the top right to upload the Connect AI JDBC JAR file. It appears as a file once uploaded.

    <Frame>
      <img src="https://mintcdn.com/cdata/L-wC-3th9ZUn-60n/en/images/snaplogic_client_03.png?fit=max&auto=format&n=L-wC-3th9ZUn-60n&q=85&s=7db6b6134e705df533af542787cf762e" alt="" width="387" height="171" data-path="en/images/snaplogic_client_03.png" />
    </Frame>
  </Step>

  <Step>
    Click the **Designer** tab.
  </Step>

  <Step>
    Click **JDBC** to expand the options for snaps.
  </Step>

  <Step>
    Click and drag a **Generic JDBC - Select** snap onto the designer.

    <Frame>
      <img src="https://mintcdn.com/cdata/L-wC-3th9ZUn-60n/en/images/snaplogic_client_04.png?fit=max&auto=format&n=L-wC-3th9ZUn-60n&q=85&s=c4fec4eb28ca660202c27350a1d50ce3" alt="" width="687" height="428" data-path="en/images/snaplogic_client_04.png" />
    </Frame>
  </Step>

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

  <Step>
    Enter the JDBC connection properties.

    * **JDBC driver**—add the Connect AI JAR file
    * **JDBC driver Class**—enter *cdata.jdbc.connect.ConnectDriver*
    * **JDBC Url**—enter a JDBC connection string for the JDBC driver. The connection string is formatted like `jdbc:connect:AuthScheme=[AuthScheme];User=[User];Password=[PAT];`.
    * **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/L-wC-3th9ZUn-60n/en/images/snaplogic_client_05.png?fit=max&auto=format&n=L-wC-3th9ZUn-60n&q=85&s=2b330a7bb5a02f2bc91162531c2d19a3" alt="" width="1918" height="890" data-path="en/images/snaplogic_client_05.png" />
    </Frame>
  </Step>

  <Step>
    Click **Validate**. If the connection succeeds, the snap is ready to use.
  </Step>

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