Data Masking Components: Mask Redaction
Data Redaction is a component of SSIS that removes sensitive information so as to render the remaining elements unidentifiable. The process of Data Redaction involves removing or obfuscating sensitive data elements prior to display by applications.
The purpose of data redaction is to prevent the visibility of a sensitive data element such as a credit card number.
|The Mask redaction component redacts data character per character with the character defined in the custom properties. It can be “*”,”x”,”+”,” “ or any other character. It is a very simple component gear towards complete value redaction.|
|1. Configure a source that contains the column with alphabetical and numeric characters.|
|2. Drag and drop the Mask Redaction component, then connect the source and the Mask Redaction component with the source's precedence constraint.|
|3. The precedence constraint (the blue arrow) will now pass proper meta-data to the Mask Redaction component. If you click on the constraint, you will see the following window:|
|4. Once the metadata for the Mask Redaction exists, and the values are passed into the data masking component, open the component editor.|
|5. In the second tab, you will see the input columns. Only check-mark the column that you will be masking with the Mask Redaction algorithm.|
|6. An extra column with the prefix “Masked_” will be created.|
|7. Create a connection manager for the destination and configure the source component for the destination. In the connection manager, navigate to the “Mappings” tab, and specify that you want the newly created Masked_Field to replace the original value. Click on the available input columns, choose the masked value, and map to the “Available Destination Columns”.|
|8. All the configurations should now be complete for the valid values.. You can run the package with the Mask Redaction component, and view the results of data masking.|