Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Error on IBM Cognos Analytics 12.0.4 to Clickhouse DB via ODBC connection

    Posted Fri January 03, 2025 09:27 AM

    Hi!

    I would like to ask for a help as I have a problem with the testing and creating the connection of IBM Cognos Analytics to Clickhouse DB. It says that the libclickhouse.so is not found on the directory but it is there with appropriate permission.

    I created the connection using ODBC. and the ODBC already set up within Cognos Analytics Server and working successfully via isql command. Please help as I am stuck here about 1 week now.

    OS: Ubuntu 24.04.1 LTS

    Screenshots:



    ------------------------------
    Edward Del Rosario
    ------------------------------


  • 2.  RE: Error on IBM Cognos Analytics 12.0.4 to Clickhouse DB via ODBC connection

    Posted Mon January 06, 2025 10:14 AM

    Ed,

    You are most likely looking at a 64bit shared library file. You can probably use the file command to check. If 'file libclickhouseodbc.so' doesn't mention that it's a 32bit library then it wont work with IBM Cognos Analytic's compatible query engine which is 32bit execution mode. You'll need to acquire a 32bit version of the driver.



    ------------------------------
    Robert Hofstetter
    ------------------------------

    Original Message


  • 3.  RE: Error on IBM Cognos Analytics 12.0.4 to Clickhouse DB via ODBC connection

    Posted Tue February 11, 2025 12:53 AM

    Compatible Query (aka CQM) is a 32-bit process which requires 32-bit libraries re drivers.

    CQM on Unix/Linux does not claim to support any ODBC driver other than those drivers which are those listed on the 12.x and 11.2.4 pages.
    i.e. refer to CQM section off https://www.ibm.com/support/pages/node/7112270#12.0.4r




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

    Original Message


  • 4.  RE: Error on IBM Cognos Analytics 12.0.4 to Clickhouse DB via ODBC connection

    Posted Tue February 11, 2025 08:15 AM

    Thanks for the useful information



    ------------------------------
    mohd kaif
    ------------------------------

    Original Message


Related Content