Scripts for creating database tables
The SQL scripts for creating and dropping tables in your database are located in the documentation\sql directory in your Kofax RPA installation directory. For example, C:\Program Files (x86)\Kofax RPA 11.1.0 x32\documentation\sql on the Windows system. The name of the script file includes the name of the database the script is intended for.
The sql directory contains four subdirectories with different scripts as follows:
- altosoftsession: Scripts for creating and dropping tables for a single sign on with Altosoft.
- logdb: Scripts for creating and dropping logdb tables.
- mc: Scripts for creating and dropping Management Console tables.
- statistics: Scripts for creating and dropping statistics tables required for producing reports in Kofax Analytics for RPA.
Management Console uses a third party scheduling component called Quartz. Quartz also requires a number of tables that must reside among the other platform tables. These tables are also created automatically when Management Console starts, or may be created manually using the scripts.
The following is a Quartz verification script.
|