Cognos Analytics

Cognos Analytics

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

 View Only
Back to discussions
Expand all | Collapse all

Cognos Dashboard Embedded integration with redshift

  • 1.  Cognos Dashboard Embedded integration with redshift

    Posted Thu January 09, 2020 04:28 PM
    I'm testing Cognos Dashboard Embedded and I'd like to be able to connect to Amazon Redshift. I've tried adding a JDBC DataSource, with "driverClassName": "org.postgresql.Driver". Seems like the version of postgres RedShift uses is newer than the version Cognos uses.

    My question is: is it possible to connect to Amazon Redshift from Cognos Dashboard Embedded?

    ------------------------------
    Kaká Oliveira
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos Dashboard Embedded integration with redshift

    Posted Mon January 13, 2020 09:59 AM
    Generally speaking, for all versions of Cognos, you should be using the Amazon Redshift JDBC driver, not Postgres one (even if the Redshift driver is based on the Postgres one):
    https://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html#download-jdbc-driver

    The driver class name to use is com.amazon.redshift.jdbc.Driver as per above documentation.

    ------------------------------
    JASON TAVOULARIS
    ------------------------------

    Original Message


Related Content