DB2

TESTBASE (formerly Data Generation Facility)

TESTBASE provides generation of RI intact sets and subsets of DB2 data for testing, allowing developers to control their own 'slice' of the data with no impact on other users.

TESTBASE allows you to:

• Extract, move, edit, and create data to match specific developer needs
• Mask and manipulate sensitive data for data protection regulation requirements
• Migrate referentially-intact data sub-sets for comprehensive testing
• Create referentially-intact test data from scratch or randomly, including many-to many relationships
• Easily ‘Slice’ data into developer-specific portions to simplify true regression testing
• Access and Edit DB2 data tables easily—without complicated SQL
• Create entire testing environments with DB2, VSAM, and QSAM support
• Edit, ‘ Slice’ and Migrate from remote tables via IBM’s Distributed Data Facility
• Process site-specific needs with custom written user routines
• Compare all ‘before’ and ‘after’ tables involved in a test at once

Cost
Most application developers spend more time creating test data than you may realize. In some instances, building complex sets of relational test data may occupy the majority of a developer’s time. TESTBASE provides data extraction and creation tools that provide developers with a "one click" data creation solution. By removing a manually complex, error-prone and time-consuming process from the development cycle, programmers are able to streamline application development — reducing expenses while significantly improving productivity.

Flexibility
SoftBase’s Patent Pending ‘Slice’ technology provides the necessary tools to separate and manipulate data for specialized testing needs. Data can be easily "sliced" into specific and consistent sub-sets for testing or entire data tables can be edited and manipulated—without requiring knowledge of DB2 editing or specialized training. ‘Slice’ technology allows you to make much smarter use of your test environment and will significantly reduce the amount of storage required for test data.

Security
One common method developers use to create complex sets of test data is to extract information from corporate databases, creating working test beds of information. However, typical application testing procedures will duplicate and distribute test data—causing a broad distribution of potentially sensitive corporate and customer information.

TESTBASE provides data extraction capabilities that create, mask, and manipulate data in order to protect sensitive information—such as healthcare patient records or customer credit information—while maintaining a comprehensive set of data. This satisfies your security and privacy requirements by leaving secure information in your most secure environment; production but relevant and consistent data in test.

Referential Integrity
Test data becomes a real obstacle when Referential Integrity (RI) is required. Many applications use complex inter-relationships of data, and if the test bed fails to provide the appropriate references, it becomes virtually impossible to test the application. TESTBASE uses existing DB2 data, automatically extracting all of the relevant data tables – with referential integrity intact and without complicated SQL.

Resource Optimization
TESTBASE allows you to extract a complete sub-set of your production data to test - instead of copying the entire production table - creating perfect copies of all data, including referential data tables if necessary. The result is a significant savings of time and effort, and a savings of of valuable DASD space.

For QSAM and VSAM data, the traditional method of creating test data is to strip the first 100 records from a production file, and manually edit data to match the specific needs of the application being tested. TESTBASE removes the need for this laborious process by automating the creation of tailored test data sets for DB2, QSAM, and VSAM.

If you are currently a user of PST's MOVE, COMPARE or ACCESS products and would like to know how easy it is to move to TESTBASE or you would just like further information Click Here.

 

To request further information please Click Here or download the attached document