IMS

The Arbutus technology provides direct access to IMS segments for a variety of applications. Arbutus provides the LegacyLink™ IMS driver that connects your Windows applications directly with your IMS data. As well, Arbutus offers query, migration and data warehouse prototyping solutions.

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 overheads, in addition to the required infrastructure.

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