Use this window to configure the import settings for a Fuzzy Database that is created from a relational database, either from a Microsoft SQL Server, Microsoft Access, MySQL or Oracle database.

Connection Type

This option has the following values. Select one to value to select the connection type:

• Microsoft SQL Server.

  Configures a Microsoft SQL Server connection.

• ODBC.

  Configures another type of database using an open database connection, such as Microsoft Access.

• Oracle.

  Configures an Oracle database connection.

Connection String

This group has the following options:

Connection String

A connection string contains a server name and database, or a DSN (Data Source Name). It can also contain authentication details required to connect to a database. Click Configure to set up the connection for a Microsoft SQL Server, ODBC or Oracle connection type.

Note All password information is fully encrypted.

Configure

Click this button to set up the connection string for the selected connection type. Only for a valid connection string the connection is established and the list of available tables, views or stored procedures is displayed.

Table, View, Synonym or Stored Procedure

Once the connection string is configured and successfully tested, a list of available tables, views and synonyms is provided. For Microsoft SQL Server and Oracle databases, stored procedures are displayed. Select a table, view, synonym or stored procedure from a list. The selection is used to create the Fuzzy Database that updates the data in the Table Records Preview table below.

Refresh

Click this button to populate the Table, View or Stored Procedure list.

Import Options

This group has the following options:

Ignore Case

Select this option to convert all search and lookup strings to lower case, effectively ignoring case.This option is selected by default.

Database active at start

Select this option for a newly-configured database so that the database is activated automatically after the import. Note that this option is displayed for new databases only and is hidden the next time you open the Import Settings window.

Word separation characters

If fields in the database contain compound words, common characters can be specified so that each part of the compound word is searched and evaluated separately. The value for this option is set to" -," (space, hyphen, comma) by default.

For example, using the default settings, the compound word "Diagon-Alley," is treated as two words, "diagon" and "alley" that are searched and evaluated separately.

Note The separation characters must correspond to the delimiter characters that are defined for OCR.

Characters to ignore

Type a list of characters into this field to filter unwanted characters from the input record. When you want to use a field delimiter that may also be a character in the input, such as a comma (,), then you have to use quotes (") to identify the input strings. However, you probably do not want to retain those quotation marks as part of the final results.

If you define the quotes as characters to ignore, they are removed. To define a tab or space as characters to ignore, select the corresponding check box.The value for this option is set to ."'! (period, quotation mark, single quotation mark, and an exclamation point) by default.

You can use the following buttons to manage String Substitutions that are used to substitute Search Text with Replacement Text in the document and in the database:

Add

Click Add to add a new string substitution pair to the list of substitutions.

Delete

Click Delete to delete the selected item in the substitution list.

Modify

Click Modify to modify the selected item in the substitution list with the values from the two edit fields.

Import

Click Import to import a file that contains a list of string substitutions. For the import you can either add the string substitutions to your current list of substitutions or replace them by the imported list. You can import string substitutions that are exported from a Kofax Search and Matching Server database as well as from a Kofax Transformation - Project Builder database.

Export

Click Export to export your string substitution pairs to a text file. You can then import the string substitutions to be used for other Kofax Search and Matching Server or Project Builder databases.

The Table Records Preview area provides a read-only preview of the first 20 records of the referenced table. Note that columns that are not selected for use are grayed out.

In addition to the common buttons, the following button is provided at the bottom of the window:

Import Database

Creates the Fuzzy Database for a relational database according to the defined import settings.