Rexpondo BI DWH components and processes

Components identified for the Business Intelligence Data Warehouse project are:

  • Data Target: Database MySQL rexpondo. Note: name of the Target DB is present inside Kernel/Config.pm file

  • ETL Rexpondo DWH: MySQL procedures read data from the rexpondo database and after a series of transformations, it is saved into rexpondo_dwh data warehouse

  • Data Warehouse: MySQL database rexpondo_dwh with the dimensions and facts tables, as well as the ETL procedures

Graphic representation of the Rexpondo BI DWH components:

https://docs.rexpondo.org/dwh/en/11.2/_images/componenti-BI-DWH.jpg