Arbutus technology provides direct access to any VSAM file for use in a wide variety of applications. Arbutus LegacyLink™ middleware connects your Windows applications directly with your VSAM and other data, solving the problem of how to query data in VSAM files using Excel, Access, Crystal Reports or other common desktop applications.
Arbutus software is unique because of its ability to not only access VSAM, but to join it with disparate data from IMS, DB2, ISAM, QSAM or other VSAM files with no additional infrastructure. Users can benefit from one view of the requested data, even when multiple sources are involved.
In fact, the Arbutus technology allows virtually any file, regardless of complexity, to be accessed and combined in any manner as if they were part of a database or data warehouse. As a result, using our LegacyLink™ middleware, any SQL query can be executed directly against the source data.
Users can benefit from one view of the requested data, even when multiple sources are involved.
KEY FEATURES:
- Supports SQL queries directly against VSAM data with our LegacyLink™ middleware
- Combines your VSAM data with DB2, IMS, ISAM, QSAM and AS/400 based data
- Addresses the challenge of how to query data in VSAM files from the desktop
- Allows VSAM files to be automatically defined using existing COBOL or PL/1 record definitions
- Identifies and displays VSAM keys to assist in establishing relationships with other data sources
- Supports dynamic query push-down optimization, utilizing VSAM keys to maximize query performance
- Ensures security/integrity by providing read-only access to the data
- Displays only those VSAM files and columns chosen to be accessible by the administrator
- Allows data definitions to be easily modified at any time
- Allows table and column names that the user sees to be easily modified for readability or usability
- Supports the creation of dynamic "virtual" columns based on the contents of the data without requiring any changes to the VSAM file itself, by utilizing over 80 built in functions
- Enables VSAM files to be joined with any tables, either via SQL or star schema relationships
See also: Mainframe Data Sources Accessed by Arbutus
.
.