Data Masking Example using Expression in TIBCO Data Virtualization

Data Masking Example using Expression in TIBCO Data Virtualization

book

Article ID: KB0074654

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization -

Description

This is an simple example of data masking with column based security using as expression.

Issue/Introduction

Building example expression for data masking

Resolution

Steps to enable data masking.

We can use any expression which is valid. To ensure the expression works fine, please test it in studio by querying the expression in Studio scratchpad as below.

User-added image

If the expression works fine in studio than you can apply the same in edit policy under column based masking in Webmanager.
Create or edit policy and the expression and select required user/group on which the rule needs to be applied.
User-added image

Now navigate to Edit Assignment and expand the View and select the rule created on the column on which you want to apply the rule.
User-added image