Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Has Anybody Been able to Connect to Snowflake using Private key / Passphrase.

    Posted Wed April 02, 2025 12:59 PM

    When I try to key in the information, I feel like it's not able to ready the Private key.  Not sure if anybody else had luck.



    ------------------------------
    Tim Felber
    ------------------------------


  • 2.  RE: Has Anybody Been able to Connect to Snowflake using Private key / Passphrase.

    Posted Thu April 03, 2025 10:03 AM

    We are using Snowflake and use the private key and it works without issue. We have been using this setup for over 2 years. We saved the private key to a location that all Cognos servers could reach. This connection worked in both 11.1.7 and in 12.0.4.

    Here is how we setup the connection string. 

    Type: Snowflake

    JDBC URL: jdbc:snowflake://companyspecific.snowflakecomputing.com/?private_key_file=//CognosServerName/FolderLocation/svc_sf_cognos-rsa_key.p8&useProxy=false&role=COGNOS_USER&warehouse=cognos_wh&client_metadata_request_use_connection_ctx=false&user=COGNOS_SERVICE_ACCOUNT

    Connection properties: ibmcognos.subcode=SNOWFLAKE;

    Driver class name: net.snowflake.client.jdbc.SnowflakeDriver

    Connection string: ;LOCAL;JDBC;URL=jdbc:snowflake://companyspecific.snowflakecomputing.com/?private_key_file=//CognosServerName/FolderLocation/Security/svc_sf_cognos-rsa_key.p8&useProxy=false&role=COGNOS_USER_ROLE&warehouse=cognos_wh&client_metadata_request_use_connection_ctx=false&user=COGNOS_SERVICE_ACCOUNT;DRIVER_NAME=net.snowflake.client.jdbc.SnowflakeDriver;ibmcognos.subcode=SNOWFLAKE;



    ------------------------------
    Tina Allsup
    ------------------------------

    Original Message


  • 3.  RE: Has Anybody Been able to Connect to Snowflake using Private key / Passphrase.

    Posted 22 days ago

    Tina Allsup Thank you for sharing. It's really helpful. I tried following the steps above but encountered the error shown below.

    1. Should the private key .p8 file be in RSA format?
    2. Where do we need to specify the credentials, should it be in the JDBC URL or in the authentication settings? If it's in the authentication, what type of authentication should we use?

    Error : 

    XQE-DS-0006 Unable to logon to the data source.Private key provided is invalid or not supported: D:/Program Files/ibm/cognos/SF_Keys/app_cognos.p8: ObjectIdentifier() -- data isn't an object ID (tag = 48)



    ------------------------------
    Prabhakar P
    ------------------------------

    Original Message


  • 4.  RE: Has Anybody Been able to Connect to Snowflake using Private key / Passphrase.

    Posted 22 days ago

    Hi Tina Allsup

    Thank you for sharing your working solution, it's very helpful. I tried implementing a similar setup but encountered a few issues. Could you please help clarify the following:

    1. Where did you specify the password for the private key file?

    2. Does the private key need to be in a specific format, such as an RSA key file?

    3. For the authentication method in Cognos, should it be set to Anonymous or Use the sign-on?

    Error I got :

    XQE-DS-0006 Unable to logon to the data source.Private key provided is invalid or not supported: D:/Program Files/ibm/cognos/SF_Keys/app_tableau_dev.p8: Inappropriate key specification: DER input, Integer tag error



    ------------------------------
    Prabhakar P
    ------------------------------

    Original Message


  • 5.  RE: Has Anybody Been able to Connect to Snowflake using Private key / Passphrase.

    Posted 22 days ago
    1. Where did you specify the password for the private key file? When using the private key there are no passwords to be entered.
    2. Does the private key need to be in a specific format, such as an RSA key file? The DBA provided us the private key – they should provide it in the correct format.
    3. For the authentication method in Cognos, should it be set to Anonymous or Use the sign-on? We use single sign on – when setting up a database connection, we only  had to provide the user name in the connection. The connection did have the settings for the private key so it used that when connecting to the database.

     

     




    Original Message


  • 6.  RE: Has Anybody Been able to Connect to Snowflake using Private key / Passphrase.

    Posted 8 days ago

    Thank you for the info, it did work for me after I got the latest key file without the Passpharse.



    ------------------------------
    Prabhakar P
    ------------------------------

    Original Message


Related Content