Test Data Management

"Data is at the heart of any enterprise application
and test data is the heart of a good test environment."

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.

Triggers, join logical files, constraints and data areas are all automatically created in your target environment or IASP.

When you execute choose your data source on your local IBM i or within an IASP. You can also select any remote IBM i and once the extraction is complete the data will be automatically sent to you test environment.

Data Scrambling

Everyone knows that confidential data should never be used in a test environment but outside of tightly regulated industries it is common.

But the game has changed. GDPR and other legislation means that data confidentiality is no longer a choice.

Now simply decide which fields need to be protected and use a variety of obfuscation methods to protect your data. You can even synchronise your scrambling across multiple files.

Good, representative, clean test data is a precious asset but is quickly burnt through use or damaged by failed tests.

Now you can avoid either the painful save/restores and you can stop attempting to explain bad test results based on poor initial data.

Simply set a Checkpoint each time a transaction or set of transactions has been completed and simply return to this point if subsequent tests fail. We even handle the stuff that IBM doesn’t !

UI testing, examining API and batch outputs is great, but leaves a massive hole. What if the database is corrupted?

The challenge is that verifying the database is difficult, requires deep SQL skills and can only look at the final data state.

Now you can track every insert, update and delete including intervening data states. Even better you can create rules so that data failures are flagged to you automatically.

Stop buying DASD, Stop long-running data copies, Stop using data that is out of date. Get current!

Get GDPR compliant, protect your data assets and easily adopt best practice.

Data corruption can bring your company down but the database is the thing least tested. Now you can bring data to the heart of your testing.

Information Zone

Data Extraction

Learn how to efficiently extract the relevant data from your live database.

Checkpoints and Rollbacks

Test data is a precious asset. Learn how you can use it again and again.

Data Scrambling

GDPR is here to stay and data confidentiality always needs to be preserved.

File Effects and Data Rules

See how the database has been altered during a test and set data validation rules.

Data Strategies for Application Testing

This best practice guide explores strategies and techniques which have been used to improve both test efficiency and software quality for applications based on IBM i Databases