The Cross Data Mover

The relational database technology has established itself company-wide. Huge, permanently growing data amounts are managed with Oracle, SQL-Server, Db2 and other relational databases. There are many reasons why it is necessary to transfer the data stock on a regular basis. Development, quality assurance,  data warehouse and other areas require data. As a result database administrators must spend a lot of time on the preparation and execution of data transfer and data provisioning. XDM simplifies, automates and accelerates the preparation and execution of data transfers in all areas of the datacenter.

XDM Overview Grafik 410px

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 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 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.

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.

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.

XDM´s copy program works in the multi-thread mode, this means it copies several tables at a time, in parallel. XDM supports:

  • Db2 for z/OS, Linux and AIX
  • Oracle for Windows, UNIX and AIX
  • Microsoft SQL-Server