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.
Dremio connectivity is supported with Cognos Analytics 11.2.1 or later. You must be on Dremio 15.7 or later.
Supported Authentication Methods
You can use your Dremio username and password.
Creating a Connection
Launch Cognos Analytics.
Navigate to Manage > Data Server Connections.
Click Add Data Server and select “Dremio” as the type of connection.
For the JDBC URL, enter the URL for the Dremio coordinator using this template:JDBC URL template
For the Authentication method, select Prompt for the user ID and password.
(Optional) Click Test to test your connection.
Was this page helpful?
Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.