Data Masking Components: URL Dynamic
Search
OpenNavigationArticle
SSIS Data Masking Components
OpenNavigationArticle
Open Navigation Article
Data Masking Components: URL Dynamic
  • Request Trial Request
    a trial
  • Request Demo Request
    a demo
  • Request Quote Request
    a quote

URL Dynamic


Description

The Masking URL Dynamic component provides a choice for financial institutions URLs, health institutions URLs, or mix. To choose the type of URLs, one has to put 1, 2, or 0 correspondingly in the custom property of company type field in the editor.

 

Usage Instructions:

1. Configure a source that contains the column with alphabetical and numeric characters. The data in the column may also include any other character that will be treated as a separator.

+

2. Drag and Drop URL Dynamic masking component, connect the source and the URL Dynamic component with the source's precedence constraint:

3. Now, the precedence constraint (the blue arrow) passes proper meta-data to the URL Dynamic component. If you click on constraint, you will see:

+

4. Now that the metadata for the UR ynamic exists, and values are passed into the data masking component, please open the component editor:

+

5. In the second tab, there are input columns. Please check-mark only one column, the one that you will be masking with URL Dynamic algorithm:

+

6. This will create an extra column with the prefix “Masked_”.

+

7. Create a connection manager for the destination and configure source component for the destination. In the connection manager, in the tab “Mappings”, specify that you want newly created Field_Masked to be a field replacing the original value. For that, just click on the available input columns, choose the masked value, and map to the “Available Destination Columns”

+

8. Now, all the configurations are complete for the valid values. You can run the package with the URL Dynamic Data Masking component, and see 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