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
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?
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?