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
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.
txs for the reply :-)
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.
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?
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
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
Thanks guys.
IBM has changed the driver location in CA11.0.4!
Cheers,
Bob