How do you pull data from RRC and RTC into one report?
We have a series of questions related to pulling reports in RRDI:
1. How would one go about pulling data from multiple Jazz platforms (RRC and RTC) into one report? Using RRDI, we are unable to locate a primary key info or foreign key that relates a requirement in RRC that we’ve linked to a work item in RTC.
2. How do we gain access to the hidden lookup tables operating in the background of RRDI?
3. Does the Jazz Web UI access the data schema through SQL queries or an API?
Thank you!
Accepted answer
1) The CLM Java ETLs load data from the CLM tools (RTC, RQM and RRC) into the data warehouse. RRDI reads that data from the data warehouse. If your RRC and RTC environments belong to the same JTS and have existing artifacts that are linked to each other (eg a requirement is linked to a workitem), then the CLM Java ETLs automatically loads that relationship into the data warehouse.
- To realize this relationship in Report Studio, I will provide an example
- Create a new list report
- Go to "Operational Data Store" > "Request Area"
- Expand the "Request" query subject and drag the "Reference ID" (belonging to the work item) data item into your list report
- Now go to the "Request Related Requirements" query subject and drag that "Reference ID" (belonging to the requirement) data item into your list report
- Run the report and you should see a list of work item records (by ID) and the related requirement records (by ID)
2) Users do not have access to this using RRDI. The ETLs and framework are non-customizable. You need to upgrade to Rational Insight to have access to the developer tools which allow for complete customization of the ETL and framework data model.
Comments
Thank you Marc! Do you know of any resource on the database side or within CLM that allows you to view how Web UI terms map to database terms? E.g. Work Item = Request.
Thanks again!
Hi Torin,
No problem.
Yes, we call these "data dictionaries" (main link): http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m5/index.jsp?re=1&topic=/com.ibm.rational.reporting.overview.doc/topics/c_reference_datadictionary.html&scope=null
Just select the CCM or RM data dictionary as needed from this page. We also provide the QM mappings for Rational Quality Manager. Then you simply select the resource you are interested in and we provide the end to end mapping for that resource. FYI, this is for v4.0.5. I am not sure what version of CLM you are running but you can find the equivalent in the other infocenters.