Cognos 8.4 JDBC connectivity

[Guttal]

Hi All,

Cognos mainly leverages an ODBC connection for its Report Studio. Does any body tried using any JDBC connection? Please let me know the details if it allows to connect using JDBC connection.

Thanks in Advance,
Guttal

[NaviGator]

Hello,

in our environment we have cognos 8.4 installed on AIX machine. Our Content Store and Reporting database both are Oracle. So we are using JDBC to connect to the Oracle database. you will just need to move the driver 'ojdbc14' from your oracle client to your JAVA_HOME configured for Cognos on the AIX machine.

[mpflug]

Cognos does not allow JDBC connections directly to datasources.  You can use JDBC to connect to a content store or audit database but not for a datasource.  Serious hole in my opinion.  We experimented with an ODBC/JDBC bridge but didn't have much success.