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.
-
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.
- Type the database name.
- 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.
- Click OK to save the settings.
-
Configure the newly created fuzzy database by clicking
Import Settings from the
Database Settings tab. For a text file database source the
Import Settings for Database
(Text File Source) window is displayed and for a relational database source the
Import Settings for Database
(Relational Database Source) 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.
- 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.
- Click Activate to make the newly-created database accessible.