Where can we find table information and the data contained within them for PPM and the Data Warehouse?

Document ID : KB000095697
Last Modified Date : 14/05/2018
Show Technical Document Details
Introduction:
We're looking to create a new report or portlet, and we need information on items like the table names, the primary keys, and where to find specific data in those tables. This includes data on items like resources, tasks, project, investments, etc., so it would be helpful to have the table names and the data stored within them.
Question:
Where can we find table information and the data contained within them for the PPM Schema and the Data Warehouse Schema?
Environment:
All supported PAS environments.
Answer:
Our database schema documentation provides information on the above. Items like the table names, what they store, the primary keys, and the columns contained within them can be found in the schema documentation.

The database schema documentation is available for both the PPM Database Schema, as well as the Data Warehouse Schema and is separated by version. To make use of the documentation, follow these steps

1) Navigate to the CA PPM Advanced Reporting and Database Schema Index page
2) Under the Release column, find the release version your environment is on
3) Click on the CA PPM Database Schema or Data Warehouse Database Schema links to download the documentation for that schema
4) Extract the contents of the download and then open the index.html file into a browser

From there, you'll see the tables contained within that schema on the left side of the page, and information on the tables on the right. This should provide insight on where certain data is stored, the tables to query for that data, and the data type it is stored in.