iWay Software's Intelligent Adapter for Adabas – SQL, JDBC, ODBC, and XML-based Enterprise Integration

Accelerating Adabas Integration

iWay Software's intelligent Adabas adapter provides highly efficient access to Adabas data and systems. The adapter is engineered in the same way as other iWay data adapters, so developers may use ANSI-standard SQL statements to access Adabas data from any iWay tool. Third-party products can also access the adapter via iWay connectors, including ODBC, OLE DB, JDBC, XML, iWay Business Services (Web services), and others. In addition, data may be integrated with more than 300 other information sources, including other relational and non-relational database, transaction systems, custom or packaged applications, message-oriented middleware, XML documents, EDI networks, and more.

iWay Software's Adapter for Adabas allows for integration of Adabas data with over 200 different sources of information in your enterprise

How iWay Intelligent Data Adapters Work Together

All iWay Intelligent Adapters are designed for consistent operation within iWay's robust middleware framework, thereby minimizing the skill sets required to use each database and support new projects. Each adapter consists of a communications interface, an SQL translator that manages adapter operations in either SQL or iWay's universal Data Manipulation Language (DML), and a database interface that translates ANSI SQL into native API calls. Multiple iWay adapters running on the same platform can all share communications and translation components for greater efficiency.

Highly Optimized for Adabas

The iWay Intelligent Adapter for Adabas receives ANSI-standard SQL requests and translates them into iWay's universal DML. These DML statements are used to access the target database using Adabas direct calls to retrieve data targeted in the request. If required, the adapter will generate the appropriate iWay SQL and DML statements to perform cross-database joins with other data sources.

Special features and settings for iWay's Adapter include:

  • Read/write capability
  • Support for most commonly used data types including character and packed data
  • Metadata creation tools to describe databases using FDT and/or Predict
  • Support for superdescriptors via the GROUP attribute
  • Support for records containing multi-value field or periodic groups via the OCCURS attribute
  • Specification of null-suppression to maximize performance
  • Optimized simple and complex FIND calls using non-descriptor fields
  • Optimized group field access
  • Direct data retrieval via L1, L2, and L3 calls
  • Optimized data retrieval using multi-fetch and pre-fetch options
  • Advanced interface tracing facility displaying buffers and statistics

Virtual fields can be created within the iWay Adapter for Adabas, allowing developers to select a calculation as if it were simply another column in the database. In addition, the adapter can perform joins automatically in order to connect an Adabas file to any other data source. By creating views of mixed data from Adabas and other sources, developers and end users can request information from a flatter, more spreadsheet-like structure without technical understanding of the underlying structural relationships. The adapter provides query control via the RECORDLIMIT feature to reduce communication traffic, CPU usage, and I/O activity. iWay’s Resource Analyzer and Resource Governor products may also be used to analyze and control resources on a global basis independently of the adapter being used.

Special iWay Performance Features

The iWay Adapter directly provides query control via the RECORDLIMIT feature to reduce communication traffic, CPU usage, and I/O activity. iWay's Resource Analyzer and Resource Governor products may also be used to analyze and control resources on a global basis independently of the adapter being used.