IBM Cognos Analytics

This article explains 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.

IBM Cognos Analytics is a BI analytics platform that can be connected to an Exasol database. 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 IBM Cognos Analytics is installed.

Connect IBM Cognos Analytics to Exasol

This procedure is an overview of the steps required to connect IBM Cognos Analytics to an Exasol database. For more detailed instructions, refer to the documentation on the IBM Cognos Analytics website.

  1. Download the latest version of the Exasol JDBC driver from the Exasol Download portal.

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

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

    Type: Exasol

    JDBC URL: The hostname or IP address to the database, or a list of all nodes in a cluster.

    For example: 203.0.110.11 or 203.0.110.11..13

    Driver class name: com.exasol.jdbc.EXADriver

    User ID: The username for the Exasol database.

    Password: The password for the Exasol user.

Next steps

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