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 Analtyics.

Objective

If you are setting up Snowflake data source connection with Cognos Analytics, this document will be your step-by step guide for you.
 

Environment

Steps

A. Pre-requirement for Snowflake
1. Logon Snowflake with user name and password
2
2. Create Warehouses and DB
1
B. Snowflake JDBC connection with Cognos Analytics

2. Place snowflake jdbc (snowflake-jdbc-3.9.2.jar) file into CA_installation/drivers folder.

3. Restart Cognos Analytics 
4. Edit Snowflake connection
4
JDBC URL:

"jdbc:snowflake://<your_account_name>.snowflakecomputing.com/?warehouse=<your_warehouse>"

Select Use the following signon:

ID and Password from snowflake User name and Password

5. Test the connection
6
C. JDBC URL with Proxy Server
 "XQE-DS-0006" Unable to logon to the data source, JDBC driver encountered communication Error"
Telnet <your_account_name>.snowflakecomputing.com 443
1
Please use "Proxy Server" if Cognos installation server cannot communicate with Snowflake Server

jdbc:snowflake://<your_account_name>.snowflakecomputing.com/?warehouse=<your_warehouse>&useProxy=true&proxyHost=<YOUR_PROXY_SERVER>&proxyPort=80&networkTimeout=500&insecureMode=true&tracing=ALL

Document Location

Worldwide

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m0z000000TN4sAAG","label":"Installation and Configuration->Database"}],"ARM Case Number":"TS004139799","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
04 September 2020

UID

ibm16326069