Creating and managing IBM i test data

Stop copying the entire live database and hone in on the data you really need. Select or sample data with full referential integrity preserved

Our clients

Driving technology for leading brands

Getting suitable data

Use production data

One of the first tasks when building a Test Environment is the provision of suitable test data. Typically, test data is taken from, or based on, production data, with a full copy of production data the most common solution.

Representative cross-section

TestBench’s Data Extraction module vastly improves this process by enabling you to select the data you need and sample critical transactions to get a representative cross-section of data.

Referential integrity

TestBench allows you to maintain the referential integrity of the data, even if the relationships are not explicitly defined in the database.

Quickly repeat tests

Minimize testing time

Being able to repeat quickly and easily all or part of a test with the same data is essential if you want to minimise the time taken by testing. Rather than performing lengthy backups and restores, TestBench’s Environment Protection (Data Reset) module enables you to set data checkpoints, either manually or automatically, at pertinent points in your test cycle. If you need to repeat part of a test at any time, you can simply roll the test data back to a previous checkpoint to set the data back to exactly how it was at that point in time.

No need to restore data

This saves an immense amount of time by removing the need to restore data and repeat large chunks of testing just to get to the desired point. And, of course, you can undo all the changes to get back to where you started if you wish to run the complete test cycle again.

Developer and unit testing

Data sandbox

For those of you involved in developing and unit testing, TestBench also provides a data sandbox, call Program Reference Data Protection, which means you can always run unit tests with the same data without needing to create Checkpoints and issue Rollbacks. This also means that several developers can work with the same data without affecting each other’s work.

TestBench_Logo2020_main_fullcolor_transparent 400x135

Stop copying the entire live database and hone in on the data you really need. Select or sample data with full referential integrity preserved

Files and Tables

Quickly and easily model the relationships between the files and tables in your database

Determine criteria

Specify selection and sampling criteria to extract the data you require

Manage duplicates

Reference a file or table more than once during an extract, with TestBench taking care of potential duplicate records

Data subset

A much smaller, more manageable set of test data that has everything you need for testing, be it unit, system or regression

TestBench IBM i Modules

Solutions to cover every aspect of test data management

Data Extraction

Stop copying the entire live database and hone in on the data you really need. Select or sample data with full referential integrity preserved.

Data Masking

Simply decide which fields need to be protected and use a variety of obfuscation methods to protect your data.

Data Validation

Track every insert, update and delete including intervening data states. Create rules so that data failures are flagged to you automatically.

Data Reset

Avoid the painful save/restores and stop attempting to explain bad test results based on poor initial data.

File and Report Compare

Comparing outputs is a well proven method to verify your test results but it is laborious and prone to error.This unique solution can save hours.

Unit Testing

Get under the covers and analyse at a program/module level what happens in the database, APIs, parameters, messages and beyond.

We understand

We understand the challenges associated with creating and managing test data. So why not reach out to one of our advisers and explore the options available.

We are sorry to tell you that using Internet Explorer as your browser won’t give you the best experience of this website.

To get the best value visit us via Chrome, Edge or Firefox