Cognos Analytics

 View Only

  • 1.  Connecting to Postrges Server

    Posted Wed November 02, 2022 09:06 AM
    I am currently using the trial version 11.2.3 of the Cognos Analytics web app, and I am unable to connect to my local postgres DB, even when I provide cognos with the correct host and port information. Where should my DB be hosted in order for cognos to have access to it? do I need to set up a Secure Gateway Connection in order for my DB to be visible to Cognos?

    Furthermore, when I try to connect the sample Weather Company data server connection to a dashbaord, I receive this error message on any visualizations;

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

    any help on this matter would be greatly appcreciated, thank you!

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

    #CognosAnalyticswithWatson


  • 2.  RE: Connecting to Postrges Server

    IBM Champion
    Posted Thu November 03, 2022 05:24 AM
    I have a book on Amazon which covers the creation of a JDBC connection and describes the steps to take to get the JDBC jar files installed, which may help.
    This book is called "Installation, Upgrade, and Configuration of IBM Cognos Analytics".

    This is shown for DB2 , but the same procedure is relevant for any JDBC based system, you just need to supply the jar files.
    ( For Windows systems, see Chapter 6, Section 6 3 onwards)
    (For JDBC jars on Linux https://www.amazon.co.uk/Installation-Upgrade-Configuration-Cognos-Analytics/dp/9391392032
    (See page 198, Section 7.3.1 onwards, also page 122 Section 5.4.1 onwards)

    ------------------------------
    Alan S Bluck
    Director
    ASB Software Development Limited
    Ringwood, Hampshire, England
    0044 7710612479
    ------------------------------

    Original Message


  • 3.  RE: Connecting to Postrges Server

    Posted Thu November 03, 2022 12:31 PM
    Cool book Alan, just ordered it!

    It's sad that there are just so few technical books anymore and really sad that IBM killed off its awesome Redbooks, especially in light of how terrible the IBM online docs have been and still are!

    Regards,

    Wayne

    ------------------------------
    Wayne Westlake
    ------------------------------

    Original Message


  • 4.  RE: Connecting to Postrges Server

    IBM Champion
    Posted Sat November 05, 2022 05:59 AM
    Hi Wayne,
    Thank you for your support ordering my book. That's much appreciated!

    Yes, when I retired from IBM I thought there was a need for more specific information for installation of IBM software. I find some of the online documentation a little scattered and difficult to follow as complete step by step procedures for building IBM systems. 

    I started by providing free downloads for some of the system installations I did ( still available now) which I needed to keep current knowledge , since I had a number of installation contracts.
    (Word document downloads  available on the ResearchGate site at https://www.researchgate.net/profile/Alan-Bluck )
    I was then approached by two publishing companies and I have now completed and published four books on IBM installations and am halfway through writing the fifth.
    I hope you find the book purchased useful.

    Regards,

    Alan

    ------------------------------
    Alan S Bluck
    Director
    ASB Software Development Limited
    Ringwood, Hampshire, England
    0044 7710612479
    ------------------------------

    Original Message