Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: Guttal on 09 Mar 2010 06:43:13 AM

Title: Cognos 8.4 JDBC connectivity
Post by: Guttal on 09 Mar 2010 06:43:13 AM
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
Title: Re: Cognos 8.4 JDBC connectivity
Post by: NaviGator on 10 Mar 2010 02:48:25 AM
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.
Title: Re: Cognos 8.4 JDBC connectivity
Post by: mpflug on 11 Mar 2010 10:49:01 AM
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. 
Text only | Text with Images