Galilee is the "Business Intelligence" or data warehouse module of the application. It includes a data warehouse feeder.
The data warehouse will contain data exported from the production database at a frequency to be determined (generally refreshed every working day). Its schema is organized so as to be easily exploitable and queryable without the need for in-depth knowledge of the model.
Data export to a SQL manager / BI tool is configured in Galilee . Galilee
Rights required : Configuring Galilee to access this screen and possible actions
Read more : Galilee memo (Datamart)
Synchronization takes place in two stages:
- Delete all Galilee database tables
- Create tables and insert data from the application into the Galilee database
Les données de l’entrepôt couvrent l’essentiel des données de l’application.
In this screen, you can :
- choose the attributes (configured in the platform, such as project weather for example) and themesbudget, law, exchange, planning, resource, risk and task) that will be synchronized in Galilee.
- run Galilee synchronization manually
Synchronization can be performed :
- manually by clicking on Run.
- automatiquement en paramétrant au préalable le fichier de configuration de l’application.
A background task command is launched when the update is executed. You can track its progress and status, as well as the user who issued the command. Background commands
Here are the different fields to fill in:
Validates your changes. This may redirect you to the previous page on some screens.
This button is used to synchronize selected attributes and themes with Galilee .
Permet de modifier la configuration.