Data Masking Components: VIN Dynamic
-
Request
a trial -
Request
a demo -
Request
a quote
SSIS Data Masking Components
Open Navigation Article
Data Masking Components: VIN Dynamic
-
Request
a trial -
Request
a demo -
Request
a quote
VIN Dynamic
Purpose
This component masks Vehicle Identification Numbers (VINs) while preserving their valid structure, format, and character rules.
VIN Format Rules Enforced:
- VIN must be exactly 17 characters long
- Disallows letters I, O, and Q to avoid confusion with digits 1 and 0
- Follows the standard structure defined by ISO 3779
Masking Logic:
The component preserves the first 12 characters of the VIN:
- Positions 1–3: Manufacturer identifier (WMI)
- Positions 4–8: Vehicle descriptor section (VDS)
- Position 9: Check digit (not validated)
- Positions 10–11: Model year and plant code
- Position 12: Start of production sequence
Characters 13–17 (last 5 digits) are masked using a numeric substitution algorithm.
The last 5 digits are masked using a deterministic mapping that ensures referential integrity - the same original VIN will always map to the same masked output. The mapping is not one-to-one; several VINs may share the same masked ending, enhancing privacy while maintaining consistency.
Algorithm
Go to Tutorial
×
![Enlarged Picture]()
Data Masking Components: VIN Dynamic
Download Manual
