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 theappsettings.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:- Local folder export – Access the archives directly in a local folder.
- REST API data access – Send REST API requests. This option is also available to FlexiCapture Cloud users.
