Run a Masking Job in the Simulation Mode

You can run your masking job in the simulation mode (preview mode). The simulation mode lets you review the before mask and after mask values before you make the actual updates in the database. When you specify options to run the masking job in the simulation mode, Fast Data Masker runs the masking process without updating the database. Fast Data Masker saves all the information in an audit file (CSV file) with the original and masked values. You can view the CSV file and can analyze how your masking affects the data in the database. Based on your analysis, you can take an informed decision. For example, you can decide whether you want to proceed with the specified masking job or you want to further refine the options. 
tdm49
You can run your masking job in the simulation mode (preview mode). The simulation mode lets you review the 
before mask
 and 
after mask
 values before you make the actual updates in the database. When you specify options to run the masking job in the simulation mode, Fast Data Masker runs the masking process without updating the database. Fast Data Masker saves all the information in an audit file (CSV file) with the original and masked values. You can view the CSV file and can analyze how your masking affects the data in the database. Based on your analysis, you can take an informed decision. For example, you can decide whether you want to proceed with the specified masking job or you want to further refine the options. 
 You configure appropriate options in the
Options
tab to enable the simulation mode.
  1. Access the Fast Data Masker Mapper interface.
  2. Click the
    Masking
    tab and perform the following tasks:
    1. Select the table that you want to use for masking.
    2. Select the column that you want to mask for the selected table.
    3. Select the appropriate mask type.
  3. Click the
    Options
    tab and provide information for the appropriate options to use the simulation mode based on your requirements:
    • DBUPDATES
      Specify the value as N to run the masking job in the simulation mode.
    • AUDIT 
      Specify whether you want to audit all the rows in the column (ALL), first n rows in the column (ROWnnn), or every nth row in the column (SAMPLEnnn). 
    • AUDITFILE 
      Specify the name of the audit file in which you want to store the audit information. The default name is myaudit.csv.
    • AUDITDIR 
      Specify the location where you want to save the audit file.
    • AUDITZIP
      Specify whether you want to zip the audit CSV file. Values are winzip or jzip for the program to use for the zip.
      Note:
      Ensure that the WinZip command-line utility is already installed on the same system. This utility is required for all the options that involve zipped file (AUDITZIP and AUDITPASSWORD).
    • AUDITPASSWORD 
      Specify the password for the audit ZIP file. This password is required when you try to open the saved audit ZIP file.
    • AUDITVALUESLeave this option empty to show the old and new values in the audit file. 
    • AUDITONLYCOLUMNS 
      Specify the specific list of columns that you want to audit in the format—table1.column1, table2.column2, table3.column3. This option is helpful in scenarios where you try to mask more columns but want to audit only a few of them. For example, you try to mask five columns and want to audit only two of them.
    Note:
    For more information about all the masking options, see the Understand Masking Options section.
  4. Click the
    Summary
    tab and perform the following tasks:
    1. Click the
      Save & Run Mask
      button.
    2. Save the CSV file that contains all the masking information that is displayed in the
      Summary
      tab.
    3. Save the TXT file that contains all the options information that is displayed in the
      Options
      tab. 
    4. Click
      OK
      on the confirmation dialog that states that both the files are saved to the specified locations.
      The Fast Data Masker Mapper runs the masking job to initiate and complete the masking process. The
      Mask Complete
      message appears after the masking is done.
    5. Click OK.
      The data masking in the simulation mode is complete. 
  5. Navigate to the location where you saved the audit file.
  6. Open the saved file.
  7. Compare the old data (that you want to mask) against the new data (with which you want to mask) for the columns that you selected for masking. 
    This information helps you analyze the impact of your masking.
  8. Query your database to verify that the original data remains unchanged in the database because the masking was done in the simulation mode.
Example 1: Mask All Rows in the first_name Column (ALL)
Consider a scenario where you want to mask the first name of all the employees. Additionally, you want to use the simulation mode so that you can view the masked values before database updates are done. In this case, after you specify appropriate values in the
Masking
tab, specify the following values in the
Options
tab:
  • AUDIT=ALL
  • AUDITDIR=c:\Audit
  • AUDITFILE=firstName.csv
  • DBUPDATES=N
Now, when you run the masking job (
Summary
tab), the Fast Data Masker Mapper runs the masking in the simulation mode and saves all the information about old and new data in this CSV audit file. The Fast Data Masker Mapper does not update the database with the masking data. The following snippet shows an example of the audit file firstName.csv that includes the old and new first names: 
MASKING STARTED AT: 2016.01.08 12:08:12.167 IST
MASKING DATABASE USER: sa
OPERATING SYSTEM USER: Administrator
MAPPING FILE ARCHIVED AS: C:/Users/Administrator/AppData/Roaming/Grid-Tools/FastDataMasker/backups/PreviewMask.20160118115152.csv
OPTIONS:
AUDIT=ALL
AUDITDIR=c:\Audit
AUDITFILE=firstName.csv
DBUPDATES=N
SEEDFILEDIR=C:\Program Files\Grid-Tools\FastDataMasker\seedtables
TABLE,UNIQUE COLUMNS, UNIQUE COLUMN VALUES, MASK COLUMN, FUNCTION, OLDVALUE,NEWVALUE
employee,"employee_id","1001","first name","HASHLOV","Keyla","Andrea"
employee,"employee_id","1002","first name","HASHLOV","Kiara","Jaylene"
employee,"employee_id","1003","first name","HASHLOV","Cassandra","Lina"
employee,"employee_id","1004","first name","HASHLOV","Alena","Carissa"
employee,"employee_id","1005","first name","HASHLOV","Janice","Genevieve"
employee,"employee_id","1006","first name","HASHLOV","Iliana","Mayra"
employee,"employee_id","1007","first name","HASHLOV","Raina","Kennedy"
employee,"employee_id","1008","first name","HASHLOV","Christa","Cassie"
employee,"employee_id","1009","first name","HASHLOV","Vanesa","Adeline"
employee,"employee_id","1010","first name","HASHLOV","Jamya","Cassidy"
employee,"employee_id","1011","first name","HASHLOV","John","William"
employee,"employee_id","1012","first name","HASHLOV","Stephen","Peter"
employee,"employee_id","1013","first name","HASHLOV","Shawn","Derek"
employee,"employee_id","1014","first name","HASHLOV","Lauri","Pamela"
employee,"employee_id","1015","first name","HASHLOV","Michael","Gregg"
This preview information helps you understand how your masking changes the data in the database.
The following table shows a snippet of the "employee" table in the database after you run the masking job in the simulation mode. You can verify that no changes are made to the first_name column (as expected in this mode). The first_name column still shows the original name (before masking):
employee_id
first_name
last_name
1001
Keyla
Strogoff
1002
Kiara
Garine
.......
 
 
1009
Vanesa
Noot
1010
Jamya
Bach
......
 
 
1015
Michael
Witt
Example 2: Mask First 10 Rows in the first_name Column (ROW010) 
Consider a scenario where you want to mask the first name of the first ten employees in the employee table. In this case, specify the following values in the 
Options
 tab: 
  • AUDIT=ROW010
  • AUDITDIR=c:\Audit
  • AUDITFILE=tenFirstName.csv
  • DBUPDATES=N 
The following snippet shows an example of the audit file tenFirstName.csv. This file includes the old and new first names of the first ten employees: 
MASKING STARTED AT: 2016.01.08 11:51:52.913 IST
MASKING DATABASE USER: sa
OPERATING SYSTEM USER: Administrator
MAPPING FILE ARCHIVED AS: C:/Users/Administrator/AppData/Roaming/Grid-Tools/FastDataMasker/backups/PreviewROW.20160118120812.csv
OPTIONS:
AUDIT=ROW010
AUDITDIR=c:\Audit
AUDITFILE=tenFirstName.csv
DBUPDATES=N
SEEDFILEDIR=C:\Program Files\Grid-Tools\FastDataMasker\seedtables
TABLE,UNIQUE COLUMNS, UNIQUE COLUMN VALUES, MASK COLUMN, FUNCTION, OLDVALUE,NEWVALUE
employee,"employee_id","1001","first name","HASHLOV","Keyla","Andrea"
employee,"employee_id","1002","first name","HASHLOV","Kiara","Jaylene"
employee,"employee_id","1003","first name","HASHLOV","Cassandra","Lina"
employee,"employee_id","1004","first name","HASHLOV","Alena","Carissa"
employee,"employee_id","1005","first name","HASHLOV","Janice","Genevieve"
employee,"employee_id","1006","first name","HASHLOV","Iliana","Mayra"
employee,"employee_id","1007","first name","HASHLOV","Raina","Kennedy"
employee,"employee_id","1008","first name","HASHLOV","Christa","Cassie"
employee,"employee_id","1009","first name","HASHLOV","Vanesa","Adeline"
employee,"employee_id","1010","first name","HASHLOV","Jamya","Cassidy"
The following table shows a snippet of the "employee" table in the database after you run the masking job in the simulation mode. You can verify that no changes are made to the first_name column (as expected in this mode). The first_name column still shows the original name (before masking): 
employee_id
first_name
last_name
1001
Keyla
Strogoff
1002
Kiara
Garine
.....
 
 
1008
Christa
Chastain
1009
Vanesa
Noot
1010
Jamya
Bach
Example 3: Mask Every 10th Row in the first_name Column (SAMPLE10) 
Consider a scenario where you want to mask the first name of every tenth employee in the employee table. In this case, specify the following values in the 
Options
 tab:  
  • AUDIT=SAMPLE010
  • AUDITDIR=c:\Audit
  • AUDITFILE=firstNameTenth.csv
  • DBUPDATES=N  
The following snippet shows an example of the audit file firstNameTenth.csv. This file includes the old and new first names of every tenth employee in the employee table in the database:  
MASKING STARTED AT: 2016.01.08 12:03:17.402 IST
MASKING DATABASE USER: sa
OPERATING SYSTEM USER: Administrator
MAPPING FILE ARCHIVED AS: C:/Users/Administrator/AppData/Roaming/Grid-Tools/FastDataMasker/backups/PreviewSample.20160118120317.csv
OPTIONS:
AUDIT=SAMPLE010
AUDITDIR=c:\Audit
AUDITFILE=firstNameTenth.csv
DBUPDATES=N
SEEDFILEDIR=C:\Program Files\Grid-Tools\FastDataMasker\seedtables
TABLE,UNIQUE COLUMNS, UNIQUE COLUMN VALUES, MASK COLUMN, FUNCTION, OLDVALUE,NEWVALUE
employee,"employee_id","1010","first name","HASHLOV","Jamya","Cassidy"
employee,"employee_id","1020","first name","HASHLOV","Nicole","Kylie"
employee,"employee_id","1030","first name","HASHLOV","Adrian","Lisa"
employee,"employee_id","1040","first name","HASHLOV","Robin","Anya"
employee,"employee_id","1050","first name","HASHLOV","Kristina","Madeline"
employee,"employee_id","1060","first name","HASHLOV","Paul","James"
employee,"employee_id","1070","first name","HASHLOV","Terrence","Richard"
employee,"employee_id","1080","first name","HASHLOV","Maria","Elisa"
employee,"employee_id","1090","first name","HASHLOV","Jina","Jennifer"
The following table shows a snippet of the "employee" table in the database after you run the masking job in the simulation mode. You can verify that no changes are made to every tenth row in the first_name column (as expected in this mode). Every tenth row in the first_name column still shows the original name (before masking):  
employee_id
first_name
last_name
1001
Keyla
Strogoff
1002
Kiara
Garine
.......
 
 
1009
Vanesa
Noot
1010
Jamya
Bach
1011
Vladimir
Yagolnister
.....
 
 
1020
Nicole
Appling
Additional Examples
The following are a few more examples that explain other use cases in the simulation mode:
  • Zip Your Audit File
    If you want to zip your firstName.csv audit file and save the zipped file in the audit directory, you can specify the following information in the
    Options
    tab:
    • AUDIT=ALL
    • AUDITDIR=c:\Audit
    • AUDITFILE=firstName.csv
    • AUDITZIP=winzip
    • DBUPDATES=N
    After you run the masking job, the audit file is zipped and is saved as firstName.zip in the c:\Audit folder. To access the firstName.csv file, extract the zipped file (firstName.zip).
  • Use Password to Protect Your Audit File
    If you want to zip your firstName.csv audit file, protect your audit file with the help of a password, and save the zipped file in the audit directory, you can specify the following information in the
    Options
    tab:
    • AUDIT=ALL
    • AUDITDIR=c:\Audit
    • AUDITFILE=firstName.csv
    • AUDITPASSWORD=MyPassword01
    • AUDITZIP=winzip
    • DBUPDATES=N
    After you run the masking job, the audit file is zipped, protected with a password, and is saved as firstName.zip in the c:\Audit folder. To access the firstName.csv file, extract the zipped file (firstName.zip) and enter the password.
  • Audit Only Specific Columns
    Consider a scenario where you want to mask the first_name and last_name columns in the employee table but want to audit only the first_name column. In this case, you specify the following information in the Options tab:
    • AUDIT=ALL
    • AUDITDIR=c:\Audit
    • AUDITFILE=firstName.csv
    • AUDITONLYCOLUMNS=employee.first_name
    • DBUPDATES=N
    The Fast Data Masker Mapper audits only the first_name column in the employee table. The Fast Data Masker Mapper ignores the last_name column for audit.