Add a remote fuzzy database
Use the procedure in this topic to add a remove fuzzy database.
To set up a Remote Fuzzy Database you need to have access to the Tungsten Search and Matching Server. The database you want to connect to must be configured and set to activated prior to this setup.
-
On the
Project tab, in the
Configuration group, select
Project Settings.
- Select the Databases tab.
-
In the
Databases group, select
Add.
The Add New Database window is displayed.
-
On the
Add New Database window, and perform the following steps.
- Enter a Database Name.
- From the Database Type list, select Local Fuzzy Database.
- Select OK.
The local fuzzy database properties window is displayed.
-
In the local fuzzy database properties window, configure the following settings.
Setting
Description
Host name
Enter the host name where the Tungsten Search and Matching Server is installed. The Tungsten 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 standard Search and Matching Server is set to 2200 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.
This setting is read-only. This is because this settings is configured in the Tungsten Search and Matching Server and imported here.
Connect / Disconnect
Select the button to establish the connection to the Tungsten Search and Matching Server. When the connection is established, a list of available databases is provided.
To disconnect, select the button again.
Credentials
Select to open the Credential Settings window and configure the following settings:
- Use Windows authentication:
-
Clear this setting to provide credentials for the user account that should be used for authentication when performing a search during production. (Default: Selected)
- Credentials:
-
This group has the following settings:
These settings are available only when the Use Windows authentication is cleared.
- User:
-
Enter the user that will be used to perform a search.
- Password:
-
Enter the password for the user that will be used to perform a search.
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. The following settings are available:
- Database Hosts:
-
This group lists the primarily configured Remote Fuzzy Database as well as additional hosts. The following table columns are available:
- Host name:
-
Enter the name by of the computer that runs a stand-alone Tungsten Search and Matching Server or a Load Balancer that manages a cluster of several Tungsten Search and Matching Servers. Alternatively, you can enter the IP address, or if the Tungsten Search and Matching Server or Load Balancer is installed on your local computer enter "localhost." You can search for all available servers and load balancers within your local network by selecting the Database search button. Select the Down Arrow to select a server from the list.
- 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.
- Type:
-
Select from one of the following processing types for the added database host:
- All:
-
Uses the database host for any requests that are performed during Transformation Server processing as well as for any database searches that are requested by a Validation module.
- Extraction:
-
Uses the database host for requests that are performed by Transformation Server, but not for requests from the Validation module.
- Validation:
-
Uses the database host for requests that are performed by the Validation module, but not for requests from Transformation Server module.
Use the Add, Remove,
Search, and
Test buttons to manage settings for the database hosts.
Ignore case during import and search
If selected all search and lookup strings are changed to lower case so the case is ignored. (Default: Selected)
Word separation characters
If fields in the database contain compound words, common characters can be specified so each part of the compound word is searched and evaluated separately. (Default: -, (space, hyphen, comma))
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.
The separation characters must correspond to the delimiter characters that are defined for OCR.
- Tab:
-
Uses a Tab as a word separation character in addition to the characters specified in the Word separation characters setting.
- Space:
-
Uses a Space as a word separation character in addition to the characters specified in the Word separation characters setting.
Characters to ignore
Enter 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. (Default: ."'! (period, quotation mark, single quotation mark, and an exclamation point))
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.
- Space:
-
Ignores a Space character in addition to the characters specified in the Characters to ignore setting.
String Substitution
This group and all of its settings are read-only. This is because these settings are configured in the Tungsten 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.
Field Names
This group and all of its settings are read-only. This is because these settings are configured in the Tungsten 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 Tungsten 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 Tungsten 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.
-
Select
OK to save the remote fuzzy database.
The new database is displayed in the list of databases.
- Optional. Select OK to close the Project Settings window.
- Save the changes to your project.