When you choose a relational table as a dictionary, configure the database table that contains the dictionary. When you define the table, the Designer connects to the table and displays the columns in the table.
To select a database, click Select Table on the Data Masking transformation Masking Properties tab.
Configure the following fields in the Select Table dialog box:
ODBC data source
. ODBC data source that connects to the database that contains the dictionary.
. A database user name to connect to the database. The user name must have the database permissions to view the tables.
If the user name is not the owner of the dictionary table, enter the table owner.
. The password for the database user name.
Search for tables named
. Optional. Limits the number of tables that appear in the dialog box.
When you click Connect, the Designer connects to the data source and displays the tables. Scroll through the list of tables and select the table you want to use for the dictionary. The table name appears in the Dictionary Name field of the Masking Properties tab.