Welcome to aMod

tcACCESS

Task: The Challenge; The Solution
Technology: Architecture; SQL Technology; Features; Q & A
Mainframe Systems: Mainframe Files
Workstation Systems: Databases; Applications; Technologies

tcACCESS – Databases

ORACLE

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)
Efficient processing even with large data volumes