The Tables tab
Published 06 January 2020
The Tables tab provides a ready reference to the schema entities such as tables, column indexes foreign key and triggers.
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.
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 to reload this information.
When you're planning the masking, it can be particularly useful to have a view of whether each column contains sensitive information. By default, their sensitivity is set to unknown. But it can be changed to three other values 'Sensitive', 'Nonsensitive' and 'Check'. 'Sensitive' means the column contains sensitive information. 'Nonsensitive' means the column doesn't contain sensitive information hence no need to be masked. 'Check' means the sensitivity information needs to be checked later. Columns that are marked sensitive or check but no rules have been configured to target it will be highlighted with bold font face to indicate further actions are needed for that column.
The sensitivity information can be modified in the 'Sensitivity' grid column. The table tab also provides several other mechanisms to help view and modify this information efficiently, including bulk changing sensitivity (context menu at tables or columns) and creating substitution rule for all sensitive columns (context menu at tables).
The information about the tables in the masking set is displayed in a grid. The grid header allows further customization of the view of this information. Left-clicking the grid header changes the sorting. Dragging and dropping grid columns can rearrange the order of the grid columns. Dropping it outside the grid header area can remove the grid columns from the view. Right-clicking on any grid header will cause a context menu to appear. The 'Column Chooser' menu item allows you to add back removed grid columns as well as other non-used grid columns. The 'Show Find Panel' menu item allows you to search for information by text.
Grid header context menu
Context menu for tables
Right-clicking on any table will cause a context menu to appear.
Context menu for tables
Show Table Data
Launches Data Viewer tool to display data for the selected table.
Show Schema Information
Launches forms to show various different schema information, including columns, indexes, foreign keys, and triggers.
Refresh Table Information
Downloads and refreshes the table schema data from the connected database.
Exclude Table from Controller
Excludes the selected table from the tables tab and rule editors. The excluded tables can be added back through the Refresh Tables and Indexes button on Options tab of the Rule Controller.
Configure the sensitivity for all columns in the table.
Create Substitution Rule for 'Sensitive' Columns
Launches substitution rule builder that include all sensitive columns in the table.
Show Rules Targeting this Table
Launches a form to show all rules that target the selected table.
Launch a form to show diagnostics information for the table.
Context menu for columns
Right-clicking on any column will cause a context menu to appear.
Context menu for column
Add different types of rules that target this column.
Configure the sensitivity for the selected columns. Note that the columns can be multi-selected and configured at once.
Show Rules Targeting this Column
Launches a form to show all rules that target the selected column.
Find Identically Named Columns
Launch the column finder tool to find all columns of the same name with the selected column.
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 effect 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 Export/Import Plan button launches a form which offers the ability to import/export the masking plan information, in XML or CSV format, or to reset the masking plan information.
For the CSV file, the following columns are required (they can be in any order and other columns are ignored):
- ColumnName - optional - if not specified the Comments are applied to the table rather than a column and sensitivity is ignored
- Sensitivity - this can be one of Unknown, Nonsensitive, Sensitive, NeedsReview
- Comments - an optional explanation of why this column/table has been judged to be sensitive or not.
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.