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
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
looks like Mongo DB is only supported from 11.0.3, just watching a webinar..
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. :)
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.