› Use Transformation Designer › Manage databases › Associative search databases › Add an associative search database

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 Project Settings icon.
  2. Select the Databases tab to view the databases settings.
  3. In the Databases group, select Add. The Add New Database window is displayed.
  4. In the Database Name field, enter a descriptive name for the new fuzzy database.
  5. On the Database Type list, select the Associative Search Database type.
  6. Select OK. The Properties of Associative Search Database window is displayed.
  7. Select a CSV file by browsing to its location.

    The Column name and Search details are loaded into the Column Configuration table.

  8. Optional. Select the First line contains captions if the first line of your chosen CSV file is a column header.
  9. Optional. If your chosen CSV file is updated regularly, select the Automatic update from import file setting.
  10. Update the Column Configuration table as needed. Clear the Search column for any fields that you do not want to include in your search.
  11. In the Column used as record identifier list, select which database column to use as the record identifier.
  12. 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.

  13. Optional. Select OK to close the Project Settings window.
  14. Save the changes to your project.