Complex File Support

Arbutus technology can present virtually any data file in a table format. This capability is not limited to simple, fixed-length files, but extends to all file formats supported by the IBM mainframe and AS/400 platforms, and most formats supported by other platforms. Each format is automatically and transparently converted to a table format appropriate for your application.

zSeries, zOS, MVS
iSeries, AS/400
 Databases Supported: DB2 DB2
IMS
 File Organizations Supported: VSAM (ESDS, KSDS, RRDS) IFS
ISAM Spool
QSAM (Flat Files) Flat Files
Partitioned or Sequential
GDG
Blocked, Unblocked or Spanned

RECORD ORGANIZATIONS SUPPORTED

  • Fixed record length
  • Variable record length
    • Standard Variable length formats
    • Application-specific custom variable formats
  • Single record type
  • Multiple record type (REDEFINES)
    • Unlimited number of redefines supported
    • Specific record type(s) may be selected from the file
    • Multiple record types may be “virtually flattened” as the file is read, presenting the combined information as a single relational table
  • Repeating Blocks (OCCURS)
    • Single field repeating
    • Block of information repeating
  • Variable frequency (OCCURS DEPENDING ON)

In addition to supporting any record organization, Arbutus technology also reads virtually every data type you may encounter. As with record organization, each of these types is automatically converted to a format appropriate for your application.

FIELD TYPES SUPPORTED

Mainframe-specific data types:

  • EBCDIC (PIC X)
  • Packed (COMP-3)
  • Unsigned packed
  • Zoned (PIC 9)
  • Binary (COMP-1)
  • Display formatted numbers (including any punctuation)
  • Float
  • Date (any format supported, including Y2K-specific techniques)
    • Century specifier
    • YY or YYYY
    • MM or MMM
    • DD or DDD
    • Any formatting characters
    • Serial dates, with any base

Other data types:

  • ASCII
  • Float (IEEE, BASIC, DEC)
  • Reverse Binary (Little Endian)
  • Logical (Y/N, 0/1, T/F, etc.)
  • Half-byte
  • Bit
  • Unisys Packed

Each of these data types is supported in any length that is appropriate for the type. In addition, all Arbutus Servers are fully compatible with all the data types above.

Virtual columns may also be defined. These allow any computation, or set of computations, to be dynamically calculated and presented as a field, as if part of the data.

Legacy Systems

A legacy system is defined as:

…a computer system or application program that is usually mainframe-based and utilizes older technologies. In many cases, legacy systems continue to be used because of the prohibitive cost of replacing or redesigning them, and often despite their lack of competitiveness or incompatibility with modern equivalents.

These systems have typically been in operation a long time, and their functions are too essential to be disrupted by upgrading or integrating with another system. In most cases, these systems are large, monolithic, and difficult to modify.

The facts on legacy systems:

  • The challenge faced by many organizations is this: legacy systems often do not support direct reporting and analysis from important business information contained in these systems.
  • The barriers represented by legacy systems artificially limit the creativity and ability of end-users to solve problems and perform the full scope of reporting and analysis on the data that currently exists in their organization.
  • The typical solutions put forward – upgraded software, data marts or custom programs – all require a significant commitment of time and financial resources, making it difficult to build a strong business case for many projects that involve legacy systems.
  • The fall-back decision of ‘do nothing’ has consistently proven to have its own real costs, both hidden and visible, as organizations are unable to make decisions and see risks based on all the information that could be made available to them.

See also: Mainframe Data Sources Accessed by Arbutus

IMS ODBC Drivers

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. Many other solutions that provide access through DB2 incur significant overhead, in addition to the required infrastructure – but not Arbutus.

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

Access Data from Different Mainframe Sources at Once

Arbutus technology provides direct, real-time access to all mainframe data sources, including:

  • IMS
  • Adabas
  • DB2
  • ISAM
  • QSAM
  • VSAM
  • Complex files (e.g., almost any data file in table format)

Data and databases from multiple platforms can be brought together quickly and easily with Arbutus for analysis and reporting. Data sources can also be easily moved between server platforms, or from server to desktop.

See also: Mainframe Data Sources Accessed by Arbutus

VSAM ODBC Drivers

Arbutus technology provides direct access to any VSAM file for use in a wide variety of applications. Arbutus LegacyLink middleware connects your Windows applications directly with your VSAM and other data, solving the problem of how to query data in VSAM files using Excel, Access, Crystal Reports, or other common desktop applications.

Arbutus software is unique because of its ability to not only access VSAM, but to join it with disparate data from IMSDB2ISAMQSAM, 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.

Users can benefit from one view of the requested data, even when multiple sources are involved.

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
  • Addresses the challenge of how to query data in VSAM files from the desktop
  • 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

See also: Mainframe Data Sources Accessed by Arbutus

QSAM ODBC Drivers

Arbutus technology provides direct access to any QSAM file, regardless of its complexity, for use in a variety of applications. Arbutus LegacyLink middleware connects your Windows applications directly with your QSAM and other data, solving the problem of how to query data in QSAM files using Excel, Access, Crystal Reports, or other common desktop applications.

Our technology is unique because of its ability to not only access QSAM, but to join it with disparate data from IMS, DB2, ISAM, VSAM, and other QSAM 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.

In addition, Arbutus includes the ability to create external indexes for any QSAM file. This allows them to essentially behave like a VSAM file and to participate in star schema data models and query optimization.

KEY FEATURES:

  • Supports SQL queries directly against QSAM data using our LegacyLink™ middleware
  • Combines your QSAM data with DB2, IMS, VSAM, ISAM, and AS/400 based data
  • Addresses the challenge of how to query data in QSAM files from the desktop
  • Allows QSAM files to be automatically defined using existing COBOL or PL/1 record definitions
  • Presents QSAM files of any complexity as a normal table to other applications
  • Allows data definitions to be easily modified at any time
  • Allows keyed access to QSAM files by using special Arbutus indexes
  • Ensures security/integrity by providing read-only access to the data
  • Displays only those files 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 data without requiring any changes to the QSAM file itself, by utilizing over 80 built-in functions
  • Enables QSAM files to be joined with any tables, either via SQL or star schema relationships

See also: Mainframe Data Sources Accessed by Arbutus

ISAM ODBC Drivers

Arbutus technology provides direct access to ISAM data for use in a variety of applications. Arbutus LegacyLink middleware connects your Windows applications directly with your ISAM and other data, solving the problem of how to query data in ISAM files using Excel, Access, Crystal Reports, or other common desktop applications.

Our technology is unique because of its ability to not only access data in ISAM files, but to join it with disparate data from IMS, DB2, QSAM, VSAM, and other ISAM 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.

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 ISAM data with DB2, IMS, VSAM, QSAM, and AS/400-based data
  • Addresses the challenge of how to query data in ISAM files from the desktop
  • Allows ISAM files to be automatically defined using existing COBOL or PL/1 record definitions
  • Ensures security/integrity by providing read-only access to the data
  • Displays only those ISAM 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 ISAM file itself, by utilizing over 80 built in functions
  • Enables ISAM files to be joined with any tables, either via SQL or star schema relationships

See also: Mainframe Data Sources Accessed by Arbutus

DB2 Data Access

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

ADABAS Data Access

Arbutus provides direct, efficient access to mainframe Adabas tables for a variety of applications including query, migration, and data warehousing solutions.

Arbutus’ Adabas driver is unique because of its ability to not only access Adabas, but to join it with other Adabas tables, as well as different data formats, such as DB2, IMS, and VSAM, with no additional infrastructure required. Users receive one view of the data, even when pulling data from multiple sources.

When used with Arbutus LegacyLink middleware, mainframe Adabas data can be integrated with Windows and web-based applications and databases.

KEY FEATURES:

  • Supports SQL queries directly against Adabas using LegacyLink
  • Combines Adabas data with other data sources
  • Defines table and column information automatically based on data read from the Adabas system tables or via the FDT conversion utility
  • Supports dynamic query push-down optimization, for maximum query performance
  • Read-only data access ensures security and integrity of data
  • User-selected tables and columns
  • Table and column names visible to the user are easily modified
  • Supports the creation of dynamic “virtual” columns based on the contents of the Adabas data without requiring any Adabas changes
  • Allows multiple Adabas 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

Mainframe Data Sources

  • Does your organization have mainframe legacy data that is difficult, costly, or time-consuming to access?
  • Do your colleagues wish they could access mainframe legacy data from their Windows notebooks or desktops?

Direct, Real-Time Access to Mainframe Data

The Arbutus Mainframe Server helps organizations overcome mainframe data delivery and analysis challenges. Together with Arbutus Analyzer and Arbutus LegacyLink, it provides direct, real-time access to all mainframe data sources.

Accessible mainframe data sources include:

Access Data from Different Mainframe Sources at Once

The Arbutus Mainframe Server resides natively on enterprise mainframes, allowing data sources to be easily moved between server platforms, or from server to desktop. Data and databases from multiple platforms can be brought together quickly and easily for analysis and reporting purposes.

Read Complex Legacy Files

The Arbutus Mainframe Server specializes in reading both relational and non-relational data sources, including the most complex legacy file structures. The Arbutus Mainframe Server enables data from various sources to appear as a table in a single unified database, even when the data exists in different formats, on different platforms.

Even the most complex data structures are directly supported, including variable length and multiple record type data, as well as COBOL OCCURS and REDEFINES.

For COBOL programmers, Arbutus supports data fields that contain overloaded or combined data values, which can be easily segregated into their components. An overloaded data field contains two different kinds of values, such as U.S. zip codes and Canadian postal codes, while a combined field will show, for example, both first name and last name.

Arbutus Windows Server Reduces Mainframe Usage

When mainframe loads or data access are an issue, the Arbutus Windows Server is an ideal solution. It is fully compatible with any mainframe data staged on it. Additionally, no data transformation is required to stage the data, ensuring a minimum of infrastructure and quick implementation.

 

Advanced Capabilities of Arbutus Technology

Arbutus technology is easy to implement and deploy, giving organizations flexibility in how they provide access to their legacy data, whether it’s on the mainframe (zSeries), AS/400 (iSeries), or Windows. Below are some of the many ways Arbutus makes data access and manipulation faster, easier, and more economical than other solutions on the market.