For a selected database you can configure the following settings:

Database source

The location of the database source file is displayed. For a newly-added database no path and file information can be displayed as you have to configure the settings first by selecting Import Settings.

Database type

Depending on the type chosen to create the Fuzzy Database from either Text file (URL/UNC path), Text file (uploaded) or Relational database (SQL, Oracle, or ODBC) is displayed.

Database status

The following values are available for a selected database.

Created

This status is displayed for a newly added database for which the fuzzy database is not yet created.

Important A newly created database is kept in memory only, until the fuzzy database is created. That means that if the stand-alone Search and Matching Server or Load Balancer is stopped all database having the database status Created are no longer available.

Error

Is displayed when an error occurred, for example during the database import, and the database is not ready for use. To fix an error you need to check the import settings and import the database again.

Importing

Is displayed while the database is imported according to the configured import settings.

Loading

Is displayed while a database is updated by the automatic update.

Ready

Is displayed when a fuzzy database was created, imported and is now ready to use.

Unloading

Is displayed when a database is unloaded from the memory.

Total records

After a database is imported the number of imported records of the fuzzy index is displayed.

The following buttons are available:

Import Settings

Click this button in order to define the import settings for a text file or a relational database, such as the database source file, the columns that are used to build the fuzzy index, and other import options and string substitutions.

General Settings

Click this button in order to define the general settings for the automatic update and other load options.

Cancel Import

Click this button in order to stop the process of importing a fuzzy database. After the import has succeeded or was terminated the button is no longer available on the Database Settings tab.