BTO allows developers to easily create test case data as subsets of production tables. Designed to meet the challenges of relational integrity of the involved tables, the ability to import data from different environments, platforms and DBMS, to easily edit or convert data fields and change table structures, it adresses the demands to create, modify and edit test data. BTO is a java-written workstation program with which you can build test data on the workstation or directly at a target DBMS.
The program is able to fetch data from any DBMS. 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. DBMS-defined relations are considered as well as other specs or repositories. As cross DBMS constraints are supported, 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 helps with analysis of masking demands and ensures uniform masking of related columns. Pre-defined functions and user programs for particular solutions are supported. It 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). It provides pre-run checks of data types as well as conversions and it warns about loss of precision and possible SQL errors. Its preview function displays the generated statements, the sequence of execution, etc. to ensure a smooth setup of new test cases.