IBM i (AS/400) Db2 Offloading: From Core Data to Modern Systems

• Language: Cantonese
• Format: Technical sharing, TapData walkthrough, and Q&A

IBM i systems continue to support many business-critical operations, while analytics platforms, modern databases, APIs, and digital applications increasingly require access to the data held in these core systems.
Repeated batch exports, direct database queries, and custom point-to-point integrations may work for individual requirements, but they can become difficult to maintain as the number of downstream consumers grows.
In this practical technical session, we will introduce the concept of Db2 for i data offloading, discuss where a CDC-based approach can help, and walk through how TapData can deliver continuously changing core data to modern downstream systems.

What you’ll learn

• Why organizations offload Db2 for i data, and where direct queries, batch exports, and custom integrations may become limiting.
• A practical data-delivery pattern for making IBM i data available to modern databases, analytics platforms, APIs, and applications.
• How a CDC-based offloading flow can continuously capture and deliver source changes without requiring downstream systems to repeatedly query the core.
• How TapData can be used to configure, run, and monitor an IBM i data-offloading flow through a short practical walkthrough.

Session outline

1. Why offload data from IBM i? Common scenarios where IBM i data is needed by analytics, reporting, modern databases, APIs, and digital applications—and why repeated access to the core can become difficult to scale.
2. Common approaches to IBM i data delivery A brief comparison of direct database queries, scheduled batch exports, custom integrations, and CDC-based offloading.
3. A practical Db2 for i offloading pattern A reference data flow for continuously delivering IBM i data to modern downstream systems while reducing repeated access to the core.
4. TapData implementation walkthrough How an IBM i source, a modern target system, and a continuous data flow are configured and managed in TapData.
5. Practical demo: From source change to downstream delivery See how a change made to Db2 for i data is captured and delivered to a modern downstream system, together with the flow’s running status and basic monitoring.
6. Q&A and discussion Bring your questions about IBM i data integration, CDC-based offloading, and downstream delivery scenarios.

Who should attend

This session is designed for:

• IBM i / AS/400 administrators, developers, and technical practitioners
• Data engineers and database professionals working with Db2 for i
• Data, integration, and solution architects
• Teams supporting analytics, reporting, APIs, digital applications, or modern databases
• Technology leaders exploring practical ways to make IBM i data available to more downstream systems

No prior experience with TapData is required.

About the community

Real-Time Data & AI Infrastructure by TapData brings together data engineers, architects, developers, and technology practitioners interested in real-time data integration, operational data infrastructure, database modernization, and practical data foundations for modern applications and AI.
The community hosts technical sharing sessions, architecture discussions, practical demonstrations, and conversations around real-world implementation challenges. Sessions are organized by TapData and may also feature customers, partners, and guest practitioners from across the data ecosystem.

About TapData

TapData provides a live data platform for continuously capturing, transforming, and delivering operational data across heterogeneous systems. It helps organizations make data from core databases available to modern databases, analytics platforms, applications, APIs, and other downstream consumers through CDC-based data flows. In this session, TapData will be used as the reference implementation for the IBM i Db2 offloading flow.

*Recording notice: This online session may be recorded for educational and post-event use. Participants will be informed again at the beginning of the session.