SSIS Data Masking Components
Components Specification
Trial Installation Help
Process Architecture Help
SSIS Help
SSIS Data Masking Components
Open Navigation Article
URL
Purpose
The URL component masks web addresses by replacing the root domain with a value from a predefined substitution list. It expects input in the general format [www].domain.tld[/path] and produces masked output in the format [www].masked-domain.tld.
Key Behaviors:
- Protocol retention: The protocol (http:// or https://) can optionally be retained, based on configuration.
- www. prefix: Retained only if protocol retention is enabled; otherwise, it is removed.
- Domain-Level Output Only: All elements beyond the root domain (e.g., paths, query parameters) are excluded from the final URL and are not retained.
- Industry-specific masking: A masked domain can be selected based on a predefined industry-related property.
The Masking URL version replaces the root domain with a randomly selected value from the substitution list. The masked domain name varies with each run. This version may retain general industry context (e.g., .edu for education) but does not preserve referential integrity.
Algorithm
Variation of Random Character Permutation Algorithm
×
Data Masking Components: URL
Data Masking Components: URL
SSIS Data Masking Components
Components Specification
Trial Installation Help
Process Architecture Help
SSIS Help