Skip Navigation LinksALVAO 8.2ALVAO Asset ManagementSystem Implementation in an OrganizationAnalytical Database Skip Navigation Links. Skip Navigation Links Skip Navigation Links.


Analytical Database

We recommend to execute the data analyses and reports on the analytical database, which is a copy of the production database from previous day. This database is read-only. This ensures the ALVAO system performance is not slowed.

Set the analytical database connection in AdminManageSettingsData analysis tab. This connection will be preset for each workbook newly opened from SD ConsoleDisplayData analysis.

Tip:
If you backup the ALVAO production database every day, you can use this script to everyday update of the analytical database.

 

Did not find what you were looking for? Ask our technical support team.