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

# Crystal Reports

> This page outlines two different ways to connect to Connect AI from Crystal Reports: through OData or through the JDBC driver. After installation, Crystal Reports can pull data from sources that you have connected to your Connect AI account.

<Note>
  The OData method of connecting is simpler and faster than the JDBC method.
</Note>

## Prerequisites

Before you can configure and use Crystal Reports with Connect AI through either method, you must first connect a data source to your Connect AI account. See [Sources](/ja/Sources) for more information.

You must also generate a Personal Access Token (PAT) on the [Settings](/ja/Settings#personal-access-tokens) page. Copy this down, as it acts as your password during authentication.

**For OData connectivity only:** Create a [Workspace](/ja/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.

## Connect to Connect AI via OData

To establish a connection from Crystal Reports to Connect AI via OData, follow these steps.

<Steps>
  <Step>
    If necessary, download and install Crystal Reports from the SAP website.
  </Step>

  <Step>
    In Crystal Reports, select **File** > **New** > **Standard Report**.

    <Frame>
      <img src="https://mintcdn.com/cdata/EE4HlkSQpbRlgqOq/ja/images/crystal_reports_new_report.png?fit=max&auto=format&n=EE4HlkSQpbRlgqOq&q=85&s=20745071dd5138283d509bfb1b17c720" alt="Crystal Reports New Report" width="508" height="304" data-path="ja/images/crystal_reports_new_report.png" />
    </Frame>
  </Step>

  <Step>
    In the **Standard Report Creation Wizard**, select **OData** as your data source.

    <Frame>
      <img src="https://mintcdn.com/cdata/EE4HlkSQpbRlgqOq/ja/images/crystal_reports_report_wizard.png?fit=max&auto=format&n=EE4HlkSQpbRlgqOq&q=85&s=57d2075c68396f7426b23d25c60008e2" alt="Crystal Reports Report Wizard" width="586" height="450" data-path="ja/images/crystal_reports_report_wizard.png" />
    </Frame>

    This opens the **OData** connectivity dialog.
  </Step>

  <Step>
    In the **OData** dialog, enter the following information:

    * **Service root URL**–*[https://cloud.cdata.com/api/odata/\{workspace\\\_name}](https://cloud.cdata.com/api/odata/\{workspace\\_name})*
    * **User ID**–Connect AI のユーザー名を入力します。ユーザー名は、Connect AI の画面の右上に表示されています。例：*[test@cdata.co.jp](mailto:test@cdata.co.jp)*
    * **Password**–[Settings](/ja/Settings#personal-access-tokens) ページで生成したPAT を入力します。

    <Frame>
      <img src="https://mintcdn.com/cdata/EE4HlkSQpbRlgqOq/ja/images/crystal_reports_odata.png?fit=max&auto=format&n=EE4HlkSQpbRlgqOq&q=85&s=7a9fcfb6ac352bdbabb71cb95616b437" alt="Crystal Reports OData" width="453" height="471" data-path="ja/images/crystal_reports_odata.png" />
    </Frame>

    Click **Finish**.
  </Step>

  <Step>
    The tables in the selected workspace now appear as an available data source under OData.

    <Frame>
      <img src="https://mintcdn.com/cdata/EE4HlkSQpbRlgqOq/ja/images/crystal_reports_data_source.png?fit=max&auto=format&n=EE4HlkSQpbRlgqOq&q=85&s=5565a77cbab675bed1b024ae0ff67e86" alt="Crystal Reports Data Source" width="575" height="357" data-path="ja/images/crystal_reports_data_source.png" />
    </Frame>
  </Step>

  <Step>
    Select the tables and columns for your report.

    <Frame>
      <img src="https://mintcdn.com/cdata/EE4HlkSQpbRlgqOq/ja/images/crystal_reports_addfields.png?fit=max&auto=format&n=EE4HlkSQpbRlgqOq&q=85&s=d5b6840c51723ea42181500c3365fc9b" alt="Crystal Reports Add Fields" width="588" height="443" data-path="ja/images/crystal_reports_addfields.png" />
    </Frame>
  </Step>

  <Step>
    Click **Finish** to generate the report.
  </Step>
</Steps>

## Connect to Connect AI via JDBC Driver

To establish a connection from Crystal Reports to Connect AI through the JDBC driver, follow these steps.

<Steps>
  <Step>
    If necessary, download and install Crystal Reports from the SAP website.
  </Step>

  <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, locate the JDBC Connect JAR file in the JDBC driver's installation directory, for example, `C:\Program Files\CData\JDBC Driver for CData Connect\lib`.

    e. Copy the JDBC Connect JAR file.
  </Step>

  <Step>
    Find the installation directory for Crystal Reports, for example, `C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib`.
  </Step>

  <Step>
    Paste the JDBC Connect JAR file into the Crystal Reports installation directory.
  </Step>

  <Step>
    Go to the parent `java` folder (for example, `C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java`). This folder should contain a `CRConfig` file.

    <Frame>
      <img src="https://mintcdn.com/cdata/EE4HlkSQpbRlgqOq/ja/images/crystal_reports_client.png?fit=max&auto=format&n=EE4HlkSQpbRlgqOq&q=85&s=df324a9bb33ad9a006e91e5c029930d4" alt="Crystal Reports Client" width="1216" height="413" data-path="ja/images/crystal_reports_client.png" />
    </Frame>
  </Step>

  <Step>
    Open `CRConfig` in a text editor.
  </Step>

  <Step>
    Add the path to the JDBC Connect JAR file in the `<Classpath>` of the `CRConfig` file, for example, `C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib`.

    <Frame>
      <img src="https://mintcdn.com/cdata/EE4HlkSQpbRlgqOq/ja/images/crystal_reports_config.png?fit=max&auto=format&n=EE4HlkSQpbRlgqOq&q=85&s=48bda38d6555247c58837092eae3bb2c" alt="Crystal Reports Config" width="1264" height="516" data-path="ja/images/crystal_reports_config.png" />
    </Frame>
  </Step>

  <Step>
    Log in to Crystal Reports and start a blank report.
  </Step>

  <Step>
    In the **Database Expert** dialog, click **Create New Connection**.
  </Step>

  <Step>
    Select the **JDBC** data source and the tables you want to add. Click **OK**.

    <Frame>
      <img src="https://mintcdn.com/cdata/EE4HlkSQpbRlgqOq/ja/images/crystal_reports_addtables.png?fit=max&auto=format&n=EE4HlkSQpbRlgqOq&q=85&s=a0719b7c84e6cc027860ef1c3f69bf05" alt="Crystal Reports Add Tables" width="966" height="862" data-path="ja/images/crystal_reports_addtables.png" />
    </Frame>
  </Step>

  <Step>
    In the **Connection** dialog, enter the **Connection URL** and **Database Classname**.

    <Frame>
      <img src="https://mintcdn.com/cdata/EE4HlkSQpbRlgqOq/ja/images/crystal_reports_connection.png?fit=max&auto=format&n=EE4HlkSQpbRlgqOq&q=85&s=51bec32337f234014817ff1d0e8eb26f" alt="Crystal Reports Connection" width="900" height="940" data-path="ja/images/crystal_reports_connection.png" />
    </Frame>
  </Step>

  <Step>
    Click **Finish**. The **Database Expert** dialog displays all available connections.

    <Frame>
      <img src="https://mintcdn.com/cdata/EE4HlkSQpbRlgqOq/ja/images/crystal_reports_final.png?fit=max&auto=format&n=EE4HlkSQpbRlgqOq&q=85&s=260887a3d9fc9f24dd0cd94715e4b33e" alt="Crystal Reports Final" width="1002" height="890" data-path="ja/images/crystal_reports_final.png" />
    </Frame>
  </Step>
</Steps>

You can now create reports with the connected data.