Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Difference bw database and datawarehouse

Questions
Tags
Users
Badges
Chandrahasa Reddy D
(57●1●53●60) May 29 '12, 6:45 a.m.
Hi,
We can see when we run the JTS setup, we could see configure database, configure datawarehouse for each of the applications like ccm, qm etc..
What database stores and what datawarehouse stores? please suggest :)

0 votes

2 answers
4,272 views
0 votes

2 answers

Permanent link
Paul Slauenwhite
FORUM MODERATOR / JAZZ DEVELOPER (8.4k●1●2) May 29 '12, 7:37 a.m.
The JTS and it's applications (e.g. RTC/RRC/RQM) have a database for their resources/artifacts. These resources/artifacts are Extracted/Transformed/Loaded (ETL) to the data warehouse for reporting (e.g. BIRT/IBM Rational Reporting for Development Intelligence (RRDI)/IBM Rational Insight).

0 votes

Permanent link
Jun Wang
(607●7) May 29 '12, 10:12 p.m.
It is correct. The data warehouse is for reporting that storing data from CLM server (by ETL) and historical data, it is required for DW reports.

The JTS and it's applications (e.g. RTC/RRC/RQM) have a database for their resources/artifacts. These resources/artifacts are Extracted/Transformed/Loaded (ETL) to the data warehouse for reporting (e.g. BIRT/IBM Rational Reporting for Development Intelligence (RRDI)/IBM Rational Insight).

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: May 29 '12, 6:45 a.m.

Question was seen: 4,272 times

Last updated: May 29 '12, 6:45 a.m.

Confirmation Cancel Confirm