DataTurn: Automated Mainframe Database Migration

Automated Transformation of Data

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

‍

Source & Target Data Stores

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

The tool can be used for migrating additional 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) 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:

1. Upload the structural data definitions into the DataTurn Repository
2. Configure the migration mappings
3. Generate data migration programs and target RDBMS scripts
4. Setup the target RDBMS
5. Run the data migration programs

DataTurn Add-on Services

As a standalone product, DataTurn enables teams to migrate data to a modern RDBMS. On top of that, 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. Especially, 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 will provide your application with a clear separation of its data-layer, it will allow your organization to implement a modern client/server or three-tier networked applications architecture in one easy process.

Astadia has completed numerous data migration projects for IDMS, UDS, Adabas, ISAM, VSAM, LEASY, DPT data sources to Oracle, DB2, SQL Server and file targets. Each of these projects has been delivered on time, within budget and to the complete satisfaction of the customer. Get in touch with our experts to learn more about our automated migration and testing tools and how they can support your digital transformation journey.

‍

‍