Cognos Analytics

 View Only
  • 1.  Cognos Version 10.2.1 Connection with Maria DB.

    Posted Mon September 05, 2022 10:47 AM
    Hi Team - Need your assistance to Create a New Data Source of Cognos Version 10.2.1 with Maria DB, as Maria DB is not listed while trying to select with the Drop down list.

    Thanks.

    ------------------------------
    Hashim Raza
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos Version 10.2.1 Connection with Maria DB.

    IBM Champion
    Posted Mon September 05, 2022 11:45 AM
    MariaDB has an ODBC connector. Download and install that on all of your dispatchers.

    Next, follow the instructions on this page: https://www.datamensional.com/using-mysql-or-other-odbc-connections-with-cognos/

    ------------------------------
    Paul Mendelson
    ------------------------------



  • 3.  RE: Cognos Version 10.2.1 Connection with Maria DB.

    Posted Mon September 05, 2022 12:28 PM
    Thanks a lot

    ------------------------------
    Hashim Raza
    ------------------------------



  • 4.  RE: Cognos Version 10.2.1 Connection with Maria DB.

    Posted Mon September 05, 2022 02:52 PM

    Support for MariaDB (integrated and regularly tested) started in ~11.0.5 where Dynamic Query is required, and connections would use MariaDB J/Connect.

    If you are using Compatibility Query mode, and using ODBC, while it may work, MariaDB/MariaDB ODBC was never integrated/tested.

    The most recent releases of MariaDB server/MariaDB J/Connect which have been reviewed listed here:

    https://www.ibm.com/support/pages/node/6441017#11.2.3r



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



  • 5.  RE: Cognos Version 10.2.1 Connection with Maria DB.

    Posted Mon September 12, 2022 01:28 PM
    Hi Team - We have Cognos 10.2.1 version on AIX, any guide line highly appreciated, while trying to Connect receiving this error.



    ------------------------------
    Hashim Raza
    ------------------------------



  • 6.  RE: Cognos Version 10.2.1 Connection with Maria DB.

    IBM Champion
    Posted Tue September 13, 2022 08:12 AM
    Hi Hashim,

    You probably need to read this part of the documentation:
    Java Database Connectivity drivers

    You need to restart Cognos with Cognos Configuration.

    If it is not working, you should create a new original thread for this issue.

    Best regards,

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