Can I connect to DCC (ELM data warehouse) database and retrieve data using SQL?
One answer
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.