Mask sensitive data
Use this procedure to apply a mask to field values that contain sensitive or confidential information such as credit card numbers, bank account numbers, telephone numbers, or passwords. When the masked values are displayed in the Viewer, the actual data is replaced with other characters, such as asterisks. Masked values are also used to overwrite records during a data load operation.
You can mask fields only if a SQL mask function exists in Admin Console. The mask function is used to retrieve and convert the masked field value in the query. If a field has a transform function, the mask function is applied to the transformed field.
- Verify that a SQL function for masking data already exists in Admin Console. The function should specify details such as the mask characters.
- In Studio, use to select the record containing a text or string field to mask.
-
Select a field to mask, and in the
Property panel, select
Mask function.
Repeat this step for each text or string field you plan to mask.
-
On the toolbar, select
.
The Project settings window appears.
-
In the
Other group, next to
Mask, click the ellipsis button.
The Mask settings window appears.
- In the list of fields, select one or more fields to mask, and click OK.
- In the Project settings window, click OK again.