-
Request
a trial -
Request
a demo -
Request
a quote
-
Request
a trial -
Request
a demo -
Request
a quote
API Reference
This reference is inactive and cannot be clicked.
CLR Reference
This reference is inactive and cannot be clicked.
Mask A Key
Description
 The Mask a Key component of SSIS masks unique integer and unique identifiers (GUIDs) with consistent unique values of the same type. They are mainly used to retain referential integrity between primary – foreign keys. They do not work with tiny and small integers (only work with integers 4 bytes and above). |
Usage Instructions:
|
1. Configure a source that contains the column with primary, foreign and artificial (synthetic) keys of integer and unique identifier data types. 
+
|
|
2. Drag and drop the Mask a Key component, then connect the source and the Mask a Key component with the source's precedence constraint.
|
|
3. The precedence constraint (the blue arrow) will now pass proper metadata to the Mask a Key component. If you click on the constraint, you will see the following window: 
+
|
|
4. Once the values for Mask a Key exists, and these 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 a Key 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 a Key component, and view the results of data masking. 
+
|
Go to Documentation
Data Masking Components: Mask A Key
Download Manual
