TDM Studio Masking Wizard - Masking

On the Masking page of the Wizard, you can configure the masking options that you want to apply to your database.

Table options

You can set the following options for tables:

Element	Description
Select tables	Select the database tables you want to set conditions for. The Wizard marks tables suggested for masking with a light bulb icon.
Select all	Select this option to select all tables of the chosen database.
Show only suggested	Check this option to display only the tables suggested for masking.

Column options

You can set the following options for columns:

Element	Description
Select columns	Select the columns you want to set conditions for. The Wizard marks columns suggested for masking with a light bulb icon.
Select all	Select this option to select all tables of the chosen database.
Show only suggested	Check this option to display only the columns suggested for masking.
Preview data	Select this option to display a preview of the column's contents.
Enforce consistency	Select this option to enforce consistent masking.

Masking options

You can set the following masking options for specified tables and columns:

Element	Description
Specify new value	Specifies a new value.
Select masking rule	Select the masking rule you want to apply from the drop-down menu. Additionally, you can select and apply masking algorithms from this drop-down menu.
Pool ID	Set the unique ID of the data pool.
Column	Set the column that you want to mask.
SelectQuery	Enter a SELECT statement.
Maxlen	Set the maximum length for masking values.

Apply masking values from other tables and columns

To apply masking algorithm values using other columns of your currently selected database table, or using columns from a different table, follow the steps below:

1. In Select tables, select the database table whose columns you want to mask.

2. In Select columns, select the column whose values you want to mask.

3. In Masking options, select the following settings:

   • Select VALUE from the Specify new value drop-down menu.

   • Enter the following expression into the New value field:

     Dynamic(#Link("<namespace>.<table>", "<column>")#)

     Where namespace is the name of the namespace where the table is located, <table> is the name of the table and <column> is the name of the column where to get the value from.

Apply dynamic values for masking via Test Data Language expressions

You can apply masking algorithm values using dynamic values via Test Data Language (TDL) expressions. To do so, follow the steps below:

1. In Select tables, check the database table whose columns you want to apply masking to.

2. In Select columns, check the column whose values you want to mask.

3. In Masking options, edit the following settings:

   • Select VALUE from the Specify new value drop-down menu.

   • Enter the following expression into the New value field:

     Dynamic(#<expression>#)

     Where <expression> is the TDL expression that you want to execute.

Select a data pool for masking

You can select a data pool for masking algorithm values using via Test Data Language (TDL) expressions. To do so, follow the steps below:

1. In Select tables, check the database table whose columns you want to apply masking to.

2. In Select columns, check the column whose values you want to mask.

3. In Masking options, edit the following settings:

   • Enter a unique Pool ID for the data pool you want to use.

   • Specify the Column of the data pool you want to use.

   • Enter a select statement into the SelectQuery field, for example:

     SELECT Street_Name FROM view_location

     Where Street_Name is the name of the Column.

Migrate alienation functions and suggestions

You can migrate the deprecated alienation functions from the TDM Wizard for Databases. The Masking Wizard maps the algorithms to the new masking algorithms and masking functions.

You can check and modify the updated suggestions by editing the masking.config file. By default, this files is located at C:\Users\<username>\AppData\Roaming\TRICENTIS\TDMStudio\<TDM Studio version>\.

For example:

<column mask="^mail$">EMAIL</column>
<column mask="^e-?mail$">EMAIL</column>
<column mask="^vorname$">POOL:COLUMN=Forename,TABLE=forenames</column>

• mask="^vorname$" is a regular expression for locating a column.

• POOL:COLUMN=Forename,TABLE=forenames specifies an algorithm and the attendant configuration field.

Apply masking suggestions

If you have migrated or created suggestions as described above, you can apply them in the Masking Wizard. The Wizard offers suggestions based on the available content of the masking.config file, and you can click Apply suggestion to use a specific offered suggestion.