Properties of Remote Fuzzy Database window
Use this window to select a fuzzy database that is located at a remote site. For example, you can use a remote fuzzy database for a Database Locator or for a Fuzzy Database Search in Validation. The setup and configuration of the fuzzy database at a remote site is done via the Search and Matching Server Administration and accessing the fuzzy database by configuring the following options.
- Server Settings
-
This group has the following options:
- Host name
-
Type the host name where the Search and Matching Server is installed. The Search and Matching Server can only be installed on a 64-bit operating system and manages the remote fuzzy databases.
- Port
-
If needed, change the port number that is used for communication with the Search and Matching Server. By default, the port number for a stand-alone Search and Matching Server is set to 22000 and the default port number for a Load Balancer is set to 22001. The Port value must correspond to the configured value for the server or load balancer.
- Database name
-
Select a database from the list of available databases.
Important This option is read-only. This is because this settings is configured in the Search and Matching Server and imported here.
- Import Options
-
Important This group and all of its options are read-only. This is because these settings are configured in the Search and Matching Server and imported here.
This group has the following options:
- Ignore case during import and search
-
If selected all search and lookup strings are changed to lower case so that the case is ignored. This option is selected by default.
- 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
andalley
that are searched and evaluated separately.Note The separation characters must correspond to the delimiter characters that are defined for OCR.- Tab
-
Select this checkbox if you want to use a Tab as a word separation character in addition to the characters specified in the Word separation characters setting.
- Space
-
Select this checkbox if you want to use a Space as a word separation character in addition to the characters specified in the Word separation characters setting.
- 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.
- Space
-
Select this checkbox if you want to ignore a Space character in addition to the characters specified in the Characters to ignore setting.
- String Substitution
-
Important This group and all of its options are read-only. This is because these settings are configured in the Search and Matching Server and imported here.
The string substitution table substitutes Search Text with Replacement Text in the document and in the database. It is used to normalize the results of the text search.
-
This group has the following options:
The string substitution table substitutes Search Text with Replacement Text in the document and in the database. It is used to normalize the results of the text search.
If you use the same dictionary in more than one project, you can create a list of string substitutions and export them to use in the other project.
You can use the following buttons to manage string substitutions:
- Field Names
-
Important This group and all of its options are read-only. This is because these settings are configured in the Search and Matching Server and imported here.
This group provides a preview of the first 20 lines of the referenced file according to the settings.
When Kofax Search and Matching Server is used for a remote fuzzy database, you can use filtering via a script. The columns that you need for filtering must be selected in Kofax Search and Matching Server at import time.
The heading and the font of the columns indicates the behavior of that column. The following column behaviors are possible:
-
Column header name bolded and highlighted in green.
This indicates that this column is used for filtering.
-
Column header name and individual records are disabled, italic, and the header is not highlighted.
This indicates that this column is not used for the fuzzy match.
-
Column header name and individual records are disabled, italic, and the header is highlighted in green.
This indicates that this column is not used for the fuzzy match but the column is used for filtering.
-
In addition to the common Transformation Designer buttons, the following buttons are provided:
- Connect / Disconnect
-
Click the button to establish the connection to the Search and Matching Server. When the connection is established, a list of available databases is provided.
To disconnect, click the button again.
- Credentials
-
Click the button to open the Credential Settings window and to supply user credentials to connect to a remove fuzzy database if needed.
- Advanced
-
Displays the Advanced Properties window of a selected Remote Fuzzy Database in order to configure additional database hosts to optimize the resource utilization and increase reliability.