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 SaaS database must be running.

  • The IP address of the host where the tool is running must be in the allowed IP address list.

    To learn more about how to allow traffic to your database, see Network Security.

Get the connection details

  1. On the Databases page in the Exasol SaaS web console, click on the info button  on the cluster.

  2. Copy the connection string, port, and username from the cluster details window. You will need this information when you configure the connection in the client.

    saas cluster details

  3. If you do not already have a personal access token (PAT), follow the instructions in Personal access token to create a new token. The token and the username will be used by the client to authenticate to Exasol.

    The token is only shown once and will disappear when you close or refresh the page. Make sure that you copy the token, since it cannot be retrieved if you lose it. In that case you must create a new token.

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 connection string that you copied in Get the connection details

    Driver class name: com.exasol.jdbc.EXADriver

    User ID: The username for the Exasol database.

    Password: Your personal access token.

Next steps

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