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.
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:
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:
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:
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:
For the most current and specific information about releases and platforms,
The Information Builders Technical Support home page opens.
The Supported Systems and Adapters page opens.
The Supported Systems and Adapters page for that release opens.
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 |
|
|
Address Doctor |
x |
x |
x |
x |
x |
Alchemy |
x |
x |
x |
x |
x |
Business Object Universe |
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 |
Essbase |
x |
x |
|
|
|
Excel |
x |
|
|
|
|
Excel (via direct retrieval) |
x |
x |
x |
x |
x |
|
x |
x |
x |
x |
x |
Flat Files |
x |
x |
x |
x |
x |
FOCUS |
x |
|
|
|
|
Greenplum |
x |
x |
x |
x |
x |
Hive/Hadoop Release Candidate |
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 |
|
|
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 |
x |
x |
|
|
|
Teradata |
x |
x |
x |
|
|
Transoft |
x |
x |
x |
x |
x* |
|
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 |
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.
WebFOCUS |