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.

Procedure
  1. On the Project tab, in the Configuration group, select Project Settings icon Project Settings.
  2. Select the Databases tab to view the databases settings.
  3. In the Databases group, select Add icon Add.

    The Add New Database window is displayed.

  4. On the Add New Database window, and perform the following steps.
    1. Enter a Database Name.
    2. From the Database Type list, select Associative Search Database.
    3. Select OK.

    The associative search database properties window is displayed.

  5. 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.

  6. 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.

  7. Optional. Select OK to close the Project Settings window.
  8. Save the changes to your project.