Data Target

Rexpondo BI DWH project data source comes from the MySQL database rexpondo.

Transactional tables selected in this database to populate the facts tables into data warehouse are:

• dynamic_field

• dynamic_field_value

• ticket_history

• ticket_working

Tables selected in this database to populate the dimensions tables into data warehouse are:

• article

• article_data_mime

• communication_channel

• customer_company

• customer_user

• group_user

• groups

• queue

• service

• sla

• ticket

• ticket_history_type

• ticket_lock_type

• ticket_priority

• ticket_state

• ticket_state_type

• ticket_type

• users