Cognos Analytics with Watson

 View Only
  • 1.  Cognos connection with Postgresql

    Posted Tue May 17, 2022 03:50 AM
    Edited by David GOMEZ PRIETO Tue May 17, 2022 04:53 AM
    Good morning,

    I would like to know how I can connect to a data server. In my case I first want to test with Postgresql. I have put the data from my server but I have errors.

    Thanks for your help.

    ------------------------------
    David GOMEZ PRIETO
    ------------------------------


  • 2.  RE: Cognos connection with Postgresql

    Posted Tue May 17, 2022 04:54 AM
    I have this error 



    ------------------------------
    David GOMEZ PRIETO
    ------------------------------



  • 3.  RE: Cognos connection with Postgresql

    Posted Tue May 17, 2022 09:18 AM
    Hi David,

    Did you setup a username and password?
    What is your connection string? It should look like:
    jdbc:postgresql://<host>:<port>/<database-name>

    If authentication is required you will need to fill in that information and then test the datasource connection to confirm it successfully connects.

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------



  • 4.  RE: Cognos connection with Postgresql

    Posted Wed May 18, 2022 03:44 AM
    Good morning Patrick,
    Yes, I have filled in the necessary information, I have put the host, the port and the name of the database, but I get an error.


    I have tried several things but I always get the same error.

    Best regards,

    ------------------------------
    David GOMEZ PRIETO
    ------------------------------



  • 5.  RE: Cognos connection with Postgresql

    Posted Wed May 18, 2022 01:19 PM

    Hey David,

    A lot might depend on the version of Analytics you're running, the version of PostgreSQL and if you're using ODBC or JDBC for connectivity and the version of that.  Have a look at the compatibility chart to make sure it's supported and see if there are any note specific to your versions. 

    First select whether you're on 11.1.x or 11.2.x, cloud vs On Premises, and then choose Software under the requirements type:

    https://www.ibm.com/support/pages/ibm-cognos-analytics-premises-111x-supported-software-environments



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



  • 6.  RE: Cognos connection with Postgresql

    Posted Tue July 05, 2022 07:58 PM

    I suggest you open a support call with IBM Cognos.  Superficially, the null pointer exception is occurring within the PostgreSQL JDBC driver.

    Assuming you have entered a valid URL and connection properties that PostgreSQL JDBC expects, then the same error may be shown outside CA.

    But without more context, not more can be said re probable root cause.



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