Querying RRC Database
Dear all,
Want to Query RRC Database and extract the list of RRC ID, Artifacts type, created date, created by, modified date, modified by to have a total inventory of RRC created for control purposes
With query i shall use various fillters and take the list that suits my consumption from time to time
How to do it..? There is no adhoc reporting in RRC and there is export available at each screen, but it is too time consuming and not getting me anywhere on keeping tab on daily basis
Any help would be appreciated
Advance thanks for your help
3 answers
Hello Vivekanandan,
if you have a configured data warehouse you can also get most of those information querying it.
You can see the details of the relations between RRC elements and Data Warehouse tables here:
Data dictionary for requirement artifacts
http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.2/com.ibm.rational.rrm.help.doc/topics/rm/rm-roles.html
check Data Warehouse Schema, Data Warehouse Table, Data Warehouse Column.
Best Regards,
Francesco Chiossi
if you have a configured data warehouse you can also get most of those information querying it.
You can see the details of the relations between RRC elements and Data Warehouse tables here:
Data dictionary for requirement artifacts
http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.2/com.ibm.rational.rrm.help.doc/topics/rm/rm-roles.html
check Data Warehouse Schema, Data Warehouse Table, Data Warehouse Column.
Best Regards,
Francesco Chiossi
I don't think any existing features will meet your requirement. I believe you need to build your own tools using available APIs such as the reportable REST API.
https://jazz.net/wiki/bin/view/Main/RRCReportableRestAPI
https://jazz.net/wiki/bin/view/Main/RRCReportableRestAPI
Comments
Yes, the reportable REST API would be a good choice.
Another option, though it would mean programming to extract what you want is the OSLC REST API: OSLC Rest API Workshop