Arbutus technology provides direct access to IMS segments for a variety of applications. Arbutus LegacyLink™ IMS Driver connects Windows applications directly with your IMS data, solving the problem of how to query data in IMS segments using Excel, Access, Crystal Reports or other common desktop applications.
Our technology is unique because of its ability to not only access IMS, but to join it with disparate data from DB2, VSAM, QSAM, ISAM and other IMS segments with no additional infrastructure. Solutions that provide access through DB2 incur significant overhead, in addition to the required infrastructure.
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 your IMS data with DB2, VSAM, ISAM, QSAM and AS/400 based data
- Addresses the challenge of how to query data in IMS segments from the desktop
- Automates the definition of databases and segments to streamline and simplify IMS data access
- Allows access based upon any segment path, or a single segment only
- Supports using existing COBOL, PL/1 or DBD record definitions to automatically define segments and segment path data
- Identifies and displays segment keys to assist in establishing relationships with other data sources
- Supports dynamic query push-down optimization, utilizing IMS segment keys to maximize query performance
- Ensures security/integrity by providing read-only access to the data
- Displays only those segments and columns chosen to be accessible by the administrator
- 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 IMS data without requiring any IMS changes
- Join any tables, either via SQL or star schema relationships
See also: Mainframe Data Sources Accessed by Arbutus
.
.