XDM Cross Database Mover

Test Data Provisioning

XDM automates and simplifies the collection, provisioning and re-establishment of data for test cases from business cases or business objects. It is the perfect tool for developers and function tests.
XDM Row Level Processing

XDM automates the provisioning and the adaption of mass data for acceptance tests, regression tests and integration tests. These features are ideal for the test- and quality assurance departments.
XDM Table Copying

XDM automates and accelerates the supply and the refresh of a consistent pre-production. A pre-production as a clone of the production, decouples the production from the test- and development environments.

Conversion

The different DDL Syntax, diverse CSV-formats, LOBs and XML complicate the adjustment of an application from one DBMS to another DBMS type. Whether Oracle, SQL-Server, DB2, the DDL-commands differ considerably. The reliable transport of data with different data types and lengths handicaps an automatic processing. With XDM tables can be “copied” between different DBMS types.

Automation

XDM “copies” relational data. This means the integration of the data definition (DDL) and the data transfer into one process. An XDM task can be operated via a command line or by a scheduler. XDM can copy within a DBMS instance or between DBMS instances. The intuitively designed XDM-Workstation requires no specific previous knowledge of the particular DBMS. For the creation of a copy task the user has only to specify selection-, exclude- and renaming rules. Furthermore options concerning the handling of the data in the target environment must be defined (overwrite, replace, merge, etc…). The effort, required by conventional methods like preparation, execution and reworking (make usable) is reduce by 90% with XDM.

XDM compares the DDL structures between source and target and checks their compatibility, missing objects in target systems are created automatically. It is also possible to extract only the DDL of the source objects and to generate only an “empty” target system. XDM is restart-capable. When the copy process is interrupted, the seamless restart of the copy task can be executed exactly where it has been interrupted.
Copy tasks are autonomous and can be executed unattended by a scheduler. A platform independent script-language is available to generate and execute copy tasks, or to conduct considerable changes with existing tasks. 

show less