Creating a Data Allocation Pool

Read the section Core Concepts before you start creating your allocation pools.

From the left-hand side menu, select ‘Allocation Pools’ from within the ‘Test Data Management’ tab, this will pull up a list of existing allocation pools. Click on the pool name to see the allocated tests in pool.

To create a new pool, click ‘New Pool’ and enter a unique Pool name and link the Pool to a Test Data Catalogue from the list.

You will now be able to create new allocated tests to assign to the allocation pools.

Creating a New Allocated Test

Now you have set up an Allocation Pool, click on ‘New Allocated Test’ to set an Allocated Test up. The popup below will show, you will need to specify fields for the details, configuration, parameters and expected results sections.


Test Name: Enter a Test Name, the Test Name must be unique within the Suite.

Suite Name: Choose from existing Suite Names or enter a New One. Test Names are unique within a Suite.

Test Criteria: Pick from the drop-down list.

Tags: You can enter Tag names here, use Tab to create as many as you like. The Tags can be used to filter your allocation pools later.

Below is an example of a new Allocated Test:


Click the ‘Configuration’ tab, the following screen will show:

How Many: Enter how many allocated values you would like. This will default to whatever has been set in the definition of the test type.

Unique:  Do you want the allocated value to be just for this test only? If it is not set other tests may use the same allocated value.

Prep environment: You can set up the data allocation to run jobs to prepare the data environment before the automation framework is run. Set this if this is a stand-alone piece of SQL to be run prior to the automation.

Below is an example of a new Allocated Test:


Click the ‘Parameters’ tab, the following screen will show:

The parameter values will come over from the Parameters associated with the Test Type definition. You can fill these in with the required values to lookup the data you need for this specific test.

Below is an example of a new Allocated Test:

Expected Results

Click the ‘Expected Results’ tab, the following screen will show:

Create Allocated SQL Test EXPECTED Results

You can pass down values into the automation if you wish that can be used as the expected results.

You have now created an Allocated Test.

Running the Data Allocation

To test or run the allocation directly from Test Modeller, rather than as part of an automation framework you can filter the allocated tests. Click on the filter button and choose the tests you want:

Then, execute this test, choosing the server that connects to your system under test databases and applications.
Pick the job Data Allocate and click execute. This will submit a job to try and run the allocated tests you have defined for the filters you have chosen and is a good way to test that your criteria have been defined correctly.

Once the test has run, the run results will show:

Click to download this log and open it in an editor. Look through this log in detail, especially the first time you are running the allocate for a test type. An example log is shown below:

An example SQL:

SQL=select top 500 CAST(id as VARCHAR(100)) from dbo.OPPORTUNITIES where ( (Opportunity_Type = ‘Existing business’ OR ‘Existing business’ = ”) and (Sales_Stage = ‘Needs analysis’ OR ‘Needs analysis’ = ”) and (Lead_Source = ‘Existing customer’ OR ‘Existing customer’ = ”)) and (CAST(id as VARCHAR(100))) not in (‘2EFCE793-2207-4798-ADB9-004B558D4B9A’)

2019-10-23 16:48:10-varSQlResults.count = 81 varI=3

If there is a problem with the SQL it will show up in here. You can then adjust the definition of the Test Type and retry running the allocation.

Next, return to the allocation pool and check the results are correct:

If you click on the results button, it will show you the found values:

If you click on the allocated test you will get further details:

Running Data Allocation 7

You have successfully run an allocated test.