Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Cognos Analytics 11.1.7 and MongoDB BI Connector

    Posted Mon August 31, 2020 11:10 PM
    Hi.
    I am trying to connect Cognos Analytics 11.1.7 to MongoDB Community Edition.

    I have read the following documents:
    https://www.ibm.com/support/pages/how-connect-cognos-analytics-mongodb-atlas-40-or-42-using-mongodb-connector-bi
    https://www.ibm.com/support/pages/how-connect-cognos-analytics-mongodb-using-mongodb-connector-bi

    But I cannot get the connection.

    The only way to connect to the MongoDB database is to use MongoDB Compass.
    Has anyone been able to configure this type of connection?

    Thanks.

    ------------------------------
    Diego Campos
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos Analytics 11.1.7 and MongoDB BI Connector

    Posted Tue September 01, 2020 07:04 AM
    Edited by System Admin Fri January 20, 2023 04:22 PM
    Hi Diego, 

    I have configured CA 11.0.11 using MongoDB using the BI Connector aganist an on premise installation of MongoDB. Remember that MongoDB connector for BI is part of MongoDB enterprise edition advanced subscription; if you use it against community edition in production you will not be compliant with their license policies. 

    I had to perform the following steps:
    1) Install VC++ redistributable component
    2) Install MongoDB for BI Connector component
    3) Generate the schema file using mongodrdl
    4) Launch BI Connector (mongosqld) (I am running as windows service using the config file with the schema generated in step 3)
    5) Place the MySQL driver in /drivers folder in all the dispatcher servers and restart cognos services
    6) Create JDBC connection for "MongoDB for BI Connector" (If you are using dataserver connections, you can directly create MongoDB for BI Connector connection). Connect to the service launched in step 4 above. 

    Now you are ready to use the connection for using in cognos. 

    This link provides all the details - https://docs.mongodb.com/bi-connector/master/
    You can even create an ODBC connection using DSN if you need. 

    I am yet to test this in 11.1.7 but I guess if we use the correct versions of drivers and components, we should be able to use it without problem. 

    Regards




    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------

    Original Message


  • 3.  RE: Cognos Analytics 11.1.7 and MongoDB BI Connector

    Posted Tue September 01, 2020 08:07 AM
    Thanks Kiran.

    I'm using the Community version because it was for a POC.

    Regards.

    ------------------------------
    Diego Campos
    ------------------------------

    Original Message


  • 4.  RE: Cognos Analytics 11.1.7 and MongoDB BI Connector

    Posted Tue September 01, 2020 09:45 AM
    What error message are you getting when trying to connect?

    I've set up a connection to MongoDB in the past. It was to the MongoDB Atlas cloud service instead of on-prem though. One thing is I remember having issues with the drivers at first. Here's a link where I go over how I set it up: https://youtu.be/pRXiQWcPnyo?t=968

    Cheers,
    -Eric

    ------------------------------
    Eric Dolley
    ------------------------------

    Original Message


  • 5.  RE: Cognos Analytics 11.1.7 and MongoDB BI Connector

    Posted Tue September 01, 2020 11:00 AM

    Once you have configured you Mongo BI server to communicate with Mongo DB per the steps Mongo documents.

    You would obtain a copy of the MySQL JDBC driver, which Mongo requires their customers to use.

    Place it under the <cognos>\drivers folder location.

    Mongo was not supporting the MySQL JDBC 8.x JDBC drivers, so you have to use an older 5.x MySQL JDBC driver.



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

    Original Message


  • 6.  RE: Cognos Analytics 11.1.7 and MongoDB BI Connector

    Posted Wed September 02, 2020 09:27 AM
    Hi.
    I will work on your comments.

    Thanks.

    ------------------------------
    Diego Campos
    ------------------------------

    Original Message


Related Content