The BizDataX Portal provides a way to generate synthetic data to cover scenarios where production data may not be available. How to do that is described on this page.
Table of contents |
---|
Synthetic data generation |
Picture steps |
Video steps |
From version 5.0.0, the process of Synthetic data generation is also possible in the BizDataX Portal, just by following the steps through the Wizard.
Prerequisites for this example are:
Figure 1: Plans page
Figure 2: Create data masking plan
Figure 3: Wizard step 1
Click on the 'Next' button. Wizard step 2 is displayed.
Select the 'Masking category' dropdown for each Table column and select 'Generator outputs - basic'.
As 'Masking value' select the following options:
For the FirstName column - First name (User information generator)
For the LastName column - Last name (User information generator)
For the Email column - Email (User information generator)
For the CreditCardID column - Credit card number (Credit card number generator)
For Csc column - Random number in range (Number in range)
For the ExpirationDate column - Date (Date in range generator)
Figure 4: Wizard step 2
Figure 5: Generator details for CSC column
Figure 6: Generator details for ExpirationDate column
Figure 7: Wizard step 3
Figure 8: Wizard step 4
Click on the 'Finish' button. The plan overview page is displayed.
Right-click on the Job node and select the 'View job details'.
Figure 9: View Job details
The Jobs page is displayed. Click on the 'Edit job' button. The 'Edit job' pop-up is displayed. Click on the 'Advanced view' toggle button and set it to 'On'. The new field 'Settings' is displayed. A JSON needs to be used to define the number of records that will be generated (in this example, 100):
{"$type":"Ekobit.BizDataX.DataMasking.Interface.CompositeHandlerSettings, Ekobit.BizDataX.DataMasking.Interface","Ekobit.BizDataX.DataMasking.Interface.BulkCopySettings, Ekobit.BizDataX.DataMasking.Interface, Version=4.4.0.0, Culture=neutral, PublicKeyToken=null":{"$type":"Ekobit.BizDataX.DataMasking.Interface.BulkCopySettings, Ekobit.BizDataX.DataMasking.Interface","BatchSize":200000,"TableLock":null,"KeepIdentity":null,"Timeout":5400},"Ekobit.BizDataX.DataMasking.Interface.InsertSettings`1[[Ekobit.BizDataX.DataMasking.Interface.TableRecord, Ekobit.BizDataX.DataMasking.Interface, Version=4.4.0.0, Culture=neutral, PublicKeyToken=null]], Ekobit.BizDataX.DataMasking.Interface, Version=4.4.0.0, Culture=neutral, PublicKeyToken=null":{"$type":"Ekobit.BizDataX.DataMasking.Interface.InsertSettings`1[[Ekobit.BizDataX.DataMasking.Interface.TableRecord, Ekobit.BizDataX.DataMasking.Interface]], Ekobit.BizDataX.DataMasking.Interface","NewItemsCount":100,"NewItems":null}}
Click on the 'Confirm' button.
Figure 10: Edit Job - Settings
Figure 11: Publish plan
Figure 12: View package
Figure 13: Execute package
Figure 14: Execution complete
BizDataX Documentation © Built by Ekobit. All rights reserved.
https://www.ekobit.com/ https://bizdatax.com/ https://bizdatax.com/support/