Synthetic Test Data Generation Prerequisites

Search Knowledge Base by Keyword

< Back

Before discussing specific prerequisites for Synthetic Data Generation below, it is very useful for the user to have familiarity with VIP (Visual Integration Processor) created by Curiosity Software.  If you are not familiar with VIP, please see the VIP documentation describing the purpose, function and uses of VIP, otherwise continue reading.

A Database should have already been created that models the application through a set of Tables and their relationships to one another. This is the target Database/schema/tables into which data will be generated.

Supported Database Types

  • Sql Server
  • Oracle
  • My SQL
  • Postgres
  • MS Access

To use Synthetic Test Data Generation, you will need a basic understanding of SQL and Microsoft Excel, and a good understanding of the underlying application database model.

The prerequisite hardware/software for Synthetic Test Data Generation:

  1. You must be running a 64-bit Windows machine. Windows 10 is strongly recommended and is required for the full range of functionality.
  2. The latest 64-bit version of Microsoft Excel.
  3. The latest version of VIP RPA. Information on prerequisites and installation can be found here, and licensing information here.

Once you have installed the prerequisite software on a 64-bit Windows machine, you will require licensed access to the relevant Test Data Managment utilities.

Copying Requisite Files into the Synthetic Data Generation Folder

    • The VIP flow file such as SampleCommerce.(.vip) for which data is to be generated.
    • Any associated flows that link to the main flow file (in the case above,
    • The dynamic link library (.dll) for the Flow file which in this example will be SampleCommerce.dll.
    • The Data Generation Configuration Sheet, DataGenConfigSampleCommerce.xlsx (excel file) is created in the process and stored in the same folder.