Deciding which data source to use
When creating Report
Builder reports,
you can use data from the data warehouse or from Lifecycle
Query Engine.
Data warehouse
The Data Collection Component requests changes from the CLM applications and the changes are sent to the relational database.
Lifecycle Query Engine
The Lifecycle Query Engine requests changes from the CLM applications and Lifecycle Query Engine stores and indexes the information locally.
Use the following comparison table to decide which data source to use for running your reports. Look down the left column to identify the features you need most.
| Decision points | Which data source to use? | |
|---|---|---|
| Data warehouse | Lifecycle Query Engine | |
| Report on configurations and components. | 
To report about configurations and components themselves, use the Lifecycle Query Engine data source. To report about versioned artifacts in specific configurations, choose the Lifecycle Query Engine scoped by a configuration data source.1 |
|
| Report on historical trends. | |
|
Report on the following types of elements:
|
|
|
| You have thousands of active users. | |
|
| You have more than 5 million resources in the projects that you want to report on. | |
|
| Your server hardware has a minimum of 24 CPU and 96 GB RAM. | See the hardware recommendations for LQE. |
|
| You want a mature set of ready-to-use and ready-to-copy reports. | |
Additional LQE ready-to-copy reports are available from jazz.net. |
| You are interested in more flexible schema-less reports, for example using free text search. | |
|
| Report on data from Rational® solution for Collaborative Lifecycle Management (CLM) applications only. | |
|
| Report on data from non-CLM data sources (Rational ClearQuest® and Rational DOORS®). | |
|
| Query language (for manual query editing) | SQL | SPARQL |
Other considerations
- Reporting on model information from Rational Rhapsody® Design Management is in technology preview. It is not for production use. To learn about the limitations of the technology preview feature, read this Jazz.net article. To enable the technology preview, go to the Data sources page at https://server:port/rs/endpoint, and click the link to read and accept the license agreement.
- The name of the data source for reporting on versioned artifacts in configurations
varies, but the meaning is the same:
- If you create the LQE data sources in Report Builder version 6.0.3, it's called LQE scoped by a Configuration.
- If you upgrade to version 6.0.3, it's called LQE using Configurations
Related tasks:
