Row Level Processing

Setup test cases easily
To meet today’s IT objectives the software development life cycle must be shortened. Current software development methods, such as, Agile, require the reliable provisioning of test data. That‘s why it is necessary to establish a well-defined, automated procedure for the acquisition and migration of test data from production to test, QA, development, and training environments.

Most applications store information in relational databases. Complete copies of a production environment, also called clones, are often used for pre-production staging. These clones maintain the relational integrity of the source data. While these full copies are suitable for regression, user acceptance and performance testing, they may burden developers in earlier stages of testing with data volume and concerns of exposing sensitive information. Developers mostly require a small subset of the data, but this data must be made up of integral test cases. The major challenge is to extract the required rows from multiple tables, and to do so in a repeatable and dependable way that is at the same time easy. The extraction process must consider both, dependencies defined in the DBMS, and those that only the application knows about. XDM Row Level Processing excels at automating this selection and replication of test cases. It saves time, money, and technical staff effort.

XDM Row Level Processing has a repository that allows it to maintain the relationships that exist in the application logic. It uses this repository and information obtained from the source DBMS itself to find related data from parent and child tables to copy consistent test cases into the target system. Once the start values for the test case (customer name, contract number, etc…) are set, XDM Row Level Processing automatically detects which rows from dependent tables must be copied. The copy process itself is divided into multiple, repeatable steps and can be integrated into a scheduler quite easily.

Editing and Data Masking
XDM Row Level Processing is able to modify data while copying it. Personal, financial or medical data and other sensitive information can be changed before they are written into the target environment. This helps to implement a process that meets data protection regulations.


In addition, XDM Row Level Processing is able to handle structural differences between the source and target environment with ease. It is not unusual for a data model to evolve during a development process. If a new field has been introduced, XDM Row Level Processing can generate values for it while it is copying data. Changing data types are handled transparently. If the changes to a data model are more complex, it is possible to integrate scripts into the copy process.

XDM Row Level Processing can replicate the DDL of the environment and create completely new environments. The integrated structure comparison feature can also modify the existing target structures, and create missing objects. Since the copy process is rule based, the settings do not need to be modified if the structure of the objects change.

XDM Row Level Processing is a user friendly tool for extracting related data from a database system. It allows users to easily populate test, development, and other environments. XDM Row Level Processing saves resources while shortening the development cycle through efficient test case provisioning.