The MetaMiner Database Model¶
MetaMiner stores most of its data within its Postgres repository. This includes data from:
- BI/Analytic Platform Metadata
- SAP BusinessObjects
- Tableau
-
Database Systems
- Oracle
- MS SQL Server
- SAP HANA
-
Performance metrics (Windows, Linux, etc.)
Top-level tables¶
| Object Type | MMDB Table Name | Datatype Name |
|---|---|---|
| Analysis for OLAP | ANALYSIS_OFFICE |
ANALYSISOFFICE |
| Analysis for Excel | ANALYSIS_WORKBOOK |
ANALYSISOFFICEWORKBOOK |
| Windows AD Plugin Settings | AUTH_SECWINAD |
SECWINAD |
| Applications | BO_APPLICATIONS |
BO_APPLICATIONS |
| Bookmarks | BOOKMARKS |
BOOKMARKS |
| Business Views | BV_ALL |
BUSINESSVIEWS |
| Crystal Documents | CRYSTAL_DOCUMENTS |
CRYSTAL1200 |
| Custom Attributes | CUSTOM_ATTRIBUTES |
CUSTOMATTRIBUTES |
| Data Connections (basic) | DATA_CONNECTIONS |
DATA_CONNECTIONS |
| Data Connections (BI4) | DATA_CONNECTIONS1400 |
DATA_CONNECTIONS1400 |
| Design Studio | DESIGN_STUDIO |
DESIGNSTUDIO |
| Documents | DOCUMENTS |
DOCUMENTS |
| Events | EVENTS |
EVENTS |
| Folders | FOLDERS |
FOLDERS |
| Hyperlinks | HYPERLINKS |
HYPERLINKS |
| Overloads - UNV | OVERLOADS |
OVERLOADS |
| Overloads - UNX | OVERLOADS_UNX |
OVERLOADSUNX |
| Roles | ROLES |
ROLES |
| Universe - Basic | SEMANTICLAYER |
SEMANTICLAYER |
| Sessions | SESSIONS |
SESSIONS |
| Shortcuts | SHORTCUTS |
SHORTCUTS |
| Universes - UNV | UNV2_UNIVERSES |
UNV |
| Universes - UNX | UNX_UNIVERSES |
UNX |
| Groups | USERGROUPS |
GROUPS |
| Users | USERS |
USERS |
| Web Intelligence (XI3) | WEBI1200_DOCUMENTS |
WEBI1200 |
| Web Intelligence (BI4) | WEBI1400_DOCUMENTS |
WEBI1400 |