In this example a table is segmented based on values of a masked column. Some columns are masked. Primary key is not masked. This example can reflect a scenario where you have a lot of null values and you want to mask only non-null values.
Table of contents |
---|
Example table |
Steps |
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. Date will be skipped.
The table will be segmented, only records where CustomerCardId is not null will be taken - one record will be masked.
Import Portal data into the BizDataX Package Executable project in the BizDataX Designer to create a data model in it.
Build the project to generate table masking activities and start working.
Check available BizDataX masking activities in the Toolbox, for example some activity from the BizDataX Primitives group, and create a masking workflow.
Additionally, use package steps and parameters in the masking workflow.
Update the handler settings based on the database used. See database handler page of the used database for more details.
Datasources.BizDataXDemo_data_source.dbo.Sales.Handle.WithBulk()
Datasources.BizDataXDemo_data_source.dbo.Sales.Handle.WithSegments().BySegments("{table}.CustomerCardId is not null").WithBulk()
BizDataX Documentation © Built by Ekobit. All rights reserved.
https://www.ekobit.com/ https://bizdatax.com/ https://bizdatax.com/support/