Data Masking Components: IP Address

{TOC}

SSIS IP Address DATA MASKING COMPONENT

PRESERVING REFERENTIAL INTEGRITY API Reference, CLR Reference (links)

Purpose

The purpose of the component is to mask an element of countryIP codeaddress that is originally formatted with either version 4 or 6 or in suchtransition with alook way-alike thatand itconforming to the standard random IP value. The element's algorithm preserves themajor format,elements satisfiesof ISO,formation. andFor allowsmore fordefined repeatablematrix replacementdefinition valueplease acrosscontact anus enterpriseat preserving referential integrity.info@mask-me.net.

Algorithm

Preserving Referential Integrity Substitution Algorithm td>

Description

USE INSTRUCTIONS ARE COMING SOON

Description here

Usage Instructions:

1. Configure country code source to contain a country code column. The data should include two-letter, three-letter, or three-digit country code. Country name is also a possible entry value, if confirmed by one of the ISO 3166-1.
2. Drag and Drop Country Code Component, connect the source and the country code component:
3. Now, the precedence constraint (the blue arrow) passes proper meta-data for the country code component. If you click on it, you will see:
4. Now that the metadata for the country code exists, and values are passed into the masking component, please open the component editor:
5. In the second tab, there are input columns. Please check-mark only one column, the Country Code:
This will create an extra column with the prefix “Masked_”.
6. Create a connection manager for the destination and configure source component for the destination. In it in the tab “Mappings” specify that you want newly created CountryCode_Masked to be a field replacing the original value. For that, just click on the available input columns, chose the masked value and map to the “Available Destination Columns”
7. Now, all the configurations are complete for the valid values. You can run the component and see the results of masking:

Error Handling

Download Example

8. If, however, there are invalid values in the package, one would need to configure error handling. For that, each data masking component has error handling precedence constraint. One needs to create error connection and connect red arrow (error handling constraint) with this destination. As the connection is made, one needs to configure the state: “Fail”,”Ignore” or “Redirect”.
9. It is recommended that one re-directs the output into the error destination, so that later one be able to analyze and process data for quality purposes. After the re-direct is done, one still can mask the data with the Country Code Dynamic component.
The value in the original file is erroneous in spelling” Antarcticaa” vs. “Antarctica” and it results in error, in the error destination file:
Country Code component will make it masked – or if one choses, one can not process it at all.
The rest of the components are configured in a similar fashion.