schema documentation of the Jazz repository
Hi,
Can anyone recommend me a place to look at if I want to understand the schema of the Jazz repository database? The only documentation I can find is https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas but it only describes a very small fraction of the tables. I have been reverse engineering the semantics of the schema by guessing from the name of the table and the name of the columns and the data type. This works for data stored in a column with a meaningful name, but in some occasions that is not the case. Thanks in advance! Annie |
One answer
The schemas for the Jazz tables is not public. The exact mapping of Object -> table can very based on your DB vendor and setup of your database.
Rather than access the data directly, the Jazz API will allow you to read/query/modify the data in the database without having to guess about how to modify the data in the DB. Is there something you were trying to accomplish that you couldn't find in the API? |
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.