Setup PII data obfuscation

You can enable or disable Personal Identifiable Information (PII) obfuscation and control which database table columns to obfuscate.

PREREQUISITES: To control database obfuscation settings, you must have the Access Repos and Pipelines role.

To manage the PII obfuscation settings, perform the following:

1. Login to Sitefinity Cloud Management Portal.
   
2. Navigate to Pipelines » Library.
   
3. Open PII Obfuscation Settings variable group.
   
4. In the list of Variables, find ObfuscatePII_OnDatabaseBackup_EnvironmentList.
   This variable indicates the environments where data will be obfuscated.
   
5. In the Value field, enter the name of the environments where you want to apply data obfuscation in a comma-separated list.
   For example, enter Staging, Authoring
   If you want to obfuscate all environments, enter All
   

   NOTE: To disable data obfuscation, leave the Value field empty. 

6. In the list of Variables, find ObfuscatePII_OnDatabaseRestoreBetweenEnvironments_EnvironmentList.
   This variable indicates the environments where data will be obfuscated after the restore is completed.
   
7. In the Value field, enter the name of the environments where you want to apply data obfuscation in a comma-separated list. 
   
8. Add or modify obfuscation types.
   The rest of the variables represent a predefined list of database columns distributed in different obfuscation types: CharacterMask_TableColumnsList, HashEmail_TableColumnsList, IP_TableColumnsList, NumberMask_TableColumnsList, StringScramble_TableColumnsList.
   To add a new column to an obfuscation type, use the following format:
   [dbo].[<table_name>] <column_name>
   
9. Save your changes.