Custom JDBC Connection

[hugo001]

Hi,

I am trying to connect Cognos BI via a custom JDBC driver to our database. However, when setting up a new JDBC connection, I have to select a JDBC type from the dropdown (IBM IMS, IBM Informix, IBM Hive), which prefixes the URL automatically with "jdbc:ims" or similar. I need to set this prefix manually.
Any way to do so?

I am using IBM Smart Cloud with the RedHat Cognos BI 10.2 Image

Thanks,
Martin

[MFGF]

What database are you using? Many of the normal relational connection types also provide JDBC access when you are configuring them. For example, if you select SQL Server 2008 Native Client, you can put garbage in the Native Client connection page, then go to the JDBC page and enter the desired JDBC details.

MF.

[Grim]

What database are you using? Many of the normal relational connection types also provide JDBC access when you are configuring them. For example, if you select SQL Server 2008 Native Client, you can put garbage in the Native Client connection page, then go to the JDBC page and enter the desired JDBC details.

MF.

:o ORLY!?¿
That's good to know. I have a feeling they will "patch" that as it's probably not intended.

[hugo001]

Hi,

thanks for that note - however this would use the com.microsoft.sqlserver.jdbc.SQLServerDriver JDBC Driver, but I want to use a proprietary one.
I think it's not possible to do that once you select SQL Server 2008 Native.

Any other ideas?

Thanks,
Martin

[MFGF]

Hi,

If your data source or jdbc is not on the supported databases list, I don't think you're going to have much luck, sorry. There is no "generic" jdbc connection type as there is with ODBC.

MF.

[cognostechie]

I just installed 10.2.1 64-bit for a client . I can do everything but how do I make a JDBC connection to SQL Server?
I tried using SQL Server OLE DB type but in the last screen where it asks for server name etc, I provide everything but
it can't connect. It can connect without JDBC.

Do I have to install the JDBC drivers or they are included in the Java (Java ver 7.0). 

[bdbits]

You have to install the driver, as you would to enable JDBC for any database.

http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

[cognostechie]

Thank you so much bdbits !

[bdbits]

Glad I could help somebody else for once.  8)

[cognostechie]

Why do you say that?  I have seen your posts. You do help a lot of people !

[Jyotsnac]

Hi Martin,

Was there any luck on connecting with custom JDBC. If yes, then please let me know. I am facing the same issue.  We are using Cognos 10.2.1 on Windows 7.

Thanks,
Jyotsna C

[MFGF]

Hi Martin,

Was there any luck on connecting with custom JDBC. If yes, then please let me know. I am facing the same issue.  We are using Cognos 10.2.1 on Windows 7.

Thanks,
Jyotsna C

Cognos 10 isn't supported on Windows 7 - except for the client tools such as Framework Manager. JDBC connections are made via the server component - what OS is that installed on?

I have noticed in my 10.2.1 Fix Pack 1 instance that the JDBC URL appears to be manually editable (is editable a real word?) :) What happens if you replace the initial part of the JDBC URL ("jdbc:ims" etc) with the correct prefix? Does this work?

Cheers!

MF.

[madhancog]

HI,
  I just installed 10.2.1 32-bit  in 64bit windows 2008 server and installed oracle 11g client in the same box .
  I completed all configuration and it is working fine.
  Now i tried to make a JDBC connection to oracle,but couldn't,so i checked in the documentation and placed ojdbc6.jar file in the appropraite path in the cognos folder.but no luck.

then i checked the java version used by cognos10.2.1, it is java 7.0.

Please can any one provide the correct steps for the configuration.

Thanks in advance,
K.M

[MFGF]

Content store or reporting data source?

[kishoremk]

Hello,
   Sorry for reposting the same question, but I am trying to connect to a MS SQL server DB instance through Cognos using a custom JDBC driver ( Data direct drivers). I see that for MS SQL JDBC connection, only the MS supported JDBC driver is picked by default and there seems to be no possibility of configuring another driver. Is there something i am missing or is this how Cognos would be working (not supporting custom JDBC drivers). Could some body pls. confirm. (I am using Cognos 10.x)

thanks.

[MFGF]

Hello,
   Sorry for reposting the same question, but I am trying to connect to a MS SQL server DB instance through Cognos using a custom JDBC driver ( Data direct drivers). I see that for MS SQL JDBC connection, only the MS supported JDBC driver is picked by default and there seems to be no possibility of configuring another driver. Is there something i am missing or is this how Cognos would be working (not supporting custom JDBC drivers). Could some body pls. confirm. (I am using Cognos 10.x)

thanks.

Hi,

Yep - in this case you need to use the SQL Server JDBC driver from Microsoft.

MF.

[the6campbells]

Dynamic Query can only be used with the JDBC drivers which it supports.

Attempting to use a driver which is not supported with cause an non-certified driver error.

Attempting to use a version of a driver which is not supported will cause an unsupported (black listed) error.

If you are using the JDBC connection UI, the only drivers that can be used are the ones shown in the list.

Attempting to use a supported driver while pointing to a server which is not listed on the supported environments page is not supported even if you think you have it working :-)