Masking Operational Data Process
The process to mask operational data comprises two steps:
-
Transforming identifiable data based on the metadata configuration.
-
Purge the data from the entities.
Run the PL/SQL Package
- Prerequisites
-
Create a backup of the source environment.
- Run the PL/SQL Package
-
To run the package, perform the following steps:
-
Create a PDB clone of the source environment.
-
Confirm whether the package runs on the newly-cloned environment and not on the source environment.
-
Run the package on the cloned PDB using the following command. You need ohi_<app>_owner privileges to run the package.
exec ohi_data_deidentification_pkg.de_identify_data_parallel(<parameter 1>, <parameter 2>, '<parameter 3>', <parameter 4>, '<parameter 5>');
Where:
-
The parameter 1 and 2 contain seed values for
NUMHASHADD
andNUMHASHCON
transformation functions. -
The parameter 3 contains a seed value for the
TXTHASH
function. -
The parameter 4 is optional and contains the commit frequency with a default value of 5000.
-
The parameter 5 is optional and contains a Yes (Y) or No (N) values to enable the logging process. The application has the logging process as disabled by default.
Following are the sample commands to run the masking package:
exec ohi_data_deidentification_pkg.de_identify_data_parallel(999 ,987, 'sometext');
exec ohi_data_deidentification_pkg.de_identify_data_parallel(999 ,987, 'sometext', 10000, N);
-
-
Create an export of the masked schema.
-
Deploy the application by following the instructions in the Installation Guide to install the application on the server with the masked schema.
-
Data Transformation Process
Step 1: Mask Data
-
The process starts to transform data based on the configuration from the Data Masking Configuration Integration Point.
-
The process resets the audit columns for the transformed or updated rows, like
Created By
,Creation Data
,Last Updated By
andLast Updated Date
columns of a table.
Step 2: Purge Data
The application purges the data from the entities listed below.
- Entities
-
List of entities that purge completely for this process:
Used For | Entity Name |
---|---|
Notes |
Note |
Financial Details |
FinancialTransactionDetail |
Policy Update Requests |
PolicyUpdateRequest |
Interfaced Messages |
InterfacedMessageDetail |
- Properties
-
List of the properties set to
null
as part of this process:
Entity Name |
Properties |
ActivityMessage |
value0..value9 |
PolicyMessage |
value0..value9 |
GroupClientMessage |
value0..value9 |
PolicyEnrollmentEvent |
value0..value9 + Change Details |
Activity |
extraInfo |
Task |
extraInfo |
TaskAttribute |
Clob |
InterfacedMessage |
requestMessage |
DataFile |
File data |
Address |
houseNumber |