Set Up a Fuzzy Database

In order to set up a fuzzy database you add a new fuzzy database, configure the import settings and if wanted, configure the general settings.

  1. To add a new fuzzy database to the list of available databases click Add and perform the following steps when the Add New Database window is displayed:

    The new fuzzy database is added to the list of Available Databases and its database status is set to Created.

    1. Type the database name.
    2. Select the database source either Text file if the database source is a delimited text file or Relational database if the database source is a Microsoft SQL Server, an Oracle database or an ODBC file.
    3. Click OK to save the settings.
  2. Configure the newly created fuzzy database by clicking Import Settings from the Database Settings tab. For a text file database source the Import Settings - Text File window is displayed and for a relational database source the Import Settings - Relational Database window is displayed, in order to define the options for the path or connection string, the columns and if needed, string substitutions.

    On the Database Settings tab the details for the newly created database are updated and a preview of the first 20 records of the imported database are displayed.

  3. Optionally, click General Settings from the Database Settings tab to display the General Settings window in order to define load options, automatic update and the error management.
  4. Click Activate to enable the newly-created database for access from Kofax Transformation Modules.