Once you have set up the requisite databases, tables and functions, you need to point the automation VIP workflows to the databases and schema that they will execute actions against. The Configuration Tab is used to define the connection details that will be used by the automated Data Mask actions:

  • Open the Control Spreadsheet – VIPMaskSQLServer.xlsx . This is contained in C:\VIPTDM\SubsetCloneAndMaskRun\Mask\SQLServer\VIPMaskSQLServer.xlsx.

  • Select the Configuration Tab

  • IMPORTANT STEP: In the Database Connection row, add the Database Connection details for the database you want to use.

  • Name the database and schema you wish to mask in the Staging Database and Staging Schema rows

Initially the control spreadsheet should contain the following sheets:


This sheet can be used to provide details of foreign key relationships which are not enforced by foreign key constraints in the database


This sheet specifies the column datatypes which the SCANCOLUMNS action (see below, Run SCANCOLUMNS action) will process

MaskingFunctions (User-defined functions)

This sheet provides the names of the user-defined functions available for masking. Note that if these functions are not defined in [Masking].[dbo] you should edit [Masking].[dbo] to your chosen [DB].schemas.

NOTE: Be sure to close this Control spreadsheet before going further in Masking as the next steps will need to update the Control spreadsheet which cannot happen if it is open.

This step only needs to be run one time.