Running BIRT reports that connect to MySQL databases in SCTM 17.0 onwards

0 Likes

Problem:

When using the BIRT RCP Designer it is possible to design reports that pull data from multiple data sources or databases e.g. SQL Server, Oracle, MySQL and many more.

As long as the relevant JDBC driver for the database is installed on the machine then BIRT is able to access it when you add the JDBC driver jar file via the “New Data Source” Wizard. For further information on this please check the BIRT help files.

However as SCTM only supports SQL Server and Oracle you may get an error message similar to that shown below when you try to run a BIRT report that uses a different database than these from inside SCTM:

“Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
Cannot load JDBC Driver class: com.mysql.jdbc.Driver.”

The reason for this error is because SCTM does not have access to the relevant JDBC driver for the data source or database in use by the report. In this case the error message is referring to the MySQL JDBC driver.

Resolution:

For Silk Central 17.0 and later, copy the JDBC driver (tested with mysql-connector-java-5.1.37-bin.jar) 

to the lib/CS folder of the Silk Central instance,


\Silk\Silk Central 17.5\instance\lib\cs.


For example: C:\Program Files (x86)\Silk\Silk Central 17.5\instance_1_silk\lib\cs. 

You then need to restart the chart servers.

Comment List
Anonymous
Related Discussions
Recommended