The following topics provide information about configuring the HxGN EAM data warehouse and accessing data warehouse administration features.
These topics describe HxGN EAM functions that only a system administrator has rights
to perform.
The data warehouse is a set of summary tables embedded within the HxGN EAM database used for extracting report information for HxGN EAM Analytics. The data warehouse enables you to combine databases across your entire enterprise.
The system extracts the reporting data from the production tables into the data warehouse data marts using a selective Extract, Transform, and Load (ETL) process that enables you to specify which data marts will be populated by the ETL. Configure the selective ETL process by setting the necessary data warehouse installation parameters and drivers, and the system will execute the ETL process that populates the data warehouse tables based on the installation parameters and schedule period specified during configuration.
The data warehouse administration functions enable you to specify and save parameters for running the data warehouse data loads and data purges, and they also enable you to view log messages and errors that are recorded during the execution of the data warehouse process.