IBM i Database Testing

System, integration, and regression testing

Report on all Inserts, Update and Deletes

Significant time-savings

Trusted by companies worldwide

Database Testing

The database is arguably the most critical part of any application. If the data is wrong or corrupted, then the system will not function as expected.

TestBench provides features to help test at the database level when testing, whether unit, system, integration or regression testing.

Data Rules

Specify rules

TestBench’s Data Rules module enables you to specify rules that are then applied to any addition or modification of data

Specify data formats

You can specify a format for data, such as a date format, provide a list of allowed values and even check across files and tables, such as ensuring a product code exists in the product table or that an order total is the sum of the associated order lines.

Report failures

Any rule failure is reported as part of a test run result, showing the rule and the data value that has failed validation.

Database Effects

Report on all Inserts, Update and Deletes

TestBench’s Database Effects module will report on all Inserts, Update and Deletes made to files and tables in your database, including reporting on transactions that have been committed or rolled back while under commitment control. This is invaluable when trying to understand what effect a particular program or module within your application does and is great for unit testing.

System, integration and regression testing,

Compare the current database activity with a defined baseline, often the previous test run. Report on differences at a file, record and field level, so that you can be sure that the application is still performing as desired.

Significant time-savings

No need to perform queries to validated the database, no need to to define which files and tables , meaning massive time savings.

IBM i Test Data Management- A Best Practice Guide

Understand the key principals and techniques relating to test data environments on the IBM i, IBM iSeries & IBM AS/400.

TestBench IBM i Modules

A comprehensive, proven test data management, verification and unit testing solution that  integrates with other solutions for total application quality.

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 database testing. 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