Configuring the ABBYY FlexiCapture 12 Reporting Service
Configuring the ABBYY FlexiCapture 12 Reporting Service
The service will store all information in a separate database. Therefore, once the installation process is completed, you need to create a database where data about document processing will be stored. To do this, follow these steps:
- On the computer where the ABBYY FlexiCapture 12 Reporting Service is installed, launch PowerShell with administrator privileges.
- Navigate to the CreateDb folder located in the directory where the service has been installed. You can also use this command if the service has been installed to the default path:
cd C:\inetpub\wwwroot\FlexiCapture12Reporting\CreateDb - Launch the CreateEventLogDb.ps1 script with the required parameters. For example,
CreateEventLogDb.ps1 HostName\SQLInstanceName DATABASENAME user password
The parameters in this script should be replaced with the name for the database you are creating and your own credentials.
Important! User and Password are optional parameters to be used only in the case of Microsoft SQL authentication. If no User or Password is specified when launching the script, the program will use the Windows account under which the Reporting Service is running. Please make sure that this Windows account has access permissions for the Reporting Service database. - Add the key below to the AppSettings section of the Administration and Monitoring Console web.config file:
<add key="ExternalLogServiceSettingEnabled" value="true" />
Save your changes. - Open the Administration and Monitoring Console and navigate to Settings → Event Logging Mode. In the ABBYY FlexiCapture 12 Reporting Service field, specify the address of the Reporting Service in the following format: http://<ServiceAddress>:8001.
Note: Please make sure that port 8001 is not used by any other application. - In Internet Information Services (IIS), recycle the “FlexiCapture 12 Reporting” Application Server pool.
After you complete the steps above, the program will record document processing data for the default tenant into the DocumentEditingStatistic and EventLog tables in the database.
Configuring Reporting Service data access
Once the Reporting Service is ready, configure the data access component if you chose to install and use this component:
- Go to the directory where the data access component was installed. The default directory is C:\inetpub\wwwroot\FlexiCapture12ReportingDataAccess.
- Open the appsettings.json file and specify the following settings:
- DecryptionKey from the application server web.config. Its settings are found at C:\inetpub\wwwroot\FlexiCapture12\Server by default.
- ValidationKey from the application server web.config.
- ConnectionString to connect to the reporting database. It can be found in appsettings.json for the Reporting Service (the default path is C:\inetpub\wwwroot\FlexiCapture12Reporting).
- ReportingDataPath — the path to the folder where the data should be exported. If there are multiple tenants, each tenant's data will be stored in a separate subfolder.
- RunTenantsDataGenerationPeriodSec — the time that should elapse between automatic exports of new reporting data, in seconds. The default value is 14400, which equals 4 hours.
Note: The ValidationKey, ConnectionString, RunTenantsDataGenerationPeriodSec, and ReportingDataPath parameters are not included in the appsettings.json file that is installed together with the data access component. You will need to add these parameters manually after the DecryptionKey parameter, separating them with a comma.
- Restart the ABBYY FlexiCapture ReportingResults web service in IIS.
- Restart the ABBYY FlexiCapture ReportingResults Service in Services.
After you complete the steps above, the program will automatically export reporting data into the folder specified in appsettings.json. Please note that in the case of automatic data export, the Reporting Service will export reporting data accumulated in the previous day. This means that the first export of reporting data will occur one day after you install and configure the Reporting Service. You can also export reporting data manually at any time using the API (see REST API data access for detailed instructions).
Changing the database used by the ABBYY FlexiCapture 12 Reporting Service
To change the database used by the Reporting Service, you need to modify the appsettings.json file. This can be done manually, or, in ABBYY FlexiCapture 12 Release 4 Update 2 and later, using the EventLogApiCreateDb.exe utility combined with the ConnectEventlogDb.ps1 script.
You can switch either to an existing database that already contains some data or to a new empty database. If you switch to a new empty database, the EventLogApiCreateDb.exe utility will initialize the database first.
Step-by-step instructions are provided below.
- To change the database manually:
- On the computer where the ABBYY FlexiCapture 12 Reporting Service is installed, launch PowerShell with administrator privileges.
- Open the appsettings.json file, which can be found at C:\inetpub\wwwroot\FlexiCapture12Reporting, and make the necessary modifications.
- To change the database using the EventLogApiCreateDb.exe utility:
- Run the appropriate utility command:
- To initialize a new empty database:
EventLogApiCreateDb.exe [ServerName] [NewDatabaseName] [User Password] init - To connect to an existing database already containing data:
EventLogApiCreateDb.exe [ServerName] [NewDatabaseName] [User Password] connect
The utility will open the connection string from the appsettings.json file.
- Run the ConnectEventlogDb.ps1 script to modify the connection string in the appsettings.json file. The general mask for the script is as follows:
ConnectEventlogDb.ps1 ServerName OtherDatabaseName [User Password]
As a security precaution, the password in appsettings.json will be encrypted. The ConnectEventlogDb.ps1 script will then restart the Reporting Service.
Enabling the Reporting Service for a non-default tenant
By default, the Reporting Service will only run on the default tenant. To enable the Reporting Service for a non-default tenant set the first bit to the appropriate tenant in the Flags field in the dbo.Tenant table.
Now the program will record document processing data for the specifed non-default tenant into the DocumentEditingStatistic and EventLog tables in the database.
4/12/2024 6:16:02 PM