Arbutus technology provides direct access to ISAM data for use in a variety of applications. Arbutus LegacyLink™ middleware connects your Windows applications directly with your ISAM and other data, solving the problem of how to query data in ISAM files using Excel, Access, Crystal Reports or other common desktop applications.
Our technology is unique because of its ability to not only access data in ISAM files, but to join it with disparate data from IMS, DB2, QSAM, VSAM and other ISAM 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 ISAM data using our LegacyLink™ middleware
- Combines ISAM data with DB2, IMS, VSAM, QSAM and AS/400-based data
- Addresses the challenge of how to query data in ISAM files from the desktop
- Allows ISAM files to be automatically defined using existing COBOL or PL/1 record definitions
- Ensures security/integrity by providing read-only access to the data
- Displays only those ISAM 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 ISAM file itself, by utilizing over 80 built in functions
- Enables ISAM files to be joined with any tables, either via SQL or star schema relationships
See also: Mainframe Data Sources Accessed by Arbutus
.
.