Table of Contents:

Setting up Data Allocation on your Server


To use Test Data Allocation, you will need an intermediate understand of SQL and a good level of knowledge in both Test Modeller and VIP RPA.

There are three pieces of required software:

  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.

You will also need to download the VIPTDM file to access the Test Data Allocation files. Please contact support for this.

Data Allocation Setup

To begin to use the Test Data Allocation capabilities, you must first set up data allocation on your automation server.

First, navigate to the Test Modeller workspace you want to add data allocation to and find 'Automation Servers' in the menu on the left hand side. Click to edit the 'BIGONE' row.

Set the server file to 'AutomationControllerMasterTemplateConfig.xlsx' to update the available jobs on that server.

To include Data Allocation and Preparation you will need to make some changes to the file itself.

In 'c:\viptdm\dataallocation' find 'AllocateServerExample.xlsx' and open it, this contains the additional entries you need to add into your master control spreadsheet.

In the Flow tab of this spreadsheet, copy in the following (the rows in black may already exist):

In the Parameters tab, copy in the following (again, the rows in black may already exist):

In the AutomationConfig tab, copy in the following (once again, the rows in black may already exist):

If you wish to add data allocation to any other processes, in the PrepareTestData tab, copy in the following:

Core Features and Benefits

Test Modeller provides the ability for Manual Testers and Automation frameworks to find and make data and most importantly, to allocate the found data to tests.

The Core Features and Benefits:

  • The utility will hunt for the correct test data in back end databases, via APIs, the application (front end) or by parsing files, this data is then allocated to specific tests.

  • If data cannot be found, VIP can run automation to make the missing data, either directly into your testing databases, via an API or through the front and back end applications.

  • VIP can call other tools as part of the preparation framework.

  • It is easy to create standard queries that can be used by multiple teams, these queries are then linked to tests and used to test specific parameters.

  • Tests can request a unique lock on data that will be transacted against, therefore, no other test can use that data.

  • Any existing matched data will be checked to see if the data is still valid. Does it still match the data requirements?

  • Matching data can be identified from different back end databases, allowing for cross-system integration.

  • Multiple rows of data can be allocated to any test.

You can also use VIP to manage the pools and catalogues. Within VIP, select 'Testinsight – TDM' to view all the actions: