aMod - The Application Modernization Company
Home Solutions Contact Us


The Challenge
The Solution
SQL Technology
Q & A
Mainframe Systems
Mainframe Files
Workstation Systems
tcACCESS – Applications

tcACCESS ODBC-Server and –driver for MS-Windows

ODBC (Open Database Connectivity) is an industry standard protocol. System wide utilization of data will be greatly simplified with ODBC.

tcACCESS contains an ODBC Server component and an ODBC driver. They can be used to access Mainframe data sources (i.e. VSAM, DLI, IMS/DB, ADABAS, CA-Datacom etc.) using standard SQL with no programming effort. Access can be performed by any Client/Server- or Web- application and data can be retrieved or updated if the application requires this. As an alternative to SQL commands, access can also be performed using individual user logic.

Using tcACCESS, the development of Client/Server- or Web-applications with direct access to mainframe data sources has been simplified, because no mainframe knowledge is required. Company specific security policies remain effective and they are even carried forward to the new platforms; tcACCESS uses the SAF interface and can be fully integrated into standard security packages like RACF, ACF/2 or TOP/SECRET

ODBC-Support for Source Data-Type

One of the tcACCESS benefits is, that the source- and the target- data-type for a data transfer can be any data format that uses ODBC. An example would be to upload data from an MS-ACCESS database directly into a VSAM Cluster. Record- and field-selection for the transfer can be interactively defined.

ODBC-Support for Target Data-Type

  Using an ODBC data source as the target file enables the user to directly download mainframe data sources into ODBC targets. The physical location of the target database is not relevant. A typical example would be to download the result of an SQL query that joins an IMS/DB database and a VSAM file, directly into an SQL Server table or an EXCEL spreadsheet. There is no need for intermediate steps or files. Particularly in the area of Data Warehousing or Data Mining, this functionality greatly enhances the capability to gather data and make it available for further processing: quickly and efficiently. Most applications running under MS Windows support ODBC (i.e. MS Office, LOTUS, Seagate Info etc.). Accessing mainframe data sources from these applications is easy, straightforward and does not require any programming. tcACCESS provides the required ODBC Server or local ODBC driver to perform the direct access to mainframe data sources.  


  • Direct access to mainframe data from ODBC-eligible applications
  • Integration mainframe programs into MS-WINDOWS applications via ODBC
  • ODBC-access through local ODBC-driver as well as ODBC-Server
  • Bi-directional data-transfer between mainframe files and ODBC-sources with no intermediate steps or media
  • Support of all common ODBC-standards
  • Direct SQL access to mainframe data using the tcACCESS API for applications that do NOT support ODBC

JAVA Applications

The tcACCESS JDBC/J2EE component provides a platform independent implementation for accessing mainframe data sources via TCP/IP. The JDBC/J2EE component can be used on any machine that hosts a “JAVA Virtual Machine” . JAVA-based applications can use the JDBC/J2EE component to execute SQL commands on the mainframe. Again, the SQL commands can be executed against relational and non-relational mainframe data sources. No additional third party JAVA packages (such as, swing etc.) are required.

JDBC standards of Version 2.0 or 3.0 are supported.

The tcACCESS Java-components can be used with an SSL-based secured connection.

Accessing the JDBC component from JAVA-applications enable these applications to directly access mainframe data sources using SQL. With the extensive SQL support of the tcACCESS mainframe component as well as the automatic analysis of mainframe data (data mapping), applications can be developed in a fraction of time. 


  • Direct SQL access to mainframe data from JAVA-applications
  • Integration of mainframe programs into JAVA-applications with JDBC/J2EE
  • Support of all common JDBC-standards
  • Mainframe programs can initiate JAVA-processes on WINDOWS- or UNIX/LINUX/Linux on System z platforms

UNIX/LINUX Applications

The tcACCESS UNIX/LINUX component acts as an alternative to the tcACCESS JDBC/J2EE component and does not require the presence of a JAVA Virtual Machine. The tcACCESS component consists of Batch utilities to access mainframe data sources using SQL commands, and to Upload and Download data to and from the mainframe. 

An API (Application Programming Interface) is also available for UNIX/LINUX/Linux on System z Clients and Servers. This API contains functions needed for communicating with the mainframe, configuring tcACCESS, uploading and downloading mainframe resources, and utilizing the SQL interface. The API allows easy deployment of processes to automate data transmission between the UNIX/LINUX/Linux on System z machine and the IBM Mainframe.

The tcACCESS UNIX/LINUX/Linux on System z component also contains an ODBC driver. The driver can be used in conjunction with ODBC managers like iODBC and unixODBC to directly access mainframe data-sources and to exchange data between the mainframe and the UNIX/LINUX/Linux on System z systems. 

Users of ODBC-capable databases like ORACLE under UNIX can now easily exchange data with the mainframe without any programming effort.   


  • Direct SQL access to mainframe data from UNIX/LINUX/Linux on System z applications
    • using ODBC
    • using an ODBC independent tcACCESS interface
    • using a tcACCESS API
  • Integration of mainframe programs into UNIX/LINUX/Linux on System z applications
    • using ODBC
    • using an ODBC independent tcACCESS interface
    • using a tcACCESS API
  • Bi-directional data-transfer between mainframe and UNIX/LINUX/Linux on System z systems
  • Mainframe applications can initiate processes on UNIX/LINUX/Linux on System z systems


ODBC (Open DataBase Connectivity) has become a system standard for data protocols. ODBC greatly simplified cross platform data-access. 

tcACCESS contains an ODBC-server-component and an ODBC-driver. LOTUS Notes- or LOTUS Domino-applications can use SQL to access the mainframe data sources using ODBC (i.e. VSAM, DLI, IMS/DB, CA-Datacom, ADABAS, etc.). If required, data can also be manipulated. As an alternative to SQL-based data access it is also possible to use individual application logic.

The development of LOTUS Notes/Domino-applications with direct access to mainframe data is a simple and easy task with tcACCESS. No mainframe knowledge is required. The SAF-interface of tcACCESS guarantees the highest possible level of security. The central data access mechanisms of the mainframe can be used with no limitations from Open Server applications. 



  • Direct SQL access to mainframe data from LOTUS Notes applications
  • Direct SQL access to mainframe data from LOTUS Domino applications
  • Support of Formula Language and LotusScript
  • Support of Domino Enterprise Connection Services
  • ODBC-access using local ODBC-driver or network ODBC-server
  • Support of all common ODBC-standards


Corporations that have WebSphere on their IBM Mainframe to utilize the Internet infrastructure can use the JDBC/J2EE component to directly access mainframe data sources from Web applications. In addition to accessing DB2, tcACCESS allows direct access to all different mainframe data sources using standard SQL commands. 

The tcACCESS administrator functions provide additional benefits to the application developer because the mainframe data structures are automatically analyzed (Data Mapping) and become available to the application for immediate access. Again, no mainframe-specific knowledge is required. 

Web applications with direct access to mainframe data sources can be developed in a short period of time. Time and money savings can be significant. 

IBM's WebSphere and tcACCESS is the ideal combination for fast and efficient development of e-Commerce solutions that focus on the integration of an IBM mainframe.


  • Platform independences through JDBC/J2EE-technology
  • Transparent Websphere-access to all mainframe data
  • No mainframe knowledge required
  • Mainframe integration into Web applications and global Portal systems