DB2
The Arbutus technology provides direct access to DB2 tables for
a variety of applications. Arbutus provides the LegacyLink™ DB2
driver that connects your Windows applications directly with your DB2 data.
As well, Arbutus offers query, migration and data warehouse prototyping solutions.
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. 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
- 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
|
