Executing Data Redaction Utility with TRUE flag

Following are the steps involved if dataredaction utility is executed with TRUE flag:
  1. From the Configuration window of System Configuration module, enter the absolute path where the encryption key is stored in the Encryption Key Path field. If this is not provided, default key will be used which is available in $fic_home/conf folder.
  2. From the Batch Maintenance window, search for Batch ID as “##INFODOM##_DATA_REDACTION”.
  3. Select the Batch.
  4. Select the task from the Task Details pane and click Edit.
  5. In the Executable field in the Dynamic Parameters List, specify as dataredaction.sh,true,<<ofsaa user id>>.
  6. Click Save.
  7. From the Batch Execution window, search for Batch ID as <>>.
  8. Select the Batch and click Execute Batch.
  9. Navigate to FTPshare/DataRedaction folder. You can find 2 folders called Scripts and Postscripts inside DataRedaction folder.
  10. Decrypt “create scripts” in the FTPshare/DataRedaction/scripts folder using dmtfileencryption.sh with the following arguments:
    ./dmtfileencryption.sh decrypt_file <INPUTFILE> <OUTPUTFILE> <KEYFILE>
    • <INPUTFILE>- Provide the absolute path of the input file. Since all "create scripts" in the scripts folder need to be decrypted, you can provide the folder path, that is, FTPshare/DataRedaction/scripts.
    • <OUTPUTFILE>- Provide the absolute path of the input file.
    • <KEYFILE>- Provide the absolute path of key file with key file name. This should be same as that is provided in the Configuration window. If nothing was provided in the Configuration window, specify the default key path as:

      $fic_home/conf/ofsaa8xkey.ext.

      For more details, see Command Line Utility for DMT File Encryption section in OFS Analytical Applications Infrastructure User Guide.

  11. Execute the decrypted "create scripts" in the Atomic Schema.
  12. Execute scripts in the FTPshare/DataRedaction/postscripts folder for populating required OFSAA metadata.
    The identified table data will be redacted.