Connector for BI with Cognos

192 views

Skip to first unread message

Monica at IBM

unread,

Sep 10, 2018, 5:46:23 PM9/10/18

to mongodb-user

Looking for help with using the Connector with Cognos. I've installed the Connector and database combination on a dev server and using the Cognos UI have not been able to connect to MongoDB. We configure the connection to use Connector for BI which and use jdbc:mysql://<host>:<port>/database and connect anonymously. We did install the mongosql-auth-1.1.0.jar, mysql-connector-java-5.1.47-bin.jar.

We are getting the following error:

"XQE-DS-0006 Unable to logon to the data source.

Communications link failure
The last packet successfully received from the server was 5,029 milliseconds ago. The last packet sent successfully to the server was 5,023 milliseconds ago.

Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."

Does anyone know if this is the result of some configuration error on the MongoDB, or on the Connector?

Does Cognos want a username and password regardless of it being connected anonymously? (the database has no authentication--for now.)

Thank you in advance for any light you can shed!

Wan Bachtiar

unread,

Oct 9, 2018, 9:37:31 PM10/9/18

to mongodb-user

Does anyone know if this is the result of some configuration error on the MongoDB, or on the Connector?

Hi Monica,

It’s been a while since you posted this question, have you found a solution yet ?

I haven’t used Cognos myself, but perhaps this forum post : Cognos analytics with MongoDB on IBM Cognos Community forum may be able to point you in the right direction.

You can also test just the MongoDB BI Connector setup by using another client, or simply mysql client to determine whether the misconfiguration lies.