In order for the Data Masker software to function, it needs to be aware of the tables in the target schema and their structure (column names, column types, column sizes etc). This information is usually automatically acquired when the masking set is created. The schema structure can be refreshed using the Refresh Schema and Indexes button on Options tab of the edit Rule Controller form.

The Data Masker Set Tables Tab

The panel on the top of the Tables In Set Tab shows the tables in the Masking Set. Beside each table is a column indicating the number of rows in the table. Each table can expand to show the column structure of the table.

If the required table is not present in the list, then the schema information will probably need to be refreshed again. Use the Refresh Schema and Indexes button on Options tab of the edit Rule Controller form to reload this information.

Note:A right mouse button click on any table name will cause a small menu to appear offering the option to see the columns, foreign keys and indexes for a particular table.

What the Buttons do

Create Pseudo Table

Sometimes it is necessary to add table definitions manually (instead of refreshing from the schema) or to create a dummy table which actually represents a database link. The Create Pseudo Table button will launch a form which provides this functionality. See the help file for the Create Pseudo Table form for more information.

Bulk Remove Table

The Bulk Remove Table button launches a form which offers the option to select and remove tables. If the table has masking rules applied to it these rules will also be dropped. Note that removing a table in the Data Masker software has no affect on the table in the target schema - it just means that the Data Masker application no longer knows about it. It is also possible to remove individual tables by right clicking on them with the mouse and choosing the Remove Table option.