DataTurn: Automated Mainframe Database Migration

Automated Data Stores Conversion

DataTurn is a powerful tool that provides automated transformation of data structures and conversion of data from legacy data stores to relational databases – running either in the Cloud or on premise. It helps liberating valuable business systems from their dependency on non-strategic, legacy and often costly technologies.

Product Highlights

• Supports a variety of source and target data stores
• Easy-to-use graphical interface
• Command line interface for automation and scripting of bulk processes
• Customization via a template based approach
• Mass configuration via export/import
• Mainframe EBCDIC to open platform ASCII solution

> Download the DataTurn Fact Sheet

‍

Source & Target Data Stores

DataTurn supports the migration of following data stores. For each data storage technology, all key functionalities are mapped to equivalents in the target RDBMS.

DataTurn is also used for migrating other data stores, but only in the context of a full Astadia migration project.

Target RDBMS

DataTurn supports all market-leading RDBMS vendors (Oracle, SQL Server, DB2, PostgreSQL) giving customers the flexibility to choose the product most suited to their needs and standards.

The internal DataTurn repository can also be stored in one of the available RDBMS targets, in its own database or schema. As an alternative for RDBMS targets, DataTurn supports migration of ISAM/VSAM files to files with compliant formats on open platforms, including EBCDIC to ASCII encoding translation.

‍Easy to Use‍

DataTurn visualizes the original source descriptions and resulting target descriptions. Configuration changes can be checked immediately.

How It Works‍

The DataTurn migration process always consists of following five steps, irrespective of the source and target technologies:

• Upload the structural data definitions into the DataTurn Repository
• Configure the migration mappings
• Generate data migration programs and target RDBMS scripts
• Setup the target RDBMS
• Run the data migration programs

‍

‍DataTurn Add-on Services‍

As a standalone product, DataTurn enables data migration to a modern RDBMS. On top of that and extensively using DataTurn, Astadia can provide full migration project services, including:

• Generation of data access layers
• Generation of extra trigger logic
• Conversion of data access statements in code

Three Strong Promises

‍All Functionality is Mapped

‍Not only the application data itself is being dealt with, but all aspects on which application code can depend, such as implicit key fields, implicit set order etc., are made available in the target RDBMS.

‍Data Integrity is Preserved

‍Two independent mechanisms are provided to verify data integrity:

• The data migration programs generate full statistics on the original (unloaded) and target (loaded) data stores.
• Independent data verification programs can get generated too, to dump the data from both the source and target data stores in a format that allows easy comparison.

‍Data Availability is Ensured

‍The latest IT development tools on the market are optimized for quick data access and rapid development on databases. The development of Java, .NET, or other Internet applications will be speeded with the availability of native APIs and programming tools for data access. Because the migration to an RDBMS provides an application with a clear separation of its data-layer, it allows organizations to implement a modern client/server or three-tier networked applications architecture in one easy process.

‍