Lesson Summary

In this POC we first want to populate our database tables with realistic, synthetic data, before performing updates with via synthetic data replacement; therefore we want to assign the GenericSQLInsertReceiver to each Domain. 


Note, in a traditional use case of synthetic data replacement you wouldn't perform this step because you are already dealing with production data in your database. This lesson exists so you can easily simulate having production data in your database before replacing columns with synthetic data. 


Lesson Steps

Step 1 - Add a GenericSQLInsertReceiver to the User Domain

  • On the Project Dashboard, go to the Domains panel and click on the 'User' Domain link.
  • On the Domain Dashboard, click the New Receiver button



Step 2 - Filtering the Receiver List

  • In the filter input field enter, generic



Step 3 - Selecting a Receiver

  • Click the GenericSQLInsertReceiver or the + icon



Step 4 - Name the Receiver

  • A default name is automatically assigned to the Receiver; it is the name of the Receiver
  • Unless you're going to the assign the same Receiver to a given Domain more than once, leave the default name
  • Click the Save button



Step 5 - Modify Receiver Parameters

  • Set the databaseName parameter to alpha
  • Set the tableName parameter to user
  • Click the Save Generator button



Step 6 - Modify Receiver Attribute Property Keys

Each Receiver defines its own set of Attribute Property Keys that are used by the Receiver to morph values generated by each of the Domain's Attributes.  

  • Click on the Attributes Property Keys tab



Step 7 - Set the columnType for id

Each Attribute columnType Attribute Property Key must be set to type for successful SQL insertion.

  • Click on the id Attribute under the label - Attributes for GenericSQLInsertReceiver
  • Change the columnType Property Key value from String to Long
  • Click the Save button

 


Step 8 - Set the columnType for activationDate

  • Click on the activationDate Attribute under the label - Attributes for GenericSQLInsertReceiver
  • Change the columnType Property Key value from String to Date
  • Click the Save button



  • Click the Receiver Property to Preview All Changes



Step 9 - Add a GenericSQLInsertReceiver to the GrantHistory Domain

Using the two images below, follow steps 1 through 8 above, add the GenericSQLInsertReceiver to the GrantHistory Domain.


Set Receiver Parameter Settings

  • Set databaseName to beta
  • Set tableName to grant_history
  • Click the Save button

 


Set Attributes Property Keys 

  • Change grantAmount's columnType from String to Float
  • Change grandDate's columnType from String to Date
  • Change id columnType from String to Long
  • Don't forget to click the Save or Save & Next button after each Change



Step 10 - Add a GenericSQLInsertReceiver to the NotificationSetting Domain

Using the two images below, follow steps 1 through 8 above, add the GenericSQLInsertReceiver to the NotificationSetting Domain.


Set Receiver Parameter Settings

  • Set databaseName to beta
  • Set tableName to notification_setting
  • Click the Save button



Set Attributes Property Keys 

  • Change failureRate's columnType from String to Integer
  • Change frequencyCount's columnType from String to Integer
  • Chante hitRate's columnType from String to Integer
  • Change id columnType from String to Long
  • Don't forget to click the Save of Save & Next button after each Change



Move onto the next lesson >