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

# Jitterbit

> This page outlines the steps to connect Jitterbit to Connect AI using the [OData](/en/API/OData-Dashboard) protocol. This requires the use of workspaces. See the [Workspaces](/en/Workspaces) documentation for more information.

## 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.
* Create a [Workspace](/en/Workspaces). Later, you will use the **OData Service URL** on that page (*[https://cloud.cdata.com/api/odata/\{workspace\\\_name}](https://cloud.cdata.com/api/odata/\{workspace\\_name})*) with the relevant workspace name to establish the connection.
* 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 Jitterbit to Connect AI using the OData protocol, follow these steps.

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

  <Step>
    Create a project in Cloud Studio and provide a workspace environment for it.

    <Frame>
      <img src="https://mintcdn.com/cdata/6FDv4aMDihHt3ws_/en/images/jitterbit_open_project.png?fit=max&auto=format&n=6FDv4aMDihHt3ws_&q=85&s=da291c3f69c61a92b2df88159ee08cd9" alt="" width="1179" height="286" data-path="en/images/jitterbit_open_project.png" />
    </Frame>
  </Step>

  <Step>
    Click **Connections** and enter OData in the search bar.
  </Step>

  <Step>
    Select the **OData** connector.
  </Step>

  <Step>
    Enter the OData connection properties.

    * **Connection Name**—enter a connection name.
    * **OData Metadata URL**—enter the metadata URL: *[https://cloud.cdata.com/api/odata/\{workspace\\\_name}/\$metadata](https://cloud.cdata.com/api/odata/\{workspace\\_name}/\$metadata)*.
    * **Authentication**—select **Basic Auth**.
    * **User Name**—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/jitterbit_configure_OData.png?fit=max&auto=format&n=6FDv4aMDihHt3ws_&q=85&s=6d1fd5a0c714d6ee2abe6654b6d4189d" alt="" width="796" height="1146" data-path="en/images/jitterbit_configure_OData.png" />
    </Frame>
  </Step>

  <Step>
    Click **Test** to test the connection, and then click **Save Changes**.
  </Step>

  <Step>
    Choose the operation you want to perform and drag it to the workflow in your project.

    <Frame>
      <img src="https://mintcdn.com/cdata/6FDv4aMDihHt3ws_/en/images/jitterbit_query.png?fit=max&auto=format&n=6FDv4aMDihHt3ws_&q=85&s=f0328239f9744712aa3d3936c1563ac6" alt="" width="359" height="503" data-path="en/images/jitterbit_query.png" />
    </Frame>
  </Step>

  <Step>
    Double-click the query operation to see all the tables and derived views available in your OData endpoint.

    <Frame>
      <img src="https://mintcdn.com/cdata/6FDv4aMDihHt3ws_/en/images/jitterbit_tables.png?fit=max&auto=format&n=6FDv4aMDihHt3ws_&q=85&s=3dd0036fbd0618e1f96b2ed88ffaff5d" alt="" width="984" height="541" data-path="en/images/jitterbit_tables.png" />
    </Frame>
  </Step>

  <Step>
    Select a table and configure the query.

    You can now transform and integrate your data.
  </Step>
</Steps>