Add an associative search database
Associative Search Databases is deprecated and will be removed in a future release of Tungsten TotalAgility. As a result, Tungsten Automation recommends that you switch to a local fuzzy database or a remote fuzzy database via Tungsten Search and Matching Server.
Use the procedure in this topic to add an associative search database.
-
On the
Project tab, in the
Configuration group, select
Project Settings.
- Select the Databases tab to view the databases settings.
-
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 Associative Search Database.
- Select OK.
The associative search database properties window is displayed.
-
In the associative search database properties window, configure the following settings.
Setting
Description
Import from a semicolon-separated CSV file
Browse to and select a CSV file.
First line contains captions
Select if the first record of the input file contains the column headers. (Default: Selected)
Automatic update from import file
Updates the Associative Search Database when the source file is updated. (Default: Cleared)
If this setting is selected, the database is updated when Transformation Server runs during production.
This automatic update feature is not supported by Azure.
Field Configuration
The table lists the following columns:Field Name, Search, and Filter columns for the selected CSV file. Selecting the Search value for a record includes that field in the search. Selecting the Filter value makes that field available for filtering via script.
Column used as record identifier
Select a column from the list to be used to help identify the records. This column must contain a unique alpha-numeric identifier for each record. The first column of the database is selected by default.
-
Select
OK to save the Associative Search Database.
The properties window is closed and the new Associative Search Database is displayed in the list of databases in the Databases group.
- Optional. Select OK to close the Project Settings window.
- Save the changes to your project.