ETL Centreon MBI: ConfigurationΒΆ

Centreon MBI integrates its own extract, transform, load (ETL) capabilities to:

  • Synchronize raw monitoring data with the reporting server.
  • Calculate availability and performance statistics on the reporting server.
  • Manage data retention on the reporting server.

Before following the next steps, you should have read the best practice parts to ensure that the Centreon objects (e.g., groups and categories) are configured according to Centreon MBI requirements.

In the “Reporting > Business Intelligence > General Options > ETL options” menu of the Centreon server, specify the following options:

Options Values
General options  
Reporting engine uses a dedicated MySQL server Yes. You must use a dedicated reporting server.
Compatibility mode to use report templates from version of Centreon MBI prior to 1.5.0 No (concerns only the upgrade from prior versions of Centreon MBI).
Temporary file storage directory on reporting server Folder where dumps will be stored on the dedicated reporting server (depending on your architecture).
Type of statistics to build
  • Select “Availability only” if you only use availability reports.
  • Select “Performance and capacity only” if you only want to use capacity and performance reports.
  • Select “All” to calculate the statistics for both types of reports.
Use large memory tweaks (store MySQL temporary tables in memory) Activated only if your MySQL configuration and allocated physical memory on the server permit.
Reporting perimeter selection  
Hostgroups Select only host groups for which you want to aggregate data.
Hostcategories Select only host categories for which you want to aggregate data.
Service categories Select only service categories for which you want to aggregate data.
Availability statistic calculation  
Live services for availability statistics calculation Select required time periods.
Performance and capacity statistic calculation  
Granularity required for performance data statistics Select level of granularity required to run the desired performance reports (1).
Live services for performance data statistics calculation Select required time periods.
Capacity statistic aggregated by month  
Live services for capacity statistics calculation Select the “24x7” time period.
Service categories related to capacity data monitoring Select the service categories that have been associated with capacity-type services.
Exclude metrics from service categories that do not return capacity USAGE information Concerns the metrics linked to services which return capacity data. Select the metrics that do not return capacity usage information. but a maximum or total value. (e.g., the metric “size”).
Centile parameters  
Calculating centile aggregation by Select the desired aggregation level. The standard percentile report provided with BI 2.1 uses Month data.
Select service categories to aggregate centile on Filter on relevant service categories for centile statistics (e.g., Traffic).
First day of the week Select the first day of the week for Week aggregation.
Centile / Timeperiod combination Create a new centile/timeperiod combination on which to perform the calculation.

(1) Reports requiring a precise value per hour of performance data are listed below. If you do not use the following reports, disable the statistics calculation per hour:

  • Hostgroup-Host-details-1
  • Host-detail-v2
  • Hostgroup-traffic-Average-Usage-By-Interface
  • Hostgroup-traffic-by-Interface-And-Bandwith-Ranges.