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

Track every insert, update and delete operation
Optionally track multiple activity on a single record
View Before and After record images
Search by values
Track all activity for a Relative Record Number (RRN)
Track all activity for a selected field

Data Validation Rules

Check for data presence and changed values
Check for specific values
20 validation operators
Standard field types supported
Check values across file with SUM and EXISTS
Optionally alter data during extraction

General

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

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.

My location

By Industry

By Solution

By Application