Not logged in - Login


R
e
q
u
e
s
t

a

d
e
m
o
< back

Data Masking Components: Generic Alpha Numeric

{TOC}

"Generic Alpha Numeric "


Generic Alpha Numeric component replaces letters with letters, while maintaining capitalization, and replaces numbers with numbers. It retains the non-alphanumeric characters, such as dashes, slashes, dots and comas, exactly at the position at which the non-alphanumeric characters presented themselves at the source value. It currently only replaces characters from alphabets that use English characters. The component will replace strings based on letters only with letter strings and strings based on numeric characters, only with numeric characters. For example, "Abc" will become "Zyx" and "123" will become "987" after component execution.

API Reference, CLR Reference (links)

Usage Instructions:

Purpose

The purpose of the component is to mask such values as Account or Patient Numbers that often consist of the combination of Alpha and Numeric characters and are not formed by a specific rule.

Algorithm

Variation of Random [Character Replacement Algorithm](enter url or page name)

SSIS Instructions and Samples

API reference

SQL CLR Reference

Download a Trial