Obfuscate Sensitive Data in a Dataset

Apply an Personal Identifiable Information (PII) model to a dataset to mask or hide sensitive data in a dataset. For example, you might partially mask customer address details in a description column so that workbook users don't have access to customers' personal details.

Before you start, perform these prerequisite steps:
  1. On the Oracle Analytics Home page, click Create, and then click Data Flow.
  2. Select the dataset containing the text you want to analyze, then click Add.
  3. In the Data Flow editor, click Add a step (+).
  4. From the Data Flow Steps pane, double-click Apply AI Model, and then select the pretrained PII Identification model that is registered in your Oracle Analytics Cloud environment.

  5. In the Apply AI Model dialog, in the Parameters section, configure these options:
    • Input Column to Obfuscate - Select the column containing the sensitive details that you want to mask or hide.
    • Character for Masking - Enter the character to use to obfuscate. For example, enter "*" to obfuscate data with an asterisk.
    • Number of characters to be left unmasked - Enter 0 to mask or hide all data, or enter a number of characters to leave visible. For example, enter "5" to leave the first five characters unchanged (if you choose From the start in Unmask options).
    • Unmask options - Specify where to start obfuscating. For example, from the start of address details.
  6. In the data flow editor, click Add a step (+) and select Save Data.
  7. Enter the name of the dataset in which to store the output results.
  8. In the Save data to field, specify the location for saving the output data.
  9. Click Save, enter a name and description for the data flow, and click OK to save the data flow.
  10. Click Run Data Flow to analyze the images and output the results in a new dataset.
When the data flow completes the analysis, open the dataset that you specified in Step 7.

To locate the generated dataset, from the Oracle Analytics home page, navigate to Data, then Datasets.

You can now visualize the data in a workbook.
Description of oci_lang_obfuscate2.png follows
Description of the illustration oci_lang_obfuscate2.png