Highlighted
Regular Contributor.
Regular Contributor.
149 views

Database Schema

Where can I find a database schema for Performance Center so I can create my own queries and reports?

 

Thanks,

0 Likes
4 Replies
Highlighted
Super Contributor.
Super Contributor.

Re: Database Schema

Hi,

 

Which version of ALM/PC are you working with?

For ALM/PC 12.20, please refer to the Project Database Reference guide:

https://softwaresupport.hp.com/group/softwaresupport/search-result/-/facetsearch/document/KM01284441 

 

Hope this helps.

 

Regards,

./Sébastien Amoussou 

Thanks,

./Sebastien
0 Likes
Highlighted
Regular Contributor.
Regular Contributor.

Re: Database Schema

Thank you very much. We are currently at 11.0 and upgrading to 12.+

 

Thanks!

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Database Schema

Sure if you want the schema itself, it on the DB server whichever your ALM server is pointing to. It can be seen under SiteAdmin website->Database tab. Then on the server you will have your sa schema, LAB project schema and all project databased listed by name. You can either do an inplace upgrade where it will upgrade your current DB or you can use a new setup including DB server to export/import the schemas and upgrade them ALM 12.x SiteAdmin website

 

There is a detailed upgrade section in our documentation too that explains the procedures step-by-step. Please look under ALM Admin guide. You should also be able to find some KB articles around this

 

Thanks,

HP Support

Microfocus Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: Database Schema

but - the SiteAdmin database schema is not documented anyplace.

 

HP - any plans on providing the SA database schema? Some of us have been asking for this for 15+ years.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.