Creating new data (Generate)

A safe method to mask data is generate new data. With the Generate option data will be replaced with data based on seed files or logic.

To add the Generate function follow the following steps

Select the LOCATIONS table from the table list
Right click STREET column
From the context menu choose Add function → Generate

The function editor will open and you have different options. We open the selection drop-down menu (current filled in: 'Random date/time') and choose: 'Street'

Add as a description: Generates US streets
Use the drop-down menu 'Countries' to select US streets
Select the: Replace the same original values with the same generated value Checkbox below in the window. This checkbox will replace all identical values with the same value
Click OK to add this function and close the function editor.

Now we want to complete the masking by also replacing the cities with generated names:

Right click CITY column
From the context menu choose Add function → Generate

The function editor will open and you have different options. We open the selection drop-down menu (current filled in: 'Random date/time') and choose: 'City'

Add as a description: Generates US cities
Use the drop-down menu 'Countries' to select US cities
Select the: Deterministic radio option and define a salt key.
Click OK to add this function and close the function editor

Well done! You've configured your first synthetic masking function. The function is added to the function list. You can double click or right click and choose Edit function... to open up the function editor again.