Configure Automatic Database Update
For databases that are updated regularly you can define an hourly, daily or weekly update. On the configured update time the Kofax Search and Matching Server checks whether the source file has changed and if so, starts the upload using the configured import settings to create an updated fuzzy database.
All search requests that are sent while the database is being updated are performed on the "old" database. As soon as the update is complete search requests are then performed on the updated database.
You can define the settings for an automatic database update on the General Settings window for databases that are imported from relational databases or delimited text files that have an URL/UNC location. This is because the Kofax Search and Matching Server must have access rights to automatically upload and re-import the database. For fuzzy databases that are imported from a manually uploaded delimited text file that automatic update options are not available.
For a Microsoft SQL Server or an Oracle database you can select a stored procedure that returns a date and time when the database source was last changed. The update is performed only when the change date is newer than the date for last update. If no stored procedure is selected, the system checks if the database source has changed and performs the update only if it has changed or if the check for changes did not return a result.
You can configure automatic database updates by following these steps:
- Select a database from the list of Available Databases.
- From the Database Settings tab, click General Settings.
- Optionally, you can select a stored procedure for a Microsoft SQL Server and an Oracle database that starts the update only if the database has changed.
- Select Use automatic update and select the days (if weekly is selected) and the hour(s), when the upload is performed.
- Click OK to save the settings.