GenRocket provides a data masking capability for databases and files, referred to as Synthetic Data Masking (SDM). For databases, SDM can be set up using the G-Migration+ feature. Click here to learn more about G-Migration+.

The user imports a table schema from a source database, creates a G-Migration+ configuration, adds tables, and then selects sensitive data columns within the added tables. When the migration is performed, the source database is queried, and synthetic data is generated for sensitive columns before inserting the data into the destination database. 


In This Article

What is a Sensitive Column?

  • A table column in the source database that contains sensitive data values (e.g., SSN, Date of Birth).
  • These columns require synthetic test data to be generated before inserting the data into the destination database. 

Two Ways to Select Sensitive Columns within a Table

  1. Select sensitive columns while adding tables to the G-Migration+ Configuration.
  2. Select a table and then click on the Manage Columns button. 

How to Add Tables and Select Columns

  • Select a G-Migration+ Configuration.
  • Click on the Add Tables button.

  • Use the checkboxes to select one or more tables within the imported table schema and click Save.

  • Use the checkboxes to select the sensitive columns for each added table.
  • Click Save or Save and Next (multiple tables).

    Note: If an added table does not have sensitive columns, click Cancel.

  • In this example, sensitive columns were selected in the customer table.

  • A Domain and Scenario are created for a table whenever one or more sensitive columns are selected. 

  • The Domain contains an Attribute (i.e., column) for each selected column with an automatically assigned Generator. 

How to Modify What Synthetic Data is Inserted

Users can replace Generators and change Generator Parameter configurations for any created Scenario. They can also create a G-Case Suite and G-Cases within the selected Project/Project Version. This allows the user to insert a richer test data set into the destination database. 

Note: The steps are the same as when using these features with other types of Projects. 

Generator Example

A customer table is being migrated that contains an SSN, which has been chosen as a sensitive column. Whenever sensitive columns are selected for a table, a Domain and Scenario are automatically created within the Project Version. 

  • The Customer Domain contains an SSN Attribute.
  • The SSNGen Generator has been assigned with the default parameter configuration.
  • A user wants the SSNs to follow a pattern; however, the default configuration generates random data. 
  • The user clicks on the Customer Domain within the G-Migration+ Dashboard.

  • The user selects the SSN Attribute and changes the generationType parameter from 'random' to 'sequential.'
  • They then save the change and continue with the 

How to Modify Selected Columns for an Added Table

The following steps can be performed to select or unselect columns for an already added table:

  • Select a G-Migration+ Configuration.
  • Select an added Table.

  • Click on the Manage Columns button.

  • Use the checkboxes to select sensitive columns within the table and click Save.

Next Steps After Setup

  • Use the following icon to download a zip file containing all required Scenarios and the G-Migration+ configuration. If G-Cases are being used, they will also need to be downloaded. 

  • Extract the zip file and place the Scenarios in the file path defined for the (see below).
  • Place the G-Migration+ Configuration and any G-Cases into the file path defined for the 
  • Once finished, run the G-Migration+ command to perform the migration. 

    Note: Please look at Synthetic Data Masking (SDM) Use Case Example for Databases for a step-by-step example.