Search

Crystal Reports

Crystal Reports

This page outlines two different ways to connect to CData Connect Cloud 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 CData Connect Cloud account.

Note: The OData method of connecting is simpler and faster than the JDBC method.

Prerequisites

Before you can configure and use Crystal Reports with CData Connect Cloud through either method, you must first connect a data source to your CData Connect Cloud account. See Connections for more information.

You must also generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

For OData connectivity only: Create a virtual dataset Workspace. Later, you will use the OData Service URL on that page (https://cloud.cdata.com/api/odata/{workspace_name}) with the relevant workspace name to establish the connection.

Connecting to CData Connect Cloud via OData

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

  1. If necessary, download and install Crystal Reports from the SAP website.

  2. In Crystal Reports, select File > New > Standard Report.

  3. In the Standard Report Creation Wizard, select OData as your data source.

    This opens the OData connectivity dialog.

  4. In the OData dialog, enter the following information:

    • Service root URL–https://cloud.cdata.com/api/odata/{workspace_name}

    • User ID–CData Connect Cloud のユーザー名を入力します。ユーザー名は、CData Connect Cloud の画面の右上に表示されています。例：test@cdata.co.jp

    • Password–Settings ページで生成したPAT を入力します。

    Click Finish.

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

  6. Select the tables and columns for your report.

  7. Click Finish to generate the report.

Connecting to CData Connect Cloud via JDBC Driver

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

  1. If necessary, download and install Crystal Reports from the SAP website.

  2. Download and install the CData Connect Cloud JDBC driver.
    1. Open the Client Tools page of CData Connect Cloud.
    2. In the Dev Tools section, click JDBC.
    3. Download and run the setup file.
    4. 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.
    5. Copy the JDBC Connect JAR file.

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

  4. Paste the JDBC Connect JAR file into the Crystal Reports installation directory.

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

  6. Open CRConfig in a text editor.

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

  8. Log in to Crystal Reports and start a blank report.

  9. In the Database Expert dialog, click Create New Connection.

  10. Select the JDBC data source and the tables you want to add. Click OK.

  11. In the Connection dialog, enter the Connection URL and Database Classname.

  12. Click Finish. The Database Expert dialog displays all available connections.

You can now create reports with the connected data.