Database

This section describes how to specify configuration settings for the Database source. You can specify which tables / views / queries will be crawled, or set up table configuration. Also, you can use Write Configuration options to configure tagging.

Configure tagging

Tagging allows you to write classification taxonomy attributes back to the source database.

Each registered taxonomy can be mapped to a property in the database table’s metadata. The program will update a specific column per taxonomy within the source repository with the associated classifications for a record. You can specify how the classifications should be mapped to the table:

  • Which table should be updated
  • Which column should be updated
  • How to filter the table to ensure that at most only one row will be updated (each update statement is verified prior to execution in order to ensure that only one row will be updated).

These settings are configured in the Write Configuration window for the selected entity (table or query).

To configure tagging, do the following:

  1. In the Sources window, select the required source by clicking on the triple cog icon.
  2. Select the entity that you wish to configure tagging for (table or query) and click Edit.
  3. Select Write Configuration on the left.

Configure tagging options listed below:

Option Description
Table Name Specify the name of the table to be updated (in most cases this will be the same as the table being crawled).
Column Name Specify the name of the column to be updated (text/varchar column).
Update Filter

Update filters are the method used to restrict the update at the target destination. If multiple filters are configured then they all must be true.

Filters should be created in the format:

ColumnName=@Parameter

where @Parameter is a correctly configured metadata value from the source table/query.

The specified values will result in a query in the following format:

UPDATE TABLENAME SET COLUMNNAME=@Classifications WHERE FILTERS

Other Database Configuration settings

You can also specify the following settings: