Database Archiving
Prepare Archive Database¶
Create a new database user with the appropriate permissions
Connect to the database user and run archive_schema.sql from the Archive folder in ActiveAccess installation package.
To give access to the current ActiveAccess database user
In the archive_grant.sql from the Archive folder in ActiveAccess installation package, replace the tags < archiveusername > with the newly created database user for archiving, < dbname > with the database owner name, and < dbuser > with the database user name that accesses the database. In a simple configuration the database user name may be the same as the database owner name.
Note
The < dbname > and < dbuser > can be found in Tomcat_Home\bin\config\acsconfig.properties as DBNAME and DBUSERNAME respectively.
- Run the updated archive_grant.sql with a sys/system connection.
Schedule Archiving¶
System Management > Archive Management
Click the Edit link
Tick the Automatic archive checkbox to enable automatic archiving
Fill the remaining fields as appropriate
For purging the archived data:
Tick the Automatic archive purge checkbox to enable automatic archiving
Fill the remaining fields as appropriate
Click the Apply button.
Configure Archiving¶
System Management > Archive Management > Archive Databases > New Archive Database
Enter the Archive Database link or Database user
Click the Apply button.
Set Default Archive Database for Search¶
System Management > Archive Management > Archive Databases
- If you only have one archive database configured, it will automatically be set as the default for search. If you have more than one archive database configured, click the Set as default for search link for the desired archive database.
Set Default Archive Server¶
Servers > MIA Servers
- Click the Set as default archive server link for the desired MIA Server.
Check Archive/Purge History¶
System Management > Archive Management > Archive Databases
Click the Archive database link to go to the Archive Database Details page
A list of archive and purge history reports will appear under Archive History and Purge History tabs