tcACCESS

tcACCESS provides different methods to exchange mainframe data directly with an ORACLE database:

direct data transfer of mainframe data into an ORACLE database

SQL-access to all supported mainframe data sources and direct insert of the result set into an ORACLE database

direct access to ORACLE databases using SQL-commands from mainframe applications. The access to ORACLE can be performed from online applications (i.e. CICS, IMS/DC etc.) as well as from Batch-programs (Open System Transparency)

This feature greatly simplifies the bi-directional data-exchange in heterogeneous system environments.

Example:

Use tcACCESS to process data of an SQL-Server- or ORACLE-database by a mainframe program or even process a view that combines mainframe data (i.e. DB2, VSAM, IMS/DB, ADABAS, etc.) by standard SQL-commands (JOINS).
The processing can be bi-directional. Transaction processing is supported.
The Open System Transparency component can be used to join mainframe data and ORACLE-data.

Features

Direct access to ORACLE-databases from mainframe batch- or online-applications.

SQL-syntax used for resource access

Easy implementation by a simple to use API

Bi-directional and transactional processing

Support of synchronous or asynchronous processing

The mainframe application will always be informed about the result (Return code or message)

Efficient processing even with large data volumes

DB2/UDB

tcACCESS provides different methods to exchange mainframe data directly with an DB2/UDB database:

direct data transfer of mainframe data into an DB2/UDB database

SQL-access to all supported mainframe data sources and direct insert of the result set into an DB2/UDB database

direct access to DB2/UDB databases using SQL-commands from mainframe applications. The access to DB2/UDB can be performed from online applications (i.e. CICS, IMS/DC etc.) as well as from Batch-programs (Open System Transparency)

This feature greatly simplifies the bi-directional data-exchange in heterogeneous system environments.

Example: Use tcACCESS to process data of an SQL-Server- or DB2/UDB-database by a mainframe program or even process a view that combines mainframe data (i.e. DB2, VSAM, IMS/DB, ADABAS, etc.) by standard SQL-commands (JOINS).

The processing can be bi-directional. Transaction processing is supported.

The Open System Transparency component can be used to join mainframe data and DB2/UDB-data.

Features

Direct access to DB2/UDB-databases from mainframe batch- or online-applications.

SQL-syntax used for resource access

Easy implementation by a simple to use API

Bi-directional and transactional processing

Support of synchronous or asynchronous processing

The mainframe application will always be informed about the result (Return code or message)