Can I connect to DCC (ELM data warehouse) database and retrieve data using SQL?
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
Ralph Schoon (63.6k●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
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.