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