It's all about the answers!

Ask a question

RTC datamart vs CLM 2011 data warehouse?


Mikael Schonstrom (164) | asked May 26 '11, 6:37 a.m.
Will the datamart in RTC be replaced by the new data warehouse in CLM/RTC 3.0.1? If that is the case will previous RTC reports built for the datamart stop working on the new RTC 3.0.1 release, e.g if we have created our own BIRT reports. Are there big schema differences between the old RTC datamart and the new data warehouse?

2 answers



permanent link
James Moody (3.3k24) | answered May 26 '11, 9:22 a.m.
JAZZ DEVELOPER
Will the datamart in RTC be replaced by the new data warehouse in CLM/RTC 3.0.1? If that is the case will previous RTC reports built for the datamart stop working on the new RTC 3.0.1 release, e.g if we have created our own BIRT reports. Are there big schema differences between the old RTC datamart and the new data warehouse?


While there are significant schema differences between the old RTC data mart and the new datawarehouse, from the point of view of a BIRT report, these differences are mostly masked by the ODA layer, which is an abstraction between the physical schema and the data warehouse. For example, all of our out-of-the-box BIRT reports will work, unaltered, on both the data mart and on the data warehouse. Compared to 2.x (if that is where they wrote these reports) there are a very small number of incompatible changes that may hit them, particular if they are using the WORKITEM_CHNGS table - these changes are very easy to adopt in the reports (just a change in the format of a few column names, but the data is the same).

So to back up to your first question, the data mart will be replaced by the data warehouse as the primary source for reporting data, and the ETLs (data collection jobs) will populate the data warehouse now. However, from a technical standpoint, we still keep the data mart around for a couple reasons:
1. On our first ETL into the new data warehouse, we do some migration from the data mart, so you keep your history of SCM, Build and Work Items data in the new warehouse.
2. There are still a small number of ETLs that continue to collect into the data mart, because they really collect metadata (not application data) which isn't appropriate for the new warehouse. For example, the repository snapshot which collects sizing information, and the license snapshot. But this is a detail the customer doesn't really need to worry about.

james
CLM and RTC Reporting Lead

permanent link
Bill Taylor (3144) | answered May 11 '12, 4:29 a.m.
Will the datamart in RTC be replaced by the new data warehouse in CLM/RTC 3.0.1? If that is the case will previous RTC reports built for the datamart stop working on the new RTC 3.0.1 release, e.g if we have created our own BIRT reports. Are there big schema differences between the old RTC datamart and the new data warehouse?


While there are significant schema differences between the old RTC data mart and the new datawarehouse, from the point of view of a BIRT report, these differences are mostly masked by the ODA layer, which is an abstraction between the physical schema and the data warehouse. For example, all of our out-of-the-box BIRT reports will work, unaltered, on both the data mart and on the data warehouse. Compared to 2.x (if that is where they wrote these reports) there are a very small number of incompatible changes that may hit them, particular if they are using the WORKITEM_CHNGS table - these changes are very easy to adopt in the reports (just a change in the format of a few column names, but the data is the same).

So to back up to your first question, the data mart will be replaced by the data warehouse as the primary source for reporting data, and the ETLs (data collection jobs) will populate the data warehouse now. However, from a technical standpoint, we still keep the data mart around for a couple reasons:
1. On our first ETL into the new data warehouse, we do some migration from the data mart, so you keep your history of SCM, Build and Work Items data in the new warehouse.
2. There are still a small number of ETLs that continue to collect into the data mart, because they really collect metadata (not application data) which isn't appropriate for the new warehouse. For example, the repository snapshot which collects sizing information, and the license snapshot. But this is a detail the customer doesn't really need to worry about.

james
CLM and RTC Reporting Lead

Hi James

I'm confused between the Data Warehouse and Data Mart collection mechanisms. What is the difference?

Can you switch between them or should you stick with the chosen setting?

For a customer upgrading from RTC 2.0.0.2 to 3.0.1, what are the pros and cons of choosing Data Warehouse or Data Mart collection jobs?

You mention changes to WORKITEM_CHNGS column names. Presumably, the report will fail if it uses the old column names?

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.