Test Data Management

"With the deadline rapidly approaching, it was imperative that we were ready on time and with zero defects. Using TestBench saved us time and got us there faster, giving us complete confidence for the future."

Andrew Clarke, IT Director, HMV Europe

Data is at the heart of any enterprise application and test data is the heart of a good test environment. Our Test Data Management solution will address the issues of disk space, data verification, data confidentiality and protracted test durations. Control and management of the test data ensures that every test starts with a consistent data state which is essential in maintaining your data in a predictable state at the end of the test.
Checking both visible test results and the database effects is a key principle of AQM (Application Quality Management), a task which is practically impossible to accomplish manually.

padlocked document file

What Are The Challenges of Test Data Management?

Test data is the static or transactional information that is used during the testing process. It is essential that this information accurately reflects the data that is, or will be, supporting your business.

The, all too common, practice of using a ‘copy of production’ introduces a number of issues that are solved by our solutions:

  • Size – Production databases are large. This means that you are limited to the number of test environments you can host. It also means it is harder for testers to find relevant data to test with and certain processes, such as Month-End procedures, can take a very long time to run. With so much data it can be hard to ‘see the wood for the trees’ when looking for issues.
  • Data Confidentiality / Security – With regulations such as HIPAA, and more recently GDPR, it is wholly inappropriate to use Personally Identifiable Information (PII) in a test data environment. Even if you are not subject to such regulations, it is generally accepted as a ‘best practice’ to deidentify sensitive information.
  • Missing Scenarios – Production data taken at a point in time may not necessarily cover all potential data scenarios and therefore tests may fail to uncover issues.

Solving The Challenges

TestBench, from Original Software, supports AQM with a suite that uniquely controls, tests and manages the data required for effective testing together with the server-side effects of the test.

Testing on live data is now a thing of the past with the creation of subsets that retain referential integrity, providing a perfect miniature copy of the live environment. When TestDrive is used in conjunction with sub-setting, specific scenarios can be created to support the testing.

Data scrambling and pseudonymisation, along with auto-analysis, data manipulation and extraction reports for auditing, means you can be confident your testing processes will be fully compliant with all regulatory controls.


crossword puzzle spelling compliance
robot ticking off checklist

The Benefits of Test Data Management

The main benefits of test data management are found in time saving and test coverage. If test data is easily and quickly available, then the overall QA life-cycle can be completed faster. This leads to a quicker route to market or more time for extensive testing thereby improving quality.

By using test data management, the data used is more accurate and this leads to more ‘live’ type defects being found before release and allows more realistic test cases to be used. If test data can be correctly cut down to include only the essential data, then more environments can be created to complete the testing without the need for expensive hardware upgrades.

How We Help

What Else

Related Articles


Better Tester and Developer collaboration

If your Oracle EBS validation processes are manual, there will be an unreasonable burden of time and effort on your business to replace.  Conference room pilots (CRP) and user acceptance testing (UAT) will be labor-intensive and draining.  Your EBS users

Read More »

Automating Infor M3 User Acceptance Testing

A short video on “How to Manage Change in a Highly Regulated Environment” This video will show you how to eliminate ‘paper’. Increase control & traceability, improve process management, maintain accountability, increase delivery speed, all while keeping our auditors happy.

Read More »

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