TestBench Data Validation

Track every database activity

Optionally include mid-point states

Set validation rules and warnings

Track every database activity. Create rules so that data failures are flagged to you automatically

Data is a core part of any IBM i application and data validation or looking at what happens to that data is a core part of testing. You may well be familiar with SQL statements that help you look at the end result of a test. What you really need to know is what stages a changed piece of data went through, where an error was introduced and by which process.

File Effects

Data Validation Rules


Database Effects

TestBench reports all the Inserts, Updates and Deletes that occur in a test data environment when a test is performed. Details of the operations are captured and in the case of an update, the before and after status of the data is shown. This provides an understanding of the data part of an application function and aids in the verification of the data changes.

Faster Result Validation

Database effects from two runs of the same test scenario are compared. Differences in the tables affected, the number of operations on a table and differences in individual data elements are reported. When used with TestBench Data Protection, this feature provides the ability to understand the differences between two versions of the same process.

Want to know more about IBM i Data Validation and how it could help your business? Why not book a slot with one of our technical advisers.

TestBench IBM i Modules

Solutions to cover every aspect of test data management

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

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

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

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

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.

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 data validation. 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