The data privacy transformation library functions allow you to mask personal data such as social security numbers, credit card numbers, and e-mail addresses. A data privacy license, separate from the Optim™ product license, is needed to use these functions.
You can generate transformed data that is valid and unique. When a transformation library function is called, all destination and source columns are available except those destination columns that are yet to be assigned a value by an exit or transformation library function. The parameters in a transformation library function are validated at run time.
Use the TRANS SSN function to generate a valid and unique U.S. Social Security Number (SSN). By default, TRANS SSN algorithmically generates a consistently altered destination SSN based on the source SSN. TRANS SSN can also generate a random SSN when the source data does not have an SSN value or when there is no need for transforming the source SSN in a consistent manner.
An SSN is made of 3 subfields. The first 3 digits (area) represent an area generally determined by the state in which the SSN is issued. The next 2 digits (group) define a group number corresponding to the area number. The last 4 digits (serial) are a sequential serial number. Regardless of the type of processing, default or random, TRANS SSN will generate an SSN with a group number appropriate to the area number.
The default processing method generates an SSN that includes the source area number as well as altered group and serial numbers based on the source SSN.
The random processing method generates an SSN that can include the source area number and uses a group number most recently issued by the Social Security Administration for the destination area number. Serial numbers begin with 0001 and are incremented by 1 for each additional SSN generated for the area number. When the serial number exceeds 9999, the serial number will be reset to 0001 and the group number preceding the number most recently issued for the area number will be used.
The syntax of TRANS SSN is:
TRANS SSN [‘[=flags] [sourcecol]']
For more information about invalid source values, see Data Types Allowed and Skipped Rows.
The following source and destination data types are permitted:
If a source or destination column does not adhere to these restrictions, an error will occur during processing.
The following rules apply to the destination SSN value, according to the destination data type or value:
If a source value is 11 characters or more and includes embedded dashes (-), or if the ‘-' flag is specified, the destination value will include dashes if the destination column length is 11 characters or more.
If a source value is 11 characters or more and includes embedded dashes (-), or if the ‘-' flag is specified, the destination value will include dashes if the destination column length is 11 characters or more.
The following conditions may cause a source row to be skipped and not written to the destination:
The following error messages may be issued:
The parameter ppp, specified on destination column ccccc, is not valid. Check the processing option flags specified.
The column name entered as the sourcecol parameter or the destination column name (if sourcecol was omitted) was not found on the source table.
The format of the source column is not supported because the attribute aaa is invalid. The value of aaa will be Type, Length, Precision, or Scale.
The format of the destination column is not supported because the attribute aaa is invalid. The value of aaa will be Type, Length, Precision, or Scale.
A return code of nnn was returned when TRANS SSN tried to get the value of source column ccccc.
A return code of nnn was returned when TRANS SSN tried to set the value of destination column ccccc.
If any other errors occur, contact Optim Technical Support.
The following example uses a source column name that matches the destination column and generates a random SSN that is not based on the source value:
TRANS SSN ‘=n'
The following example uses a source column name (SOCIAL) that differs from the destination column and generates an SSN using the default processing method and including dashes:
TRANS SSN ‘=- SOCIAL'
Use the TRANS CCN function to generate a valid and unique credit card number (CCN). By default, TRANS CCN algorithmically generates a consistently altered CCN based on the source CCN. TRANS CCN can also generate a random value when the source data does not have a CCN value or when there is no need for transforming the source CCN in a consistent manner.
A CCN, as defined by ISO 7812, consists of a 6-digit issuer identifier followed by a variable length account number and a single check digit as the final number. The check digit verifies the accuracy of the CCN and is generated by passing the issuer identifier and account numbers through the Luhn algorithm. The maximum length of a CCN is 19 digits.
The default processing method generates a CCN by including the first 4 digits of the issuer identifier from the source CCN and altering the remaining 2 digits of the issuer identifier number and the account number based on the source CCN. A valid check digit is also assigned.
The random processing method generates a CCN that can include the first 4 digits of the source issuer identifier number or an issuer identifier number assigned to American Express®, Discover, MasterCard, or VISA. A valid check digit is also assigned. If the first four digits of a source issuer identifier number are included, the first account number based on those digits will begin with 1, and for each additional CCN that uses those digits, the account number will be incremented by 1.
The syntax of TRANS CCN is:
TRANS CCN [ (‘[=flag] [sourcecol] [ preserve=invalid ] ' ) ]
If a source column name is not specified and the destination column name does not match a column name in the source table, an error will occur during processing.
The following source and destination data types are permitted:
If a source or destination column does not adhere to these restrictions, an error message occurs.
The following rules apply to the destination CCN value, according to the destination data type or value:
The following conditions may cause a source row to be skipped and not written to the destination:
The following error messages may be issued:
The parameter ppp, specified on destination column ccccc, is not valid. Check the processing option flags specified.
The column name entered as the sourcecol parameter or the destination column name (if sourcecol was omitted) was not found on the source table.
The format of the source column is not supported because the attribute aaa is invalid. The value of aaa will be Type or Length.
The format of the destination column is not supported because the attribute aaa is invalid. The value of aaa will be Type or Length.
A return code of nnn was returned when TRANS CCN tried to get the value of source column ccccc.
A return code of nnn was returned when TRANS CCN tried to set the value of destination column ccccc.
If any other errors occur, contact Optim Technical Support.
The following example uses a source column name (CREDIT) that differs from the destination column and generates a random CCN not based on the source value:
TRANS CCN ‘=n CREDIT'
The following example uses a source column name (CREDIT) that differs from the destination column and generates a CCN using the default processing method:
TRANS CCN ‘CREDIT'
Use the TRANS EML function to generate an e-mail address. An e-mail address consists of two parts, a user name followed by a domain name, separated by ‘@'. For example, user@domain.com.
TRANS EML generates an e-mail address with a user name based on either destination data or a literal concatenated with a sequential number. The domain name can be based on an e-mail address in the source data, a literal, or randomly selected from a list of large e-mail service providers. The e‑mail address can also be converted to uppercase or lowercase.
TRANS EML can generate a user name based on the values in one or two destination table columns (usually containing the name(s) of a user). Processing options allow you to use only the first character of the value in the first column (e.g., the initial letter of a first name) and separate the values from both columns using either a period or an underscore.
If the user name is based on a single destination column value or a literal, the name will be concatenated with a sequential number. If a user name is based on values in two destination table columns and a separating period or underscore is not used, the values are concatenated. If a parameter is not provided for the user name, the name will be formed by the literal “email” concatenated with a sequential number. Sequential numbers for user names are suffixes that begin with 1 and are incremented by 1.
The syntax of TRANS EML is:
TRANS EML [‘[=flags] ,[{sourcecol | “domain” | , } [{name1col[name2col] | “userpfx”}] ]']
If neither the ‘n' flag nor the domain parameter are defined, the domain name in the source column is used. (If sourcecol is not defined, the source column name is based on the destination column name.)
If a source column name is not specified and the destination column name does not match a column name in the source table, an error will occur during processing.
The following source and destination data types are permitted:
If a source or destination column does not adhere to these restrictions, an error message will be issued.
The following rules apply to the destination e-mail value, according to the destination data type or value:
The following conditions may cause a source row to be skipped and not written to the destination:
The following error messages may be issued:
The parameter ppp, specified on destination column ccccc, is not valid. Check the processing option flags specified.
The column name entered as the sourcecol parameter or the destination column name (if sourcecol was omitted) was not found on the source table.
The format of the source column is not supported because the attribute aaa is invalid. The value of aaa will be Availability, Type, or Length.
The format of the destination column is not supported because the attribute aaa is invalid. The value of aaa will be Availability, Type, or Length.
A return code of nnn was returned when TRANS EML tried to get the value of source column ccccc.
A return code of nnn was returned when TRANS EML tried to set the value of destination column ccccc.
The string sssss, specified as the domain name literal (domain), exceeds 31 characters.
The string sssss, specified as the user name literal (userpfx), exceeds 31 characters.
The name1col column name was not found on the destination table.
The format of the name1col column is not supported because the attribute aaa is invalid. The value of aaa will be Availability, Type, or Length.
The name1col column name was not found on the destination table.
The format of the name2col column is not supported because the attribute aaa is invalid. The value of aaa will be Availability, Type, or Length.
If any other errors occur, contact Optim Technical Support.
The following example uses a literal (optim.com) to form the domain name and two destination table columns (FIRST_NAME and LAST_NAME) to form a user name that includes an underscore:
TRANS EML ‘=_ “optim.com” FIRST_NAME LAST_NAME'
The following example uses a domain name from the source column and a literal (OptimUser) to form a user name that will be suffixed with a sequential number:
TRANS EML ‘, “OptimUser” '