Data Validation for IBM i

Trusted by companies worldwide

i4i400quality-data-validation-module-TestBench-image-01

TestBench Data Validation

Track every database activity

Optionally include mid-point states

Set validation rules and warnings

TestBench Data Extraction

IBM i Data Validation Overview

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

General

Alternative File Description support

Sample data support

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 consultants.

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 can be 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.

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 can be 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.