aMod - The Application Modernization Company
Home Solutions Contact Us

tcVISION

Task
The Challenge
The Solution
Technology
Architecture
Change Data Capture
Features
Q & A
Mainframe Systems
Data Store
Open Systems
DRDA - DB2
Oracle
ODBC
tcVISION – DRDA

DRDA for DB2 LUW in Unix, Linux, Windows

tcVISION uses the DRDA protocol as output media if the target database is a DB2 LUW system that does not exist on a mainframe (i.e. WINDOWS, UNIX/LINUX/Linux on System z).

For synchronization with a mainframe based DB2, a direct communication via DB2 is supported. The usage of DRDA allows for a fast and easy implementation with a DB2 LUW target-system.

     Highlights
  • Support of the industry standard DRDA
  • Simple and easy implementation
  • Fast, flexible and platform independent protocol


tcVISION – ORACLE

Implementation of changed mainframe data into ORACLE via OCI, ODBC and Oracle Loader

tcVISION offers different methods to implement changed mainframe data directly into an ORACLE database:

  • Propagation of changed mainframe data in SQL DML syntax format using the Oracle Call Interface (OCI)
  • Using the ORACLE Loader function for the insertion of mass data into an ORACLE database
  • Propagation of changed mainframe data in SQL DML syntax-format using any ODBC driver

All tools needed to create, maintain and process an ORACLE database can be used from the tcVISION Control Board.

The Change Data Capture function of ORACLE (ORACLE Stream) together with tcACCESS can be used to implement a bidirectional synchronization with a mainframe resource. 

Highlights

  • Synchronization for ORACLE using OCI or ODBC
  • Bidirectional and transaction oriented processing based on LUWs
  • Optional synchronous or asynchronous LUW processing
  • Efficient processing of large data volumes using the ORACLE LOADER function


tcVISION – ODBC

Changed Data Propagation via ODBC

The change data from the mainframe that has been processed can be propagated into any target system that supports ODBC. This allows for a flexible processing that is independent of the actual target system.

All tools needed to create, maintain and process an ODBC data source can be used from the tcVISION Control Board.

      

Highlights

  • Synchronization using ODBC driver under Windows or UNIX*
  • Resource access is performed with SQL-DML syntax
  • LUW based processing
  • Optional synchronous or asynchronous LUW processing
  • Efficient processing of large data volumes using "bound" parameter
  • Support of all common ODBC standards

* requires the installation of a UNIX ODBC Manager (i.e. UNIXODBC)