Once you have completed Data Masking Configuration and Initial Steps , you are ready to run the automated actions used in a standard masking job. The process runs as follows:

  • Run GETMETADATA action

  • Run SCANCOLUMNS action

  • Manually populate the MaskingRules sheet

  • Run MASK action

GETMETADATA, SCANCOLUMNS and MASK are executed using The VIP Server Controller. They can also be run via the Command Line, as set out in its own subsection of the Knowledge Base. Using the VIP Server Controller is the recommended approach and is documented in Data Masking using Command Line .

This section provides an overview of using The VIP Server Controller. It then provides articles for configuring and running GETMETADATA, SCANCOLUMNS and MASK, as well as for populating the MaskingRules Sheet.

Overview of Masking Actions Using The VIP Server

Using the VIP Server Controller is the recommended approach to running Masking Actions iteratively, before exposing the completed Mask to the shared server and web portal.

The VIP Server Controller is a desktop application that provides a simple UI for specifying parameters and rapidly running actions using VIP. It furthermore enables you to save Masking Parameters easily as Config Files, re-running parameterized Masking Actions rapidly in future.

The VIP Server Controller can be opened from your start menu or from your desktop if you created a desktop item during its installation. The application is called "VIP Server Controller".

Note: The VIP Server Controller must be opened in administrator mode. This allows it to access the files it needs. Right click The VIP Server Controller desktop icon and select "Run as administrator".

The VIP Server Controller is separated into two tabs:

  1. The Flow Cache Server

  2. Run Flow

See articles on both tabs above. They cover the mandatory parameters which must be entered. For a full overview of the parameters that you can enter, please see SQL Masking Parameters list.