ADAMAGIC is a data extraction utility designed for Adabas databases, enabling DBAs to convert and transfer application data files from EBCDIC-based Adabas on mainframes to ASCII-based UNIX or Linux environments. It streamlines the process of accessing, converting, and managing Adabas data for migration, testing, or reporting purposes.

Key Features

Mainframe to UNIX Data Conversion Converts Adabas files from EBCDIC (mainframe) to ASCII (UNIX/Linux).

• Uses ADASAV backups from OS/390, Z/OS, or VSE to load Adabas C databases on UNIX.
• Supports conversion of all application data files.

Backup Tape Reading and Subset Extraction Reads Adabas backup tapes for data extraction.

• Reads UNIX ADABCK backup tapes.
• Creates data subsets for testing or reporting.

Flexible Output Formats Produces files in multiple formats for various use cases.

• Outputs compressed DTA/DVT files, flat ASCII, or CSV.
• Generates input parameters for ADAFDU file definition utility.

Automated Scripting Support Enables automation of post-processing tasks.

• Invokes UNIX scripts after file output.
• Supports automated file creation and data loading.

Selective Data Extraction Allows granular control over data and metadata extraction.

• Extracts ADAFDU information with or without actual data.
• Optionally extracts DTA without DVT.

Cross-Platform Compatibility Runs on multiple UNIX and Windows platforms.

• Compatible with HP/UX, IBM/AIX, Sun Solaris, Linux, and Windows.

Benefits

Streamlined Data Migration Reduces complexity and time required for Adabas data migration.

• Minimizes manual steps and overhead.
• Facilitates efficient transfer from mainframe to UNIX/Linux.

Enhanced Testing and Reporting Simplifies creation of test datasets and historical data access.

• Easily extracts subsets from backups.
• Supports reporting and test database population.