VSAM
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
|
