Reporting server

The Capture data is stored in a Reporting database. You can configure the time period within which the ETL agent handles the system task (extract/transform/load) and transforms data from staging to warehouse. You can also define how long the data associated with the fields and documents can be stored.

  1. Navigate to System > System settings > Database, retention and reporting > Reporting server.
    The Reporting server dialog box is displayed.
  2. Under Reporting warehouse ETL agent, set the time period to run daily report so that the Reporting server handles the system task (extract/transform/load) for each tenant and transforms data from staging to warehouse. (Default: 0 Hrs 0 Minutes and 23 Hrs and 59 Minutes)

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

    Note You can narrow this transformation 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.

  3. Under Data retention period , set the number of days after which all the data associated with the Fields and Documents is deleted. (Default for fields = 5 days, default for documents = 3650 days (Ten years))
  4. Click Save.