The test data challenge

Getting it, masking it and re-using it.

How do you go about obtaining data for testing.  There are only so many ways…  

  • Full restore or copy of production
  • Extract data subsets via SQL or via a tool
  • Copy records
  • Generate via a program
  • Enter transactions through the business application
  • Manually enter data via your favorite data utility

Which method(s) do you use? Each approach has advantages and disadvantages and  some are certainly more manual than others.

Whichever route is taken it does take time and effort to obtain the data for testing.  If you are using live data, which many do, then there is the added task of anonymization or obfuscation.

It comes as no surprise to hear that for some it takes more time to prepare the data environment than it does to actually execute the tests.

Furthermore, once the testing is executed, the data either gets used up or corrupted. Then it’s back to repeating the task of obtaining more data.

But what if you could obtain the data you need in a more efficient manner?

What if you could easily mask the data and keep compliant with the stringent privacy laws?

What if you could roll back and reset your data for use again, and again?

Sound appealing?  Well its easily done with proven modules of TestBench, the market leading test data management solution for IBM i. Why not talk to us and explore the ways you can solve your test data challenges.

Richard Carbray is a Solutions Consultant at Original Software.

Share on facebook
Share on twitter
Share on linkedin