Skip to main content
The Reporting service can export some of its data so that statistics are available to users who have no access to the reporting database itself.
Install the optional Reporting Service data access component when you install the Reporting Service. For more information, see System requirements and installation.

When to use data access

Data access is useful in two situations:
  • Your configuration has multiple tenants, and you want each tenant to retrieve only its own statistics.
  • You work with FlexiCapture Cloud, which does not allow access to the reporting database.

How Reporting Service data access works

The service regularly exports the reporting data into CSV tables, organized into a zip archive for each day. Set the time between exports in the RunTenantsDataGenerationPeriodSec value in the appsettings.json file. If you do not change this setting, the service exports new data every 4 hours. An export can run several times during a day, so the data archive for the current day keeps changing. For regular analysis, use the data for days that have already ended, meaning the previous day or older. Starting from FlexiCapture 12 Release 4 Update 2, the service collects data in the Reporting Service database using the Worker Service, which is part of the Reading Service.

Ways to collect the data

Retrieve the reporting data from the archives and pass it to the business analytics tool you use. Use one of the following ways: The archives you download through the REST API are the same ones you copy from the local folder. Choose the method that integrates best into your solution.