aMod - The Application Modernization Company
Home Solutions Contact Us

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