› System › System settings › Database, retention and reporting › Reporting server

Reporting server

The Capture data is stored in a Reporting database. You can define how this data should be handled.

Enable the reporting feature
By default, enables sending the information for the Reporting component and processing of the Reporting messages. Clearing the check box will disable all the reporting server settings and also prompts you to confirm deleting unprocessed reporting data from the staging database. On confirmation and saving, all the reporting staging data will be deleted and cannot be recovered.
Reporting warehouse ETL agent

The period within which the Reporting service performs the Transform and Load steps of the whole Extract/Transform/Load process.

(Default: 0 Hrs 0 Mins and 23 Hrs and 59 Mins)

For on-premise multi-tenancy and Azure environments, the system tasks are created per tenant basis with a one-minute interval between the tasks for one tenant. Each task is handled separately and appropriate pairs of staging/warehouse databases are processed with one pair per system task.

  • You can narrow processing of the Warehouse only DB with this setting to nightly hours of the tenant to improve availability of Warehouse database for customers.

  • The "Reporting warehouse ETL agent" setting is configured once per TotalAgility installation for an on-premise environment, and per tenant for on-premise multi-tenancy and Azure environments.

Data retention period

The period for which the data associated with the fields and documents can be stored.

The period for which the data associated with the fields and documents can be stored. (The default data retention period for fields is 5 days and for documents is 3650 days (ten years).)