Functions of an Adapter

In this section:

The server uses adapters to access data sources. The server can receive two types of requests from the client: SQL or WebFOCUS.

When the server receives requests from the client, it passes them to the adapter in a standard format. The adapter takes the request, transforms it into the native data manipulation language (DML), and then issues calls to the data source using its API. In this way, the adapter insulates the server from details of the data source. An application can issue SQL statements, issue WebFOCUS commands, or call stored procedures.

Adapters are available for many data sources. Every adapter is specifically designed for the data source that it accesses, and, as a result, is able to translate between SQL or WebFOCUS and the DML of the data source. Adapters provide solutions to product variations, including product differences in syntax, functionality, schema, data types, catalogs, data representations, message processing, and answer set retrieval.

Note: If the adapter has read/write capabilities, it inserts the data from an application to the data source.


Top of page

x
How an Adapter Works

The adapter manages the communication between the data interface and the data source, passing data management requests to the data source and returning either answer sets or messages to the requestor.

To perform these functions, the adapter:

  1. Translates the request to the applicable DML.
  2. Attaches to the targeted data source, using standard attachment calls. The adapter then passes the request to the data source.
  3. The data source processes the request.
  4. The results or error conditions are returned to the client application for further processing.

Top of page

x
Processing SQL Requests

A server can be configured to behave in different ways upon receipt of SQL requests from a client application. A server handles SQL requests for data in the following ways, as illustrated in the diagram:


Top of page

x
Processing WebFOCUS Requests

When the server receives a WebFOCUS request, it passes it to the adapter. The adapter analyzes the request and generates DBMS-specific DML for those parts of the request that have DML equivalents. As WebFOCUS is a more robust language than DML, some parts of the request may not have such equivalents. The adapter then passes the generated DML to the DBMS for processing. When the answer set is returned by the DBMS, WebFOCUS processes those parts of the request that the adapter could not pass to the DBMS.

Throughout this manual there are descriptions of some useful features that are not supported by SQL syntax but are supported by WebFOCUS syntax.

For complete information about the WebFOCUS language, see the following manuals:


Top of page

x
Relational and Non-Relational Adapters

Adapters can retrieve answer sets from both relational and non-relational data sources. Since the architectures of relational and non-relational data structures vary, the relational and non-relational adapters adjust for these differences. For example, relational adapters are designed to handle data sources that contain data in rows and columns in tables, while non-relational adapters are designed to accommodate the architecture of each distinct data source, for instance, a hierarchical or network data source, or a sequential or indexed file system.

The following table lists key features of relational and non-relational adapters:

 Feature

Relational Adapters

Non-Relational Adapters

DEFINE (virtual field) in Master File

Yes

Yes

Access Control

Yes

Yes

Transaction Management Commands

Yes

No

Relational and non-relational adapters:

To address these similarities and differences, this manual contains:



x
Supported Adapters

For the most current and specific information about releases and platforms,

  1. Go to http://techsupport.informationbuilders.com.

    The Information Builders Technical Support home page opens.

  2. In the Quick Links section on the right side of the page, click Supported Systems/Adapters.

    The Supported Systems and Adapters page opens.

  3. Click the link for the server release you want.

    The Supported Systems and Adapters page for that release opens.

  4. Click the link for your platform.

    The support chart for that platform opens.

The following table summarizes that information.

Adapter

Windows

UNIX

z/OS

OpenVMS

IBM i (formerly i5/OS)

1010data

x

x

 

 

 

Adabas

x

x

x

 

 

Adabas Stored Procedures

 

 

x

 

 

Alchemy

x

x

x

x

x

Caché

x

x

 

 

 

CA-IDMS/DB

 

 

x

 

 

CA-IDMS/SQL

 

 

x

 

 

CICS Transactions

x

x

x

x

x

C-ISAM

x

x

 

 

 

DATACOM/DB

 

 

x

 

 

DB2

x

x

x

 

x

DB Heritage Files

 

 

 

 

x

Delimited Flat Files

x

x

x

x

x

Digital Standard Mumps

 

 

 

x

 

Enterprise Java Beans

x

x

x

x

x

ERwin

x

x

x

x

x

Essbase

x

x

 

 

 

Excel

x

 

 

 

 

Excel (via direct retrieval)

x

x

x

x

x

Facebook

x

x

x

x

x

Flat Files

x

x

x

x

x

FOCUS

x

 

 

 

 

Greenplum

x

x

x

x

x

Hyperstage

x

x

x

x

x

IDMS > see CA-IDMS

 

 

 

 

 

IMS/DB

 

 

x

 

 

IMS Transactions

x

x

x

x

x

Information Manager

 

 

x

 

 

Informix

x

x

 

 

 

Ingres

 

x

 

 

 

Interplex(DMS/RDMS 2200/1100)

x

x

 

 

 

iWay Adapter Framework (IWAF)

x

x

x

 

 

JBoss

x

x

x

x

x

JDBC

x

x

x

x

x

JD Edwards EnterpriseOne

x

x

x

x

x

JD Edwards World

 

 

 

 

x

JSON

x

x

x

x

x

Lawson

x

x

x

x

x

LDAP

x

x

x

 

x

Lotus Notes

x

x

x

 

x

Microsoft Access

x

 

 

 

 

Microsoft SQL Server

x

x

x

x

x*

Millennium

 

 

x

 

 

Model 204

 

 

x

 

 

MQSeries

x

x

x

x

x

MySQL

x

x

x

x

x

NATURAL Batch

x

x

x

x

x

NATURAL CICS Transactions

 

x

x

 

x

Netezza

x

 

 

 

 

Nucleus

x

x

 

 

 

ODBC

x

 

 

 

 

Oracle

x

x

 

x

 

Oracle E-Business Suite (Oracle Applications)

x

x

x

x

 

parAccel

x

 

 

 

 

PeopleSoft

x

x

x

 

 

PostgreSQL

x

x

x

x

x*

Progress

x

x

 

 

 

PSQL

x

x

x

x

x*

Query/400

 

 

 

 

x

Rdb

 

 

 

x

 

Red Brick

x

x

 

 

 

REST

x

x

x

x

x

Remote Servers

x

x

x

x

x

RMS

 

 

 

x

 

SAP BW

x

x

x

 

x

SAP

x

x

x (non-Unicode)

 

x

Siebel

x

x

 

 

x*

SQLBase

x

x

x

x

x*

SQL Server Analysis Services (SSAS)

x

 

 

 

 

Sybase ASE

x

x

 

 

 

Sybase IQ

x

x

 

 

 

Supra

 

 

x

 

 

Teradata

x

x

x

 

 

Transoft

x

x

x

x

x*

Unidata

x

x

x

x

x*

UniVerse

x

x

 

 

 

VSAM

 

 

x

 

 

VSAM CICS

 

 

x

 

 

Wand

x

x

x

x

x

Web Services

x

x

x

x

x

Words Analysis

x

x

x

x

x

XBRL

x

x

x

x

x

XML

x

x

x

x

x

* The underlying databases for these adapters do not necessarily run directly on the IBM i platform (formerly known as i5/OS). However, they may be configured and accessed.


iWay Software