tcACCESS live

How our customers use tcACCESS in production !

more

Ask for a free of charge trial installation.

Tel.: ++49-89-4619930

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.

Click here to view a larger version of this picture
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. 
    

TOP

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.
       

TOP

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.  
       

TOP

Features

 

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
   

TOP

 

 

 

 

NEWSLETTER

NEWS

CUSTOMERS

EVENTS