The Tables in Set Tab
Published 19 March 2018
The Tables In Set tab provides a ready reference to the database tables known to the Masking Set.
In order for the Data Masker software to function, it needs to be aware of the tables in the target database and their structure (column names, column types, column sizes etc). This information is usually automatically acquired when the masking set is created. The database structure can be refreshed using the Refresh Tables 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 database information will probably need to be refreshed again. Use the Refresh Tables 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
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 database - 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.
The Plan Report button launches a form which enables a report of the masking plan state for every table and column to be saved as a disk file in a nicely formatted manner.