Idea Details

NEW MASKING FUNCTION

Last activity 02-01-2019 12:04 AM
Francois Calvert's profile image
12-21-2018 11:07 AM

We need a function that would work on all types of database (IBM AIX and ZOS, Oracle, SQL SERVER) that would work on NUMBERS or CHARACTERS that would combine FORMATENCRYPT and FORMATMASK functionality. We need a function that would consistently mask the given column values by preserving the original format and keeping the unique values and specifies the mask key for each field that we mask. We should keep the possibility to mask or ignore first and last value. The mask key would be inserted in a field what would look like a password.

 

FDM 4.7.323.0

We need this because one of our customers did a reverse engineering on some field and he could determine some of the result. If we mask with a different key some fields that it becomes impossible to do some reverse engineering. You can also change the key in DEV vs PROD to different results.

Example:

Masking : GENDREAU

FORMATENCRYPT the result is always : BMTHEIRY

NEW FUNCTION KEY (546) the result is always : RLRMHMRM

NEW FUNCTION KEY (972) the result is always : LXIFCYIF


Comments

02-01-2019 12:04 AM

Francois, I'll setup a call with you to discuss further.

 

-Prashant