Database Schema
- Luc Richard
- Frederick Harju
The Database Schema report described below may require additional one-time and/or annual fees and is part of the premium Business Intelligence (BI) Systems services. For more information, please contact us.
Audience: System Administrators
Location: Site Administration > Reports > Database Schema
Asynchronous: No
Multi-site Friendly: Not applicable *
Description: This report provides a detailed view of the database schema available for the purpose of building custom reports or integrating the system to a Business Intelligence (BI) application as Microsoft Power BI. It is automatically generated by the system based on the database installed on your system and therefore is guaranteed to always be accurate.
* This report simply describes the database schema and doesn't prevent any data. Note however that any queries done directly to the database are not filtered by site. The filter needs to be built-in the SQL itself.