There are various requirements on test data management. Test data for acceptance, performance, regression and integration test environments are naturally bulk data, they are usually provided from a production or a pre-production environment. BCV4 and BCV5 have proven to be as highly efficient, robust and broadly automated solutions.

BTO for Developers
Developers ordinarily do not need bulk data. Test cases for functional tests comprise of a few records. The challenge is more in the fields of relational integrity of the involved tables, the ability to import data from other environments, platforms and DBMS’, the possibility to easily edit or convert data fields and change table structures. Displays of table relations and constraints can help to analyze the consequences of masking requirements and subset selections. BTO addresses the demands of developers to integrate new test cases, to create, modify and edit test data.

BTO is a java-written workstation program that allows you to build test data on the workstation as well as directly at a target DBMS. The program is able to fetch data from any DBMS. To move bulk data it interfaces with BCV5/6.

BTO supports developers to easily create test case data as subsets of production tables. Selection rules to various tables are appropriately joined. BTO considers relational dependencies (parent/child) as well as constraints and ensures the proper sequence of the execution.

BTO helps with analysis of masking demands and ensures uniform masking of related columns, pre-defined functions, DBMS functions as well as user programs are supported.

Cross DBMS constraints are supported. Thereby, it is for example possible to access excerpts of master data under IMS and to complete test cases with key-related transactional data under DB2 and vice versa.

BTO offers graphical displays of Database/Table/Columns dependencies and process chains. This facilitates analysis and assessment of anonymization intentions or generation of subsets.

BTO comes with an efficient script language. Project definition, modification and execution is possible via scripts or panels (windows).

BTO provides pre-run checks of data types and conversions, it warns about loss of precision and possible SQL errors, its preview function displays the generated statements, the sequence of execution, etc. more»