Skip to main content
Version: current [25.x]

IBM Cognos Analytics

You can run SQL from Cognos Analytics to explore your data through Dremio. Cognos Analytics Dynamic Query supports connections to Dremio through the Dremio JDBC driver.

Supported Versions​

To find out which versions of Dremio are supported with IBM Cognos 11.2.x, see DQM testing of vendor-supported client driver versions for each Cognos Analytics 11.2.x release.

To find out which versions of Dremio are supported with IBM Cognos 12.0.x, see DQM testing of vendor-supported client driver versions for each Cognos Analytics 12.0.x release.

Supported Authentication Methods​

You can use your Dremio username and password, a personal access token (PAT), or an access token from an identity provider that supports OpenID.

If you want to use a PAT, follow these steps before creating a connection to your Dremio cluster from Cognos:

  1. Ensure that your Dremio administrator has followed the steps in Enabling the Use of PATs.
  2. Create a PAT.

If you want to use an access token from an identity provider that supports OpenID, ensure that your Dremio administrator has followed the steps in OpenID Authentication.

Creating a Connection​

  1. Launch Cognos Analytics.

  2. Navigate to Manage > Data Server Connections.

  3. Click Add Data Server and select Dremio as the type of connection.

  4. In the JDBC URL field, specify the URL for the Dremio coordinator by using this template:

    JDBC URL template 
    jdbc:dremio:direct=<DREMIO_COORDINATOR>:31010[;schema=<OPTIONAL_SCHEMA>]

  5. Follow one of these steps to configure a method for authenticating to Dremio:

    • If you want to connect to Dremio by using a username and a password, specify the username and password.
    • If you want to connect to Dremio by using a personal access token (PAT), specify $token as the username and paste the PAT into the Password field.
    • If you want to connect to Dremio by using access tokens, select a Cognos namespace which has been configured to use OpenID Connect.

  6. Save the connection definition.

  7. Click Test to confirm that the connection succeeds.