Analytical database (deprecated)
Because performing data analyzes and creating reports over a production database in normal operation can slow down application response, we recommend creating these analyzes and reports over a separate analytic database.
On SQL Server, create an analytic database (e.g., named ALVAO_ANALYSIS) from the current backup of the production database and lock it against writes (read-only) to improve performance. It is recommended to update the analytical database daily from the last daily backup of the production database, e.g. with a scheduled job. The scheduled task can run, for example, a cmd script that you create using the script template and modify the disk file paths and server and database names in the script.
In Administration - Settings - Data Analysis then set up the connection to the analysis database.
The analytics database is for analysis and reports only. Do not work with it directly in Alvao applications!