Data Storage
These settings allow to specify the type and parameters of the database, which will be used to store the collected data.
Printer Activity Monitor allows to store the data of the printed documents in the following database formats:
- SQLite
- MS Access
- MySQL
- Oracle
- PostgreSQL
- MS SQL
By default, the data is stored in SQLite format but the database format can be changed to any other.
You should specify the data storage name, the database type and its optional description in the dialog, specially designed for this purpose.
Attention! Before adjusting the connection settings you should create and configure the database BY YOURSELF using DBMS tools as it is shown in one of the chapters of this help section.
After you have chosen the data storage name and the database format you should specify the database connection settings, the program uses to gain access to the database.
The content of the Connection Settings tab may change depending on the selected database format.
As you click on Test Connection button the program tests connection with database and if all settings are adjusted correctly it informs you about it in a message. If it is impossible to connect to the database the program displays an error report on invalid input data.
The Statistics tab shows information about the data storage. This tab shows such information as:
- the storage size on the disk
- the names and versions of all data schemas present in the storage
- the number of records in each data schema
- the date of the earliest record in the data schema
- the date of the most recent record in the data schema
The Maintenance tab allows you to limit the storage size and the time to store information for.
- Delete records older than (days) - this setting allows you to specify the number of days after which a record will be considered outdated and deleted from the data storage.
- Limit data storage size (GB) - this setting allows you to limit the data storage size. In case the data storage size limit is exceeded, the program can do the following:
- Deleting older records as necessary
- Discarding new entries
The program allows you to delete records from the data storage for a certain time period manually. To delete records for a certain time period, click the Delete old records... button, specify the time period and click OK. All records for the specified time period will be deleted from all data schemas after that.
The Drop all tables... button allows you to instantly delete all tables in the data storage and thus completely clear it.
