DWH & CCM DB Schemas

Valery Serogodsky (11●1●2) | asked Aug 23 '13, 7:52 a.m.
edited Aug 23 '13, 7:53 a.m.

Our company uses RTC. I want to create SQL queries to read RTC data from DB directly. I've already created a lot of queries. And all of them select data from DHW schema. ... But now I have a problem.

Business Need work item has customized field “Target Release” in our RTC system. The field allows to select one of iterations. I’ve found values of this field in “model”.”work_item_item_extensions” table of CCM schema and I’ve not found this field in DWH schema which I use for queries.
The questions: is data from “model”.”work_item_item_extensions” table copied from CCM to DWH schema or not? if yes in which table?

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

John Carolan (716●1●6) | answered Aug 23 '13, 8:34 a.m.

Hi Valery,

I think the following document may help you:

http://www.ibm.com/developerworks/rational/library/add-a-rational-team-concert-data-warehouse-extension-for-custom-attributes/index.html

Regards,

John

Comments

Valery Serogodsky commented Aug 23 '13, 8:56 a.m.

Thank you John! I will look in the document.

Valery Serogodsky commented Sep 06 '13, 7:52 a.m. | edited Sep 06 '13, 7:53 a.m.

I've looked in the document. It was very interesting. Now I know how custom attributes are stored better. But my question still exists ...

Values of “Target Release” custom attribute are stored CCM schema (“model”.”work_item_item_extensions” table). I found them. It's clear for me.
Data from ССM schema are transferred to DWH schema according to a schedule.
Table structure of DWH schema differs from table structure of CCM schema. And my problem is I cannot find “Target Release” custom attribute in tables of DWH schema.

It's all about the answers!

Related questions

DWH & CCM DB Schemas

One answer

Your answer