The final phase for generating Synthetic Data is to run the .vip file with the associated configuration spreadsheet that was created previously and then following the steps below.  If you haven't started at the beginning, this is the link to begin: start at the beginning of Synthetic Test Data Generation. 

At this point, you should have already Created/Associated the Data Generation Configuration sheet with the associated .vip file.  If not, please see previous article.

  • Open VIP and create a new flow

  • Save the file (as in the location of the Configuration Sheet and the other relevant files.

  • Go To Tools->Accelerators->DataGeneration

  • Browse to the Data Generation Configuration sheet, Click Process (Make sure the Configuration sheet is closed before doing this).  The Configuration sheet is read which generates the flow to generate the data.

Set Argument Values

The Arguments are created by the user when the Database is created and should follow VB.Net naming conventions.

  • Once the flow is generated, you can look through the arguments section by selecting Arguments on the bottom of the screen.

    • Example (see image below): If we want to generate 2 Customers, we set paritem_Customer_ to 2 and if we want to generate 2 Products, we set paritem_Product to 2 and if we want to generate 2 Orders we set value paritem_Order_ to 2 and if we want to use 3 OrderItems, we set the value of paritem_OrderItem to 3.

Full List of Application SampleCommerce Arguments here:

Execute the flow

This section explains how to execute the VIP Flow which uses the Configuration spreadsheet to Generate Synthetic Data. [If you haven't Configured the Configuration Control sheet already, see section on Configuring the Configuration spreadsheet.] This process is described with regard to the SampleCommerce Database.

Examine the SampleCommerce Database before beginning

Before we execute this flow, let's look back at our database using the SQL Server Management tool, so that we can compare the added data after we execute our flow.

We can see in the screenshot of the first database query below that there are:

  • 27 Suppliers

  • 39 Products

If we look at the screenshot of the second database query below, we can also see that there are:

  • 32 Customers

  • 46 Orders

  • 45 Total Amounts

Next we Execute the data generation in VIP by going to menu Action->Execute in VIP.

Examine the Database for New Entries

 If we look again at our database, we can see the added database items. There is now 1 added Supplier and 2 additional products:

  • 28 Suppliers

  • 41 Products

If we compare the output of the second database query below, we can see that we have 2 new Customers, 2 new Orders and 4((2 new Orders)*(2 OrderItems)) new TotalAmounts which is what we specified in the Argument section of our flow.

  • 36 Customers

  • 50 Orders

  • 49 Total Amounts

If we look at the last 4 elements in the Order section, we can see that the last column has the same figure as the last 4 entries in the TotalAmount section thanks to our EventHook creation and specification. This shows how we used our business logic to enhance the test data that we wanted to create.

Eureka! We have now completed the process of Synthetic Test Data Generation.

Summary of the Data Generation Execution Process

  1. Look at the (excel) Database Data using SQL Database Manager before executing the flow

  2. Open the newly created Flow in VIP

  3. Go to Tools–>Accelerators–>Data Generation

  4. Execute Flow in VIP (the one that uses/(associated with) the Configuration spreadsheet)

  5. Look at the Database Data again using SQL Database Manager to confirm that the new Data was generated.