Contact Gamma Soft

Real-Time4 DB2 AS/400, a real-time solution to integrate DB2 database on the data’distribution technology

Real-Time4 DB2 AS/400 is the solution for real-time integration of DB2 data dedicated to the IBM AS/400, iSeries and Power System i systems.

Real-Time4 DB2 AS/400 allows data exchange in real-time between IBM AS/400-iSeries-Power i and other databases.

Real-Time4 DB2 AS/400 enables real-time data exchanges between IBM AS/400-iSeries-Power i and any other database


Real-Time4 DB2 AS/400 is designed to easily and securely replicate either the updates (via the CDC technique - Change Data Capture) or the content (via extraction) of AS/400-i5 database files to other systems: Microsoft SQL Server, MySQL, Oracle database, IBM AS/400-iSeries-Power i, PostgreSQL, Sybase ASE, Progress OpenEdge, ODBC, XML, text files, applications, ERP, etc., whatever the operating system (Windows, OS/400, i5/OS, UNIX, etc.).

 

 

The capture of the updates is based on the transactions log


The capture of updates, in CDC mode, of files on the AS/400-iSeries-Power i database is based on the transactions log. Real-Time4 DB2 AS/400 can select, transform and aggregate data on the fly, and apply all the updates performed on the tables - either in real time or deferred mode - on one or more targets (Oracle database, Microsoft SQL Server, IBM AS/400-Iseries-Power i, Sybase ASE, DB2, MySQL, PostgreSQL, ODBC, applications, ERP, etc.).

Given that the entire selection and transformation process is run on the source machine in PUSH mode, only the data you require is transferred - in the required format - to the target machine, which can also perform transformations on the fly.

 

The selection-transformation module can call all existing programs on the machine, whatever their source language, thus enabling you to reuse existing management rules.

 

 

Real-Time4 DB2 AS/400 is based on the data'distribution technology


Based on the data’distribution technology, the Real-Time4 DB2 AS/400 architecture offers the following benefits:

 

  • Compliance with the native architecture of the AS/400 – iSeries – Power i system
  • Very low CPU consumption
  • Very high fault tolerance (network, system, etc.)
  • Virtually infinite selection-transformation capacity, thanks to a comprehensive language and the possibility of calling external user code

 

Real-Time4 DB2 AS/400 accesses the data and services in native mode. This ensures that all the functions on the AS/400-ISeries-Power i platform are available (mono/multi-member, mono/multi-format, etc.).