Pseudonymize data using data transformation
If you have data, such as personal data, that should be pseudonymized before being used in an analysis, you can define a data transformation to pseudonymize extracted or uploaded data before the data is loaded into the process storage.
You can pseudonymize clear text values in table columns using the SHA2 SQL function in a transformation statement. The SHA2 function uses the SHA2 cryptographic hash function to convert a variable-length string into a character string. The character string is a text representation of the hexadecimal value of the checksum with the specified number of bits.
Use the SHA2 SQL function to pseudonymize the values of a table column in the following form.
sha2(expr, bitLength)
Replace expr with the column name and bitLength with the bit length (for example, 256 or 512) that will be used to encrypt the values.
You pseudonymized data by means of a data transformation.
The SHA2 function encrypts the values of the Executed by column with 256 bits. The encrypted values are displayed in the transformation preview.
