SMAX Database Schema

Hello Experts,

Is there any document that shows the SMAX Database Schema?

We are new to SMAX & we want to know how tables are connected to each others specially the related records.

Thanks

  • Verified Answer

    +1  

    Hi Ulto,

    There is no documentation around how to access the database schema. This is for a specific reason, to prevent any potential damage to the system. If you are looking at how best to understand the information for each Record Type I'd stick with what you can use OOTB.

    To get a feel for how each Record relates to another using Studio certainly gives you a good overview of what all the records are along with the Entities and associations such as Many2Many and the names of those associations.

    Depending on what you are wanting to do with the information. Such as do you want to report on it? If that's the case I'd use something like Odata and view how you can extract data that way and also see how all the data is exposed without having to touch the DB.

    A useful link to look at:

    https://docs.microfocus.com/doc/SMAX/24.3/UseODataForBIIntegration

    Thanks,

    Dave