Skip to main content

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 legacy JDBC driver.

Supported Versions​

To learn 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 learn 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​

Use a Dremio personal access token (PAT) for 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, enter the connection string in the JDBC Connection field in the project settings' General Information sidebar in Dremio Cloud. The EU and US have different control planes, so the connection strings differ slightly depending on the control plane you're using.

    JDBC connection string example for US control plane 
    jdbc:dremio:direct=sql.eu.dremio.cloud:443[;ssl=true;PROJECT_ID=<YOUR_PROJECT_ID>;ENGINE=<OPTIONAL_ENGINE_NAME>]
    JDBC connection string example for EU control plane 
    jdbc:dremio:direct=sql.eu.dremio.cloud:443[;ssl=true;PROJECT_ID=<YOUR_PROJECT_ID>;ENGINE=<OPTIONAL_ENGINE_NAME>]

  5. In the Username field, enter $token, and in the Password field, enter your Dremio PAT to authenticate to Dremio.

  6. Click Save.

  7. Click Test to confirm the connection.