JDBC on a MySQL Database

[Lukas]

Hi experts,

I'm currently working with a client who use a MySQL Database which is connected to Cognos using a ODBC connector. But now I need to switch the query mode to Dynamic and that can only be done using a JDBC connexion (from what i've seen in the IBM documentation).

I've put the drivers .jar in the v5dataserver\lib and WEB_INF\lib folders on the server and tried to create a new datasource in Cognos Admistration.

My problem is :
The MySQL connection isn't available by default in the connection type. So i tried to use the "JDBC" type, but then I can only choose between a few type ("IBM Infomix", "IBM IMS", "IBMInfoSphere"...) but, again, no sign of MySQL...  :'(

Have someone did this before ? Could you guide me on the correct procedure ?

I also tried to use the "Other" connection type, and to write the connection string ("jdbc:mysql://<server adress>:<port>/<Database name>"), but i get an error : "QFS-ERR-0138 the data source 'xxx' is not supported by any provider"

Thanks in advance !  :)

Lukas

[MFGF]

Hi experts,

I'm currently working with a client who use a MySQL Database which is connected to Cognos using a ODBC connector. But now I need to switch the query mode to Dynamic and that can only be done using a JDBC connexion (from what i've seen in the IBM documentation).

I've put the drivers .jar in the v5dataserver\lib and WEB_INF\lib folders on the server and tried to create a new datasource in Cognos Admistration.

My problem is :
The MySQL connection isn't available by default in the connection type. So i tried to use the "JDBC" type, but then I can only choose between a few type ("IBM Infomix", "IBM IMS", "IBMInfoSphere"...) but, again, no sign of MySQL...  :'(

Have someone did this before ? Could you guide me on the correct procedure ?

I also tried to use the "Other" connection type, and to write the connection string ("jdbc:mysql://<server adress>:<port>/<Database name>"), but i get an error : "QFS-ERR-0138 the data source 'xxx' is not supported by any provider"

Thanks in advance !  :)

Lukas

Hi,

Sounds like you're using an older build of Cognos 10? In 10.2.2 you can choose the JDBC connection type, then on the next page you can choose MySQL. This populates the JDBC URL with jdbc:mysql://<host>:<port>/<database-name> and it populates the Driver Class Name with com.mysql.jdbc.Driver

Try choosing one of the other types such as IBM Informix, then replacing the JDBC URL and the Driver Class Name with the appropriate entries as above. Might work? If not, try the "Other type" option and populate the connection string with ;LOCAL;JDBC;URL=jdbc:mysql://<host>:<port>/<database-name>;DRIVER_NAME=com.mysql.jdbc.Driver;

If that fails too you need to upgrade to a newer version of Cognos BI. I'm using 10.2.2 here.

Cheers!

MF.

[Lukas]

Hi and thanks for your response !

Indeed, for now we're using Cognos 10.2, so that seems to be issue... We're now working on upgrading the version, thank you very much !

Lukas

[MFGF]

Hi and thanks for your response !

Indeed, for now we're using Cognos 10.2, so that seems to be issue... We're now working on upgrading the version, thank you very much !

Lukas

I'm guessing you had no success with either of the workaround suggestions?

MF.

[Lukas]

I'm guessing you had no success with either of the workaround suggestions?

MF.

Nope, I tried them both but unsuccessfully !

Lukas

[the6campbells]

Support for MySQL via JDBC was first added in IBM Cognos BI 10.2.1

You can visit the public web pages showing what is supported and when etc . google for "ibm cognos supported environments"