Masking of Plaintext in Database Table Using Masking.properties File
In this sample, using CT-V Bulk Utility, four database tables data will be masked using masking.properties
file.
Note
The name and structure of both the source and destination tables are same for the masking. The operation can be performed only in homogeneous databases.
The following sample is explained using four tables:
Source Data Tables
Below are the source data tables namely Table1, Table2, Table3, and Table4 in the database:
Setting Parameters for Masking.properties File
Below is the parameters set for encryption in the source database tables:
Running CipherTrust Vaulted Tokenization Bulk Utility
Enter the following command to encrypt with CT-V Bulk Utility in a Windows environment:
Reviewing the Output Data Table
The output data is saved at the same destination mentioned in the masking.properties
file with the table names Table1, Table2, Table3, and Table4. As per the masking configuration parameters, only column fname
of Table1 and Table3 are masked, and Table4 gets copied. Also, Table2 gets copied as it has parent-child foreign key relationship with Table1 even though it was not specified in the NonMaskingTables parameter
.
Here is the data from the destination database tables: