It's all about the answers!

Ask a question

Is it possible to add OOTB fields from RTC to the Rational Data Model?


Michael Walker (99215201157) | asked Jul 25 '13, 6:28 p.m.
I noticed some of the standard fields in Work Items like Description aren't part of the Data Warehouse and available to be reported on.   Is it possible to add them in?  We have a customer who wants to add the field into a report that they share with a vendor as the vendor cannot access their Team Concert.

Accepted answer


permanent link
Francesco Chiossi (5.7k11119) | answered Jul 26 '13, 11:09 a.m.
Hello Michael,

as long as the data you want to add to your Insight reports is exposed from the REST API it should be possible to customize the ETL process and data model to include this data.
See Reportable REST API for the documentation of what can be extracted from the RTC REST API.

The ETL customization process is described in this tutorial:
Customizing the extract, transform, and load (ETL) process

I hope this can help as a staring point.

Best Regards
Francesco Chiossi
Michael Walker selected this answer as the correct answer

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.