How To
Summary
How to configure Snowflake data source connection in Cognos Analytics.
Objective
This is a step-by step guide to setting up Snowflake data source connection in Cognos Analytics.
Steps
A. Pre requirement for Snowflake
1. Log on Snowflake with username and password

2. Create Warehouses and DB

B. Snowflake JDBC connection with Cognos Analytics
1. Verify the vendor-supported Snowflake client driver versions supported and tested with your version of Cognos Analytics
- Cognos Analytics 11.2.x: https://www.ibm.com/support/pages/node/6440667
- Cognos Analytics 11.1.x: https://www.ibm.com/support/pages/node/735235
- Cognos Analytics 11.0.x: https://www.ibm.com/support/pages/node/716109
Note that Snowflake states new versions are backward compatible with existing Snowflake features but do not guarantee that earlier versions are forward compatible.
2. Download the appropriate version Snowflake JDBC Driver
3. Place Snowflake JDBC Drive file into <cognos_analytics>/drivers directory.
4. Restart Cognos Analytics
5. Edit Snowflake connection.
Refer to Snowflake documentation for information on configuring the JDBC driver and Connection parameters.
Configuring the JDBC Driver
https://docs.snowflake.com/en/user-guide/jdbc-configure.html
https://docs.snowflake.com/en/user-guide/jdbc-configure.html
JDBC Driver Connection Parameter Reference
https://docs.snowflake.com/en/user-guide/jdbc-parameters.html
https://docs.snowflake.com/en/user-guide/jdbc-parameters.html

JDBC URL:
jdbc:snowflake://<your_account_name>.snowflakecomputing.com/?warehouse=<your_warehouse>
Select Use the following signon: ID and Password from Snowflake username and Password or see the following to configure JSON Web Token (JWT) when authenticating: https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=details-snowflake-connections
Refer to Snowflake documentation for information on how to set users default warehouse, namespace, role etc.
5. Test the connection

6. JDBC URL with Proxy Server
You can encounter error XQE-DS-0006 Unable to log on to the data source if you have a proxy server but have not not configured the Snowflake JDBC connection to specify proxy information.
Refer to Snowflake documentation for information on configuring a JDBC connection string to specify proxy information.
Specifying a Proxy Server in the JDBC Connection String
https://docs.snowflake.com/en/user-guide/jdbc-configure.html#label-java-connecting-using-a-proxy-server-using-connection-string
https://docs.snowflake.com/en/user-guide/jdbc-configure.html#label-java-connecting-using-a-proxy-server-using-connection-string
Related Information
Document Location
Worldwide
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m0z000000TN4sAAG","label":"Installation and Configuration-\u003EDatabase"}],"ARM Case Number":"TS004139799","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
28 November 2022
UID
ibm16326069