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.
Features
|




