Home / Products / Infinite DataLink
Infinite DataLink · Add-on to Infinite i

DB2/400 to MySQL. Without losing a row.

Migrate IBM i (DB2/400) data — including physical files, logical files, referential integrity, indexes, and stored procedures — to MySQL on AWS, Azure, or Google Cloud. Run alongside Infinite i platform migration, or as a standalone data project.

See MySQL targets supported
Source → Engine → Destination
Source
DB2/400
IBM i · Power Systems
CUSTMSTPF
ORDDTLPF
INVMSTPF
CUSTBYZIPLF
Migration
Engine
w/ referential
integrity
Destination
MySQL
AWS RDS / Aurora
customer_masterTBL
order_detailTBL
inventory_masterTBL
customer_by_zipVIEW
100%
Referential integrity
EBCDIC
→ Unicode handled
0
Application code changes
MySQL
AWS, Azure, or GCP
Real-time · bi-directional

The same data on both sides — DB2/400 and MySQL, in sync.

Infinite DataLink connects Infinite DB — a complete replication of DB2/400 running on Linux inside the Infinite i runtime — to MySQL. It translates EBCDIC to ASCII and maps DB2/400 physical files to MySQL tables and logical files to views. The data is viewable and editable from either side, in real time and in both directions — so an update in MySQL flows back to the application, and an update on the IBM i side appears in MySQL.

DSPPFM FILE(CUSTMST)DB2/400
 
CUSTNO NAME BALANCE
001024 ACME DISTRIBUTION 4,820.00
001037 BERG SUPPLY 1,285.50
001052 CARTER & SONS 690.25
001066 DELTA FOODS 7,560.00
 
EBCDIC · physical file
MySQL

customer_master

Linux · utf8mb4 · live table
cust_nonamebalance
001024ACME Distribution$4,820.00
001037Berg Supply$1,285.50
001052Carter & Sons$690.25
001066Delta Foods$7,560.00
EditablePower BI ready

EBCDIC → ASCII  ·  physical files → tables  ·  logical files → views  ·  real-time, bi-directional sync

Both directions, live

Edit on the IBM i side or in MySQL — changes reflect on both sides in real time, not as a nightly batch.

EBCDIC to ASCII

Character translation is automatic, so the data reads correctly the moment it lands in MySQL.

Physicals & logicals mapped

DB2/400 physical files become MySQL tables and logical files become views — no manual schema work.

Connect your BI tools

Query the live data straight from MySQL with Power BI on Azure, Tableau, or any standard SQL tool.

Supported deployment targets

MySQL, wherever you want to run it.

We migrate DB2/400 to MySQL — fully and only. That focus is deliberate: MySQL is the most widely deployed open-source database on Earth, runs natively on all three major clouds, and gives you a clean, well-understood target. Wherever you run MySQL, that's where your IBM i data can live.

Amazon RDS

Managed MySQL and Aurora MySQL-compatible on AWS, with automated backups and read replicas.

Azure MySQL

Azure Database for MySQL Flexible Server, with high availability across zones.

Google Cloud SQL

Fully managed MySQL on GCP, with point-in-time recovery and automatic scaling.

Self-managed

MySQL on your own VMs, on-prem or in any cloud, fully under your control.

Why it works

Built for production-grade DB2/400 → MySQL migrations.

Native DB2/400 types, mapped to MySQL automatically.

The migration engine understands DB2 for i data types and maps them to their correct MySQL equivalents — without manual schema rework or guesswork.

  • Packed and zoned decimals mapped to MySQL DECIMAL with exact precision
  • Physical files become tables; logical files become indexes and views
  • Referential constraints, primary keys, and foreign keys preserved
  • Stored procedures and triggers translated where supported
TYPE MAPPING
 
PACKED(11,2) ─► DECIMAL(11,2)
ZONED(7,0) ─► DECIMAL(7,0)
CHAR(10) ─► VARCHAR(10)
GRAPHIC ─► NVARCHAR
TIMESTAMP ─► DATETIME(6)
✓ 142 fields mapped, 0 errors

EBCDIC to MySQL Unicode, without losing characters.

IBM i stores data in EBCDIC. MySQL expects Unicode. The migration engine handles the conversion automatically — including the edge cases that trip up hand-rolled scripts.

  • Full EBCDIC → UTF-8 character-set conversion
  • Code-page aware: handles national language variants
  • Packed-decimal and binary fields decoded correctly
  • Null-capable and date/time fields handled cleanly
CHARACTER SET
 
EBCDIC CCSID 037
 │ convert
UTF-8 (utf8mb4)
 
"ÀCMÉ Distribución" preserved ✓

Migrate the data. Migrate the platform. Stay supported.

Infinite DataLink stands alone, but it's strongest as part of a full Infinite i platform migration: move your applications to native Linux and your data to MySQL together, and decommission Power.

Standalone — Migrate DB2/400 to MySQL while keeping apps on IBM i
Combined — Pair with Infinite i to move apps and data together
Validated — Row counts and checksums verified end to end
Power Systems
DB2/400 + RPG/COBOL
Linux + MySQL
AWS / Azure / GCP · fully supported

Try a sample migration this week.

Send us a representative DB2/400 schema or a sample of physical and logical files. We'll run them through the migration engine and return a working MySQL schema with a validation report — at no cost.

The Infinite i platform and its add-ons

Infinite i at the core — with add-ons for the interface, data, and developer experience.