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

URL


Description

The Masking URL component expects a URL-like string upon input and provides a value for the URL upon output. There are three types of the URL, those for financial companies, health companies, and the mix of both. 0 stands for the mix, 1 indicates financial institutions, and 1 provides healthcare companies’ URL. 

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 masking component, connect the source and the URL component with the source's precedence constraint:

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

+

4. Now that the metadata for the URL 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 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 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