IBM Rational® Reporting for Development Intelligence, Version 2, (also called RRDI) is the reporting tool for the Rational solution for Collaborative Lifecycle Management, Version 4.0 (CLM 4.). This article provides instructions for deploying RRDI 2.0 on an IBM® AIX® operating system and integrating with the CLM 4.0 data warehouse IBM® DB2® database server for IBM Rational Team Concert™, Rational® Quality Manager, and Rational® Requirements Composer to generate reports by using sample report definitions from the respective applications.
Review the setup architecture
The diagram in Figure 1 shows the setup used as the basis for this article. Here. RRDI is deployed on AIX. It also supports Microsoft Windows, Linux, and IBM® System z® platforms. Download the appropriate RRDI package for your setup. See Resources for the link to "System Requirements for Rational Reporting for Development Intelligence 2.0," which provides the list of supported hardware and software details.
This article is based on the assumption that the CLM 4.0 server is already installed and configured, along with database.
Figure 1. RRDI and CLM setup
Set up data storage
Install IBM DB2 and create a database instance.
- While running the Rational Reporting setup:
- Create a content store database that uses this instance.
- Create the DB2 catalog to locally mount the database (data warehouse) of CLM 4.0 on the RRDI 2.0 server.
Important:This is mandatory when you have RRDI on one server and CLM data warehouse on another server. The IBM® Cognos® data source connection for RRDI and DB2 connection string will use localhost.
The following commands help in creating a DB2 catalog on the AIX server:
su – db2instl db2 catalog tcpip node <nodeName> remote <Remote IP Address> server <port number> db2 catalog database DW at node <nodeName> db2 list node directory db2 connect to DW user db2inst1 using <password>
To grant database administration privileges for rptuser, use the following command:
db2 grant dbadm on database to user rptuser
- After creating the database instance and configuring the catalog for connecting to the remote data warehouse, exit from db2inst1.
- Then execute the db2profile and set LIBPATH:
On an IBM® AIX® system, the default library path is 64-bit, but a 32-bit library path is mandatory to complete the Rational Reporting setup successfully.
- Ensure that the 32 bit libraries are installed and export the LIBPATH:
- Verify the library path by using this command:
The remote IP address used while creating the DB2 catalog is the IP address of the CLM 4.0 server with the data warehouse configured. See the "Cataloging a database" citation in the Resources section for details.
Deploy Rational Reporting for Development Intelligence The deployment of Rational Reporting for Development Intelligence (RRDI 2.0) involves three stages:
- Installation of RRDI 2.0
- Setup of Rational Reporting
- Post-setup tasks
Successful installation of RRDI 2.0 on AIX will provide the details to run the Rational Reporting setup. RRDI 2.0 is bundled with the Apache Tomcat server, which helps to run the Rational Reporting setup.
- Before proceeding with the Rational Reporting setup, start the Tomcat server from the RRDI 2.0 installed path:
cd /opt/IBM/RRDI2/setup/tool/JazzTeamServer/server ./server.startup
- Now click Set up Rational Reporting and configure RRDI, using the RRDI setup link:
AIX is the operating system that we used for the deployment while writing this article. If you are working on an AIX system, ensure that the /tmp partition has at least 200 MB space. While preparing the setup for the article, /tmp had 1 GB. See the"Installing Rational Reporting for Development Intelligence" citation in Resources, for the details.
Set up Rational Reporting for Development Intelligence
- Using the RRDI setup link, configure the content store, data warehouse, IBM® WebSphere® Application Server, and report server.
Build and Deploy Reporting Components is the last step while running the Rational Reporting setup. It takes care of the report server configuration. This step usually fails if the 32-bit library is not set properly, as explained previously. Figure 2 indicates the successful completion of deploying the reporting components.
Figure 2. Build and deploy components
- Click Next to see the summary shown in Figure 3.
- Click Finish to return to the RRDI setup page.
Figure 3. Summary page for the Rational Reporting setup
- Click Run post-setup tasks to complete Jazz™ namespace configuration and load Cognos archives. Figure 4 shows the summary of post-setup tasks.
Figure 4. Summary of post-setup tasks
This enables sample report definitions in the public folder on Rational Reporting (see Figure 5) for Rational Team Concert (the change and configuration management software, or CCM), Rational Quality Manager (quality management, or QM), and Rational Requirements Composer (requirements management, or RM). Each folder contains the relevant data warehouse reports.
Figure 5. Sample Report Definitions
See the "Post-installation tasks" link in Resources for the details.
Verify the data source connection
- To verify the data source connection, log in to RRDI 2.0 at http://islswestest5.in.ibm.com:11080/reporting, and click IBM Cognos administration.
- Then open the Configuration tab, select RIDW > more > Test the connection, and click Test, as shown in Figure 6.
Figure 6. Test data source connections
If the connection works, the Status column in the results will show Succeeded, as shown in Figure 7.
Figure 7. Connection test results
Configure the Collaborative Lifecycle Management data warehouse
The data warehouse component in the server's Advanced properties of Collaborative Lifecycle Management is used to configure the data collection user and data warehouse snapshot time, which is nothing but scheduling the job run time and XDC authentication type (see Figure 8). This takes care of the Jazz Team Server and Rational Requirements Composer data collection jobs. For change and configuration management (CCM) and quality management (QM), the application's Advanced properties contain the data warehouse component. Configuration for all of these components should be similar. The data collection user should have a Data Collector license.
Figure 8. Data warehouse component configuration
The CLM 4.0 server is configured with LDAP authentication, and the data collection user specified here is one of the LDAP users who has a Data Collector license.
Schedule data collection jobs
Proper settings in the data warehouse component configuration for Collaborative Lifecycle Management ensures that the data collection jobs are running fine, as shown in Figure 9. Here, the Job Scheduling value is set to run once in 12 hours by specifying the value as 12, and Job History reveals the same in Figure 10.
Figure 9. Data collection job schedule
Figure 10. Data collection job status
Explore sample data warehouse reports After successfully configuring the data warehouse components on Collaborative Lifecycle Management, log in to Rational Reporting for Development Intelligence (RRDI 2.0).
Then you can generate reports for change and configuration management (CCM), quality management (QM), and requirements management (RM) by using the sample report definitions.
These reflect the real-time date of the respective project areas, according to the latest data collection jobs successfully executed.
Figure 11 shows the list of date warehouse reports for CCM that are included in RRDI 2.0. There are also many data warehouse reports included for QM and RM.
Figure 11. List of data warehouse reports available for CCM
Figure 12 shows one of the sample reports generated by using the "Development items implementing or impacting Requirements" date warehouse report.
Figure 12. Sample report
This article explained deploying Rational Reporting for Development Intelligence (RRDI) Version 2.0 and integrating it with the Collaborative Lifecycle Management (CLM) Version 4.0 data warehouse on an IBM AIX operating system. It also provided details about generating reports by using data warehouse reports for Rational Team Concert, Rational Quality Manager, and Rational Requirements Composer, which are all involved in CLM.
- Learn more about CLM:
- IBM Rational solution for Collaborative Lifecycle Management 4.0 information center
- IBM Rational solution for Collaborative Lifecycle Management 4.0 sandboxes
- Collaborative Lifecycle Management page on Jazz.net
- Learn more about reporting with CLM:
- Development intelligence with the CLM solution page on Jazz.net
- What's new in Rational Reporting for Development Intelligence 2.0
- System requirements for CLM 2012, including Rational Reporting for Development Intelligence 2.0
- CLM 2011 reporting workshop
- Building a report in Rational Common Reporting
- CLM online help: Reporting
- IBM Rational Reporting for Development Intelligence (RRDI), YouTube playlist
- Check the Installing Rational Reporting for Development Intelligence information center for detailed instructions, including the Post-installation tasks subtopic.
- Read the Cataloging a database from a client using the CLP (command-line processor) section in the IBM DB2 information center.
- Explore the Rational software area on developerWorks for technical resources, best practices, and information about Rational collaborative and integrated solutions for software and systems delivery.
- Subscribe to the developerWorks weekly email newsletter, and choose the topics to follow.
- Stay current with developerWorks technical events and webcasts focused on a variety of IBM products and IT industry topics.
- Attend a free developerWorks Live! briefing to get up-to-speed quickly on IBM products and tools, as well as IT industry trends.
- Watch developerWorks on-demand demos, ranging from product installation and setup demos for beginners to advanced functionality for experienced developers.
Get products and technologies
- Download a free trial version of Rational software.
- Evaluate other IBM software in the way that suits you best: Download it for a trial, try it online, use it in a cloud environment, or spend a few hours in the SOA Sandbox learning how to implement service-oriented architecture efficiently.
- Join the Rational software forums to ask questions and participate in discussions.
- Ask and answer questions and increase your expertise when you get involved in the Rational forums, cafés, and wikis.
- Join the Rational community to share your Rational software expertise and get connected with your peers.
- Rate or review Rational software. It's quick and easy.
Dig deeper into Rational software on developerWorks
Get samples, articles, product docs, and community resources to help build, deploy, and manage your cloud apps.
Keep up with the best and latest technical info to help you tackle your development challenges.
Software development in the cloud. Register today to create a project.
Evaluate IBM software and solutions, and transform challenges into opportunities.