[SOLVED] Cognos 10.2.1 + Postgres in DQM

[Michal_Husaria]

Hello there,

I have problem with getting working togerther Cognos 10.2.1 (with latest FP) and Postgres 9.3 (also tested 9.2).

I am trying to use Postgres as data source in DQM. I have installed Postgres (9.3 on the same machine, and 9.2 on remote host). I have added and tested Postgres as JDBC datasource in Admin panel - it went ok. I can select this database in FM (I have published a cube in DQM) and RS (just simple report, also work fine). What does not work is Cube Designer - when I am creating new projet I cannot select any postgres database. I can see all JDBC data sources, I can see databases but when I select one of them - the button OK is inactive. I have also DB2 databases and I can work with them.

Any idea what I should test / configure ?

I am using:
Cognos 10.2.1 (latest FP) + TM1 10.2 (also latest FP) on win 2008 R2. Postgres 9.3 and / or 9.2. I have tested this with JDBC drivers type 4 and 41 (I am not sure which should be used - SDK 1.7 requires 41 type, however on IBM site I can find info that only Postgres 9.2 is supported in DQM also jdbc type 4...).

[Striker]

Hi,

did you manage to solve this problem?

[Grim]

Is cube designer on the same machine as the Cognos server? If not you will need to install and configure the Postgres ODBC/JDBC driver and connection on the machine where Cube Designer is installed.

[Michal_Husaria]

Hi there,

it turned out, that Cognos does not support Postgres as datasource in DQM and for Dynamic Cubes. The info on the IBM Site was not clearly explained, and I must have it misunderstood.

After the lecture:

http://publib.boulder.ibm.com/infocenter/prodguid/v1r0/clarity-reports/report/html/prereqsForProduct?deliverableId=1283262749193

http://publib.boulder.ibm.com/infocenter/prodguid/v1r0/clarity-reports/report/html/prereqsForProduct?deliverableId=1330380859450

I could find info that Postgres works with Cognos but "Available via ODBC in the Compatible Query Mode.". Also, just CQM.