Creating a simple masking flow

A simple masking flow includes masking the FirstName columns from the Customer and CreditCard tables from the Microsoft SQL Server demo database.

Creating a simple masking flow

• Find the Package.xaml file in the Solution Explorer, open it and, delete the auto-generated workflow.

Figure 1: Deleting auto-generated workflow activities

• Find the Sequence in the Toolbox and drag it on the design surface.
  Note: If the Toolbox is not available, open it by selecting View -> Toolbox.

• Find the Step in the Toolbox and drag it on the Sequence

• Find the CreditCard_Activity item in the Toolbox. The item represents the imported CreditCard table. Drag the CreditCard_Activity item from the Toolbox and drop it on the Step.

• Find the Customer_Activity item in the Toolbox. The item represents the imported Customer table. Drag the Customer_Activity item from the Toolbox and drop it on the Step right after the CreditCard_Activity.

• Find the Pick first name from list activity and drag it on both table activity

• Select FirstName as Property on both activities

• Compare your workflow with the one shown below to make sure that the data masking will work as expected.

Figure 2: Masking engine and data processing activities in place