Configuring the BIRT runtime for Rational® ClearQuest® reporting

This topic explains how to configure the BIRT Report Viewer with the Rational® ClearQuest® Reporting Driver for running ClearQuest® reports. The required files for the Rational® ClearQuest® Reporting Driver are in the reports folder in the ClearQuest® home directory.

Before you begin

To complete these configuration tasks, these components must be available in the Rational® ClearQuest® environment:

Rational® ClearQuest® Reporting Driver
This component is installed automatically with any Rational® ClearQuest® feature. These instructions explain how to deploy it for use with the Business Intelligence and Reporting Tools (BIRT).
BIRT server runtime deployed on the WebSphere® Application Server.
To deploy the BIRT server runtime , see Installing BIRT web archive on WebSphere Application Server and Configuring the BIRT web archive on the WebSphere Application Server.

Attention: The information in this section applies to WebSphere® Application Server version 7.0. See the technote 1569987 for information on installing and configuring WebSphere® Application Server version 8.0.

About this task

The configuration instructions that are described below apply to BIRT version 2.6.2.

For information about configuring BIRT 3.7, refer to technote 1566463.
For instructions on using a script to deploy the BIRT runtime, refer to technote 1960057.
For information about and selecting and installing other BIRT versions, refer to technote 1509579.

Configuring BIRT 2.6.2

To run BIRT reports from Rational® ClearQuest® data sources, copy the ClearQuest® Reporting Driver files to the appropriate directory of the BIRT web application. The Rational® ClearQuest® Reporting Driver files are packaged as Eclipse plug-ins that are installed automatically with any ClearQuest® feature. You can find the plug-ins in this directory:

Windows™: %CLEARQUEST_HOME%\reports\driver

UNIX™ and Linux™: $CLEARQUEST_HOME/reports/driver

The BIRT Viewer plug-ins are found in the WebSphere® Application Server profile directory where Rational® ClearQuest® applications are deployed. The default profile directories for Windows™, UNIX™, and Linux™ platforms are:

Windows™: cq_profile_dir\installedApps\dfltCell\<birt-war.ear>\birt.war\WEB-INF\platforms\plugins

UNIX™ and Linux™: cq_profile_dir/installedApps/dfltCell/<birt-war.ear>/birt.war/WEB-INF/platforms/plugins

Where cq_profile_dir is the default WebSphere® Application profile directory that contains both the Rational® ClearQuest® applications and the files for the BIRT server runtime environment.

Note: The default WebSphere® Application Server cell directory is dfltCell on Windows™, Unix, and Linux™ platforms. On the Solaris platform, the default is <srv>Node01Cell.

Procedure

Go to the Rational® ClearQuest® Reporting Driver installation directory in the CLEARQUEST_HOME/reports/driver folder.

Copy the plug-ins in this directory to the BIRT Report Viewer plug-ins directory cq_profile_dir/installedApps/dfltCell/<birt-war.ear>/birt.war/WEB-INF/platforms/plugins.

com.ibm.rational.clearquest.core.lib
com.ibm.rational.clearquest.jdbc
com.ibm.rational.clearquest.jdbc.nl1
com.ibm.rational.clearquest.oda.jdbc
com.ibm.rational.clearquest.oda.jdbc.nl1
com.ibm.rational.clearquest.stp

What to do next

Verify the BIRT deployment.