IBM Cognos Analytics

Learn how to connect IBM Cognos Analytics to an Exasol database using JDBC.

Exasol takes no responsibility for changes in functionality or terms of use for third-party tools. For more details about the compatibility and use of these tools with Exasol, refer to the respective software vendor’s website.

This article explains how to configure a connection to Exasol in IBM Cognos Analytics. For more information about how to use this tool, refer to the IBM Cognos Analytics website.

Prerequisites

  • IBM Cognos Analytics must be installed.

  • The Exasol JDBC driver must be installed. To learn more, see JDBC driver.

  • Your Exasol database must be running and reachable from the environment where the tool is used.

Exasol SaaS

  • The IP address of the host where the tool is running must be in the allowed IP address list in Exasol SaaS. To learn how to allow traffic to your database, see Network security (SaaS).

  • To connect the tool to an Exasol SaaS cluster you will need the connection string and a personal access token (PAT) for authentication. To learn how to get the connection details, see Connect to Exasol SaaS.

Connect IBM Cognos Analytics to Exasol

  1. Install the Exasol JDBC driver in IBM Cognos Analytics and restart the service.

  2. In IBM Cognos Analytics, create a new data source with the following properties:

    • Type: Exasol

    • JDBC URL: The URL for the Exasol database.

      To learn about supported URL structures for the JDBC driver, see Exasol URL.

      For Exasol SaaS, use the connection string provided in the web console as hostname.

    • Driver class name: com.exasol.jdbc.EXADriver

    • User ID: The username for the Exasol user.

    • Password: The password for the Exasol user.

      For Exasol SaaS, use a valid personal access token as password.

Next steps

To learn more about how to use this tool, refer to the IBM Cognos Analytics website.