Example 1

This is an example of masking in which the name is masked according to referential integrity.

Reference Integrity (Invalid Entry Protection) is a system of rules that ensures that links between records in linked tables are valid and data doesn't accidentally get deleted or modified.

Repeaters are values that, once created and saved in the database, can be used again so that the same original value ('RepeaterKey') is always replaced with the same masked value ('RepeatingValue'). You can read more here.

Table of contents
Video steps


  1. Open Visual Studio Code and Create new Project based on the BizDataX Package Executable template.
  2. To import data from the BizDataX Portal, right-click the Project in the Solution Explorer window and select the 'Import data' option. Select wanted project, data source, schema and tables from the list.
  3. To finish creating a data model, build the project. Delete default 'Helloworldscope' from the Sequence.
  4. Table activities that are going to be used in creating masking workflow are found in the Toolbox. Find 'Step' in the toolbox and drag it to the Sequence.
  5. Drag the 'Customer_Activity' item from the Toolbox into the 'Step'.
  6. Find 'Pick first name' from the list activity and drag it on Table activity, Customer masking.
  7. Select 'FirstName' as property.
  8. Drag the 'CreditCard_Activity' item from the Toolbox into the 'Step'.
  9. Find 'Pick first name' from the list activity and drag it on Table activity, CreditCard masking.
  10. Select 'FirstName' as property.
  11. If a package is run now, all first names in CreditCard and Customer tables will have a different value.
  12. To use Repeaters, from Properties on the right side, Set up RepeaterID, insert string. RepeaterID icon will be shown next to column set for repeating.
  13. Set RepeatingKey to 'FirstName'.
  14. Repeat this process (steps 13 & 14) for the other table (Customer or CreditCard) with the same RepeaterID and RepeatingKey.
  15. By pressing CTRL+F5, build will start. See 'Output'.

Video steps