Arbutus technology provides direct access to DB2 tables for a variety of applications. The Arbutus LegacyLink™ DB2 driver connects your Windows applications directly with your DB2 data, solving the problem of how to query data in DB2 tables using Excel, Access, Crystal Reports or other common desktop applications.
Arbutus offers a number of unique advantages over DB2 Connect, particularly for end-user applications.
Our technology is unique because of its ability to not only access DB2, but to join it with disparate data from IMS, VSAM, QSAM, ISAM and other DB2 tables with no additional 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 DB2 data using our LegacyLink™ middleware
- Combines your DB2 data with IMS, VSAM, ISAM, QSAM and AS/400 based data
- Addresses the problem of how to query data in DB2 tables from the desktop
- Defines table and column information automatically based on information read from the DB2 system tables
- Supports dynamic query push-down optimization, to maximize query performance
- Ensures security/integrity by providing read-only access to the data
- Displays only those tables and columns chosen to be accessible by the administrator
- Allows the 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 DB2 data without requiring any DB2 changes
- Allows multiple DB2 tables to be combined into a single logical table
- Join any tables, either via SQL or star schema relationships
- Provides the ability to create a limited table list for users' access based on User profile, Group or Business
See also: Mainframe Data Sources Accessed by Arbutus
.