If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

CA connection to mongo

Started by Binway, 17 Aug 2016 05:31:58 PM

Previous topic - Next topic

Binway

Hi Folks,
I have installed Congos Analytics 11.0.1 on Windows 10 and am attempting to connect to Mongo following the steps in https://docs.mongodb.com/bi-connector/installation/.
One of the steps is to install the postgresql-9.4.1209 jar file in CA, unfortunately I cannot find where it specifies the directory for the file to go.
I have seen <cognos root>/drivers in my research so i have installed it in C:\Program Files\IBM\cognos\analytics\drivers\ as well as the directories suggested at IBM at http://www-01.ibm.com/support/docview.wss?uid=swg21960854 (this is for 10.2.1).
And have stopped and restarted the machine everytime I copied the file into the suggested directories.
But I still get the error "XQE-JDB-0004 A problem occurred finding the driver class org.postgresql.driver" when I attempt a connection via Manage -> Data Servers -> postgres.
So I am not sure where CA pickes this jar file up from.
Any suggestions appreciated.

Binway

Binway

stopped and restarted cognos config manager.
Pretty certain you only need the postgresql jar file in the /driver directory.
The issue was me not reading the installation notes correctly eg the database name:
From the Mongo installation notes


Host   The hostname of the server on which you installed the MongoDB Connector for BI in step 1.
Port   27032 by default.
Username    The username you specified when creating your MongoDB Connector for BI user with mongobiuser in step 2.
Password   The password you specified when creating your MongoDB Connector for BI user with mongobiuser in step 2.
Database   (not the database name in mongo)Same as your username specified above

Thanks

cadams

looks like Mongo DB is only supported from 11.0.3, just watching a webinar..

Binway

That is correct. I thought the Postgres dataserver option would be ok but computer says "No". You will not see the Mongo Database Connector option in the dataserver options until you upgrade to 11.0.3 - had to do an upgrade last night.
You still need the postgresql driver add to the /drivers directory.
Quite a spiffy piece of kit - now working through creating a report/dashboard - it's not exactly the same as versions 8/10 which is making me use my limited amount of grey matter. :)

the6campbells

While Mongo may have believed their solution "is just Postgres", code changes were required to address some of the quirks in their 1.x solution.