Create the reporting database
1
Launch PowerShell as an administrator
Work on the computer where the ABBYY FlexiCapture 12 Reporting Service is installed.
2
Go to the CreateDb folder
The folder sits in the directory where the service is installed. If the service is installed to the default path, use this command:
3
Run the CreateEventLogDb.ps1 script
Replace the parameters with the name of the database you are creating and your own credentials.
user and password are optional and apply only to Microsoft SQL authentication. If you omit them, the program uses the Windows account that the Reporting Service runs under. Make sure that account has access permissions for the Reporting Service database.4
Add the settings key to web.config
Add the following key to the AppSettings section of the Administration and Monitoring Console
web.config file, and then save your changes.5
Specify the service address
Open the Administration and Monitoring Console and go to Settings > Event Logging Mode. In the ABBYY FlexiCapture 12 Reporting Service field, enter the address of the Reporting Service in the format
http://<ServiceAddress>:8001.Make sure that port 8001 is not used by another application.6
Recycle the application pool
In Internet Information Services (IIS), recycle the FlexiCapture 12 Reporting Application Server pool.
Configure Reporting Service data access
Configure the data access component after the Reporting Service is ready, if you chose to install this component.1
Open appsettings.json
Go to the directory where the data access component was installed. The default directory is
C:\inetpub\wwwroot\FlexiCapture12ReportingDataAccess.2
Specify the settings
Set the following parameters in
appsettings.json.The
appsettings.json file installed with the data access component contains only DecryptionKey. Add ValidationKey, ConnectionString, RunTenantsDataGenerationPeriodSec, and ReportingDataPath manually after it, separating them with commas.3
Restart the services
Restart the ABBYY FlexiCapture ReportingResults web service in IIS, and then restart the ABBYY FlexiCapture ReportingResults Service in Services.
appsettings.json.
An automatic export covers the reporting data accumulated on the previous day, so the first export runs one day after you install and configure the Reporting Service. To export reporting data at any time, use the API. For more information, see REST API data access.
Change the database used by the Reporting Service
To change the database that the Reporting Service uses, modify theappsettings.json file. Do this manually, or, in ABBYY FlexiCapture 12 Release 4 Update 2 and later, use the EventLogApiCreateDb.exe utility together with the ConnectEventlogDb.ps1 script.
You can switch to an existing database that already contains data, or to a new empty database. If you switch to a new empty database, the EventLogApiCreateDb.exe utility initializes it first.
Change the database manually
1
Launch PowerShell as an administrator
Work on the computer where the ABBYY FlexiCapture 12 Reporting Service is installed.
2
Edit appsettings.json
The file is at
C:\inetpub\wwwroot\FlexiCapture12Reporting. Make the necessary modifications.Change the database with the EventLogApiCreateDb.exe utility
1
Run the utility command
To initialize a new empty database:To connect to an existing database that already contains data:The utility opens the connection string from the
appsettings.json file.2
Run the ConnectEventlogDb.ps1 script
The script modifies the connection string in As a security precaution, the password in
appsettings.json. Use the following mask:appsettings.json is encrypted. The script then restarts the Reporting Service.Enable the Reporting Service for a non-default tenant
By default, the Reporting Service runs only on the default tenant. To enable it for another tenant, set the first bit for that tenant in the Flags field of thedbo.Tenant table. The program then records document processing data for that tenant into the DocumentEditingStatistic and EventLog tables in the database.