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:
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

  1. Go to the Rational ClearQuest Reporting Driver installation directory in the CLEARQUEST_HOME/reports/driver folder.
  2. 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