It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×10,838
×7,390
×1,219

question asked: Apr 23, 1:08 p.m.
question was seen: 124 times
last updated: Apr 24, 3:27 a.m.

Related questions

FAQ - How this Forum works

Can I connect to DCC (ELM data warehouse) database and retrieve data using SQL?

0
Samarth Prabhu (11●1) | asked Apr 23, 1:08 p.m.

Instead of retrieving the data from CCM project area through API, can I rather connect to data warehouse and directly query for the data? If so, how can I make sure only the data related to one specific project area can be accessed?

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Ralph Schoon (63.1k●3●36●46) | answered Apr 24, 3:27 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

The data warehouse is, as far as I can tell, stored in an relational database. So, you can connect to it and look into it. If this has any benefits is a completely different matter. The data warehouse contains data that is organized for reporting. It does not contain all the data the life repository contains. 


WRT access to project area data, it is up to you to make that sure e.g. by providing a query term.

In general, as far as I am aware, you are not supposed to directly access the database, unless support asks you to do so and how. There might be cases like reporting where you might read the database to get certain data not being available otherwise, but these would be rare cases, as far as I am aware.

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.