How to install a DB2 JDBC driver for BIRT in RTC 6.0.3 server?
Hi,
Can someone please help me with (or find) the right instructions to install a db2 jdbc driver in a RTC 6.0.3 server in order to be able to run BIRT reports that pull data from an external database (i.e. other than RTC database)?
I found this article (link below) but it seems to be outdated.
The folders it asks to search for (
org.eclipse.birt.report.data.oda.jdbc*.jar
) do not exist in our installation.
Thank you for help in advance. This is an urgent issue.
One answer
It will be under: <install_dir>/server/conf/<app>/sites/update-site/plugins
where <app> is jts, ccm or qm depending on which app you want to run the BIRT report under.
Look for anything that follows that format, where the '*' is a version number - in my CLM 6.0.6 installation under the ccm app, I have org.eclipse.birt.report.data.oda.jdbc_4.4.2.v201410272105.jar
You then need to unzip this file, add the DB2 driver jar files to it under the drivers directory, rezip it and rename to .jar, and replace the original jar file with the one you've just modified.