Example 5

This is a simple example where some columns in a table without a primary key are masked.

Table of contents
Example table
Steps

Example table

Table Phonebook

PhoneNumber FirstName LastName Address
+38512345678 John Doe 123 Main street

Only FirstName and LastName could be masked. PhoneNumber and Address will be skipped.

Steps

  1. Create a data model on the BizDataX Portal.

  2. Import Portal data into the BizDataX Package Executable project in the BizDataX Designer to create a data model in it.

    • Use the following settings:
      • Read-write symbol Read-write for the columns you want to mask
      • Skip symbol Skip for the columns you don't want to mask

  3. Build the project to generate table masking activities and start working.

  4. Check available BizDataX masking activities in the Toolbox, for example some activity from the BizDataX Pick Data From List group, and create a masking workflow.

  5. Additionally, use package steps and parameters in the masking workflow.

  6. Additionally, update the handler settings based on the database used. See database handler page of the used database for more details.

  7. The execute the created masking workflow, click Debug -> Start Without Debugging (or CTRL+F5). A console window will appear and, within seconds, the process will be done. Check the database to confirm.

BizDataX Documentation © Built by Ekobit. All rights reserved.

https://www.ekobit.com/ https://bizdatax.com/ https://bizdatax.com/support/