Example 1

In this example a table is segmented based on values of a non-masked column. Some columns are masked. Primary key is not masked. This example can reflect a scenario where you need to segment non-primary key values in a range of data that was generated within a year.

Table of contents
Example table
Steps

Example table

Table Sales

TransactionId (PK) CashierId Date CustomerCardId DiscountAmnt
6545 12 2018-04-11 null 0
784 223 2019-08-29 92364346 20

Only CashierId, CustomerCardId and DiscountAmnt could be masked.
The table will be segmented, only records from 2019. will be taken - one record will be masked.

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-only symbol Read-only for the primary key
      • Read-only symbol Read-only for the column used for segmenting (eg. Date)
      • Read-write symbol Read-write for columns that will be masked
      • Skip symbol Skip for columns that will not be masked
  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 Primitives group, and create a masking workflow.

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

  6. Update the handler settings based on the database used. See database handler page of the used database for more details.

  • To configure a segmentation, check Fluent Handler API page where segmentation settings are listed.
    • The default handler for the example table is: Datasources.BizDataXDemo_data_source.dbo.Sales.Handle.WithBulk()
    • The modified handler for the same table should be: Datasources.BizDataXDemo_data_source.dbo.Sales.Handle.WithSegments().BySegments("{table}.Date>='2019-01-01'").WithBulk()
  1. 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.