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
Hi Torin,
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.
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.
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
