The Arbutus technology provides direct access to any VSAM file for use in a wide variety of applications. Arbutus provides the LegacyLink™ middleware that connects your Windows applications directly with your VSAM and other data. As well, Arbutus offers query, migration and data warehouse prototyping solutions.
Our technology 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.
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
- 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