Cognos Analytics with Watson

 View Only
  • 1.  Connecting to Postrges Server

    Posted Wed November 02, 2022 09:09 AM
    I have been trying to follow the steps to connect the Cognos webapp to a DB, however cognos has not been able to locate the destination DB host when provided with host and port. Furthermore, when connecting to sample hosted datamodules such as the Weather App module, I get this error

    A problem occurred finding the driver class "com.ibm.cognos.jdbc.twc.TWCDriver".

    I am currently only using the Trial version. 11.2.3 

    Do I need to install JDBC drivers to my local environment? Do I need to setup a Secure Gateway and install the Secure Gateway Client before being able to connect to external DBs? 

    any help on this topic is greatly appreciated, thank you!

    ------------------------------
    Ry Kay
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Connecting to Postrges Server

    Posted Wed November 02, 2022 11:58 AM

    Regarding Weather Company, it is no longer supported

    https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=new-deprecated-removed-features-in-112x

    Regarding PostgreSQL are you trying to connect to your own data center vs a public cloud end point which has PostgreSQL on it (i.e. AWS Aurora PostgreSQL or Google Cloud PostgreSQL etc).



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------



  • 3.  RE: Connecting to Postrges Server

    Posted Wed November 02, 2022 01:32 PM
    I am trying to connect to my own data center

    ------------------------------
    Ry Kay
    ------------------------------