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
Launch Cognos Analytics.
Navigate to Manage > Data Server Connections.
Click Add Data Server and select Dremio as the type of connection.
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 planeJDBC connection string example for EU control planejdbc:dremio:direct=sql.eu.dremio.cloud:443[;ssl=true;PROJECT_ID=<YOUR_PROJECT_ID>;ENGINE=<OPTIONAL_ENGINE_NAME>]
jdbc:dremio:direct=sql.eu.dremio.cloud:443[;ssl=true;PROJECT_ID=<YOUR_PROJECT_ID>;ENGINE=<OPTIONAL_ENGINE_NAME>]
In the Username field, enter
$token
, and in the Password field, enter your Dremio PAT to authenticate to Dremio.Click Save.
Click Test to confirm the connection.