Description

This lesson describes how to define a GenRocket Domain with Attributes that will be used for masking sensitive database table columns, plus adding a Receiver and creating a Quick Scenario.


Overview

When copying data from a table in a source database to a table in a destination database, it is imperative that source table columns containing sensitive data be replaced by GenRocket's synthetically generated test data that best represents the original sensitive data, thus rendering the migrated safe for use with testing.


Example User Database Table

The user table, defined below, will be used in our example database migration with synthetic data replacement. The tables highlighted in red are the sensitive data columns and must have their data synthetically replaced.  



To be absolutely clear of the columns that need synthetic data replacement they are listed below:

  • id
  • first_name
  • last_name
  • username
  • ssn
  • password


Creating the User Domain

Within your project, create a Domain called, user, and only add Attributes for table columns having sensitive data that will need to be replaced with synthetically generated data. The Attributes with there suggested Generators are defined below.

  • id - RangeGen
    • No modifications are necessary
  • firstName - NameGen 
    • nameType: firstName
    • sortOrder: random
  • lastName - NameGen
    • nameType: lastName
    • sortOrder: random
  • userName - ConcatGen
    • User
    • #{User.id}
  • ssn - SSNGen
    • No modifications are necessary
  • password - EnctypeGen
    • textToEncrypt: #{User.id}


Assign a Receiver

Since this Domain will be used for data migration and synthetic data replacement, it is only necessary to assign the Domain the SimpleMapReceiver.  Assign the User Domain the SimpleMapReceiver.


Creating a Quick Scenario

Since the amount of data in the source table, plus the option of filtering with a where clause, will determine how many rows of data will be migrated from the source table to the destination table, the Domains default loopCount of One will suffice and you only need to click the Quick Scenario button to create a Scenario of the Domain.


If you have followed the above steps correctly, you user Domain form should look very similar to the following image below.




Move onto the next lesson >