Cognos connect to MySQL database with JDBC

[scoebke]

Hi,

I need to connect FM with MySql. I only see "good" practice with ODBC connection. This is currently working.
But does anyone has already connected with a JDBC connector?

Kind regards
   Scoebke

[MFGF]

I am 99.99999% sure that JDBC connectivity to MySql is not available in Cognos 10. There is no native connectivity as far as I know, so ODBC is your only option.

MF.

[scoebke]

txs for the reply :-)

[thosas]

I know this is an old thread now but it seems to be available as a supported JDBC connection within 10.2.2 - just for the information of those, like me, who were looking for this information.

[Blue]

Yes it is in CBI 10.2.2.  However you need to provide the actual MySQL JDBC driver; it's not provided with CBI, just the option to use it is.

Does anyone know the name of the actual driver .jar file?  I assume once I copy I need to copy it to the vdataserver or the webapps\p2pd\WEB-INF\lib folder.  True?  Which one?

[thosas]

Hey, I added it to my Cognos Analytics box a while back now, on inspecting the folder, I can see I have mysql-connector-java-5.1.37-bin.jar inside there.  Seems to be doing the trick for me at the moment.

Justin

[the6campbells]

Suport for MySQL via DQM/JDBC was introduced in 10.2.1 - refer to http://www-01.ibm.com/support/docview.wss?uid=swg27047186 to see which versions of MySQL are supported.

MySQL JDBC drivers can be downloaded from https://dev.mysql.com/downloads/connector/j/

Prior to Cognos 11, you would drop the JAR files into <cognos>\webapps\p2pd\web-inf\lib

In Cognos 11 drop them into <cognos>\drivers

[Blue]

Thanks guys.

IBM has changed the driver location in CA11.0.4! 

Cheers,

Bob