Example 3

This is an example where all primary key and some non-primary key columns of the table are masked.

Table of contents
Example table
Steps

Example table

Table Users

ID (PK) FirstName LastName Email DateOfBirth
17643925741 John Doe jdoe@mail.com 1994-05-06

Only ID, FirstName, LastName and Email will be masked.

Steps

  1. Import your table from the BizDataX Portal

    • Use the following settings:
      • Read-write symbol Read-write for the primary key
        • Alert symbol Make sure to include all primary key columns
      • Read-write symbol Read-write for columns you want to mask
      • Skip symbol Skip for columns you don't want to mask
  2. Generate models and add activities

  3. Update the handler settings based on the database used. See supported data sets for more details.

  4. Set up your masking activities inside the Masking block activity.

  5. Compile, run, wait for the process to finish and verify that everything is masked.