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 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.