5. Data Management and Reporting
Importing data, reporting, dashboards, and CMDB
Import Sets and Transform Maps
- • Import Set: staging table for incoming data
- • Transform Map: maps import set columns to target table fields
- • Coalesce: match incoming data with existing records (update vs insert)
- • Data sources: file, JDBC, LDAP, REST
- • Scheduled imports: automate recurring data loads
CMDB (Configuration Management Database)
- • Configuration Items (CIs): hardware, software, services
- • CI Classes: server, network gear, application, database
- • CI Relationships: runs on, used by, depends on
- • Discovery: auto-detect and populate CIs
- • CMDB Health: data quality and completeness metrics
Reporting
- • Report types: bar, pie, line, list, pivot, funnel
- • Report sources: tables, database views
- • Sharing: publish to homepage, schedule email delivery
- • Performance Analytics: KPIs, indicators, dashboards
- • Interactive filters: allow users to drill down in reports
Dashboards
- • Dashboard: collection of widgets displaying reports and data
- • Homepages vs Dashboards: homepage = legacy, dashboard = current
- • Widgets: report, performance analytics, custom HTML
- • Dashboard sharing and publishing
