Kofax Search and Matching Server databases
In addition to the ASE database lookups, Kofax AP Agility Invoice Processing also supports lookups using Kofax Search and Matching Server (KSMS) databases. When Kofax AP Agility is first installed, three KSMS databases are created automatically. By default, these point to the localhost, so their paths need updated to point to the correct KSMS server.
A KSMS database is physically located on a remote Kofax Search and Matching Server server, and no copies or regular updates are needed on the Kofax TotalAgility sever.
Since the database lookups are configured to use the ASE databases by default, it is necessary to do the following:
-
Load the necessary data into the BRWVendorMaster and BRWEmployeeMaster tables, and if necessary, the BRWCompanyAddressMaster table, in the AP Agility database.
-
Open the Transformation Designer and then select the Project Settings > Databases tab.
-
Open the AP_Vendor database, update the Connection String so that it points to your KSMS server, and configure the KSMS AP_Vendor settings.
-
Open the AP_Employee database, update the Connection String so that it points to your KSMS server, and configure the KSMS AP_Employee settings.
-
If needed, open the AP_Company database, update the Connection String so that it points to your KSMS server, and configure the KSMS AP_Company settings.
-
Update the Settings > Invoice Processing > Global Settings > ASE Database Settings to use the KSMS databases instead of the default ASE databases.
-
Release your project.