Data Masking Components: Mask Redaction
Search
OpenNavigationArticle
SSIS Data Masking Components
OpenNavigationArticle
Open Navigation Article
Data Masking Components: Mask Redaction
  • Request Trial Request
    a trial
  • Request Demo Request
    a demo
  • Request Quote Request
    a quote
Reference Icon API Reference This reference is inactive and cannot be clicked. Reference Icon CLR Reference This reference is inactive and cannot be clicked.

Mask Redaction


Description


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.

Usage Instructions:

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.

+

TutorialIcon Go to Documentation
About Hush-Hush Contact Us

E-mail: info@mask-me.net

tel: 855.968.4874

Privacy Policy Terms of Use