tcACCESS – SQL Technology

Open System Transparency – Access to Open System Resources from Mainframe Applications

tcACCESS allows a direct access to any ODBC data-source, DB2/LUW- or ORACLE database that is available on MS-Windows- or UNIX/LINUX-server. Information stored on Open System server can be processed by Online- (CICS, IMS/DC etc.) and Batch programs (Mainframe Software).

The tcACCESS Open System Transparency provides a true real-time integration for mainframe applications, that may even completely eliminate the need for a synchronization of mainframe- and Open System data-sources. In a heterogeneous environment bidirectional data exchange is extremely simplified.

 

Open System Transparency example

tcACCESS enables a mainframe application to process SQL-Server-data or data of an ORACLE-database. The data can even be joined with mainframe data (i.e. DB2, VSAM, IMS/DB, ADABAS, etc.). The JOIN is performed by simple SQL-statements.

The mainframe program calls an API of the tcACCESS SQL-Engine. The program passes the SQL-statement that must be executed and connection parameter for the ODBC driver. The SQL-statement can already define a join between mainframe and Open System data.

The tcACCESS API passes the application request to the tcACCESS Listener that is running on a MS-Windows- or UNIX/LINUX-workstation. The Listener extracts the data using the corresponding ODBC-driver and returns the data to the tcACCESS SQL-Engine on the mainframe. If required, the SQL-Engine will then join the data with any other mainframe file as specified in the SQL-statement.

The processing can be bidirectional. Transaction processing is supported.

  

TOP

Features

tcACCESS Open System Transparency for the mainframe can easily be implemented and provides an excellent performance when accessing the Open System data. No special requirements must be available for the network topology. 

The special highlight is the support of Joins of mainframe data and Open System data.

Features:

  

 

TOP