WebSphere Adapter for SAP Software

The SQI interface

The SAP query interface (SQI) provides you with the means to retrieve data from application tables on an SAP system or to query SAP application tables for the existence of data. The adapter can perform hierarchical data retrieval from the SAP application tables.

SQI supports outbound interactions for read operations (RetrieveAll and Exists) only. You can use this interface in local transactions to look up records before write operations (Create, UpdateWithDelete, or Delete). For example, you could use SQI as part of a local transaction to do an existence check on a customer before creating a sales order. You can also use the interface in non-transaction scenarios.

The SQI interface supports data retrieval form SAP application tables, including hierarchical data retrieval from multiple tables. The interface supports static as well as dynamic specification of where clauses for the queries.

Enterprise service discovery finds and builds the hierarchical business object structures for multiple tables using the relationships between them. With enterprise service discovery, you can also build a default where clause for the query.


Terms of use |

Last updated: Mon 30 Oct 2006 03:34:55

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)