Overview

Data Migrator is an agnostic tool capable of creating database objects such as databases, schemas, and tables from ready-to-execute SQL scripts for the target database. It can also populate these objects with data from provided data files.

I/O Support

Input

• Data files: Data Migrator supports a variety of source data file-based systems, including CSV, EBCDIC, and QDDS. These data files are extracted by customers from their legacy databases to populate the migrated databases.
• Configuration files: These files allow users to configure the target database credentials, which can also be secured in AWS Secret, to ensure a successful connection for the Data Migrator tool. Additionally, the configuration files define multiple steps to orchestrate the end-to-end migration process, from creating the database objects to converting and migrating the data.
• Modernized SQL files: The tool requires ready-to-execute SQL scripts generated from the modernization of DB2 DDL, IMS DBD files or AIM/NDB ADL schemas using Blu Age transformation engines. It is important to note that IMS and AIM/NDB only supports PostgreSQL as the target database platform.
• SQL Model JSON: File representing the DB2 or IMS metadata. It helps Data Migrator determine how to convert certain columns during the data loading process.

Output

• Data Migrator supports the following target database platforms:
  • PostgreSQL
  • Oracle
  • SQL Server
  • DB2LUW (Linux, Unix, Windows)
• CSV Report: A report that provides metrics and status information regarding the executed scripts, as well as the number of records that were loaded.
• Log File: Logging execution of each migration step.