Looking for a complete performance warehouse schema and table definitions.
Looked through the documentation but unable to locate it.
I know it is not something dynatrace advice to do, do to potential overload of the database.
But we are looking to make a nightly copy of the database and then use our BI solution to query data from the copy.
We prefer this solution rather then REST API, purelytics stream and business transaction data feed.
Solved! Go to Solution.
the ddl file is located in .../server/conf/repository/<DBMS>/create.ddl, albeit in a slightly convoluted way due to the fact that we want the scripts to be re-executable.
The tables are listed in Andi's post here:
and the measurement lookup tables are explained here:
Note that the schema changes (sometimes considerably) between releases and is therefore not a supported / stable API to our data. Best regards,