IBM Support

How to set up Snowflake data source connection in Cognos Analytics

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
2. Create Warehouses and DB
1
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
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.
4
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
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

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)"}]

Document Information

Modified date:
28 November 2022

UID

ibm16326069

Page Feedback