Crystal Reports


Crystal Reports


This page outlines the steps to install and configure the CData Connect Cloud connector for Crystal Reports. After installation, Crystal Reports can pull data from sources that you have connected to your CData Connect Cloud account.

Prerequisites

Before you can configure and use Crystal Reports with CData Connect Cloud, 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.

Connecting to CData Connect Cloud

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