IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > Oracle E-Business Suite
Overview of IBM WebSphere Adapter for Oracle E-Business Suite
With IBM WebSphere Adapter for Oracle E-Business Suite, you can create service-oriented integrated applications, which can interact and exchange information with Oracle E-Business Suite. By using the adapter, you can send requests and receive events from the underlying Oracle database, without special coding.
WebSphere Adapter for Oracle E-Business Suite enables a two-way communication between the application running on IBM BPM or WebSphere Enterprise Service Bus and the underlying Oracle database of Oracle E-Business Suite. Using the adapter, an application can send requests to read, create, modify, or delete data in the Oracle database, in many cases without writing any SQL code. To process requests received from an application, the adapter updates the Oracle database tables using SQL queries or stored procedures. An application can also receive events from the Oracle E-Business Suite.
For example, it can be notified that specific objects in Oracle E-Business Suite are updated. To process events that result from changes to the Oracle E-Business Suite, the adapter delivers events to the application. Using the Oracle Business Event System and event notification, changes to the Oracle E-Business Suite can be automatically notified to other applications. By combining event processing by WebSphere Adapter for Oracle E-Business Suite and another adapter, updates can be automatically propagated to other enterprise applications such as Siebel, PeopleSoft, and SAP.
WebSphere Adapter for Oracle E-Business Suite provides a standard interface that integrates with the underlying Oracle database of the Oracle E-Business Suite applications; it supports the Oracle database server by using the Oracle Java™ Database Connectivity (JDBC) drivers. The JRE version required by the Oracle JDBC driver must not be higher than the JRE version in the run time environment. The adapter uses business objects to exchange data between the application and the Oracle database, so the application does not need to use the JDBC application programming interface (API). Business objects are containers for application data that represent business functions or elements, such as an Oracle table or the result of an SQL query. The adapter understands the data format provided by the application, and can process the data, perform the operation, and send the results back in that format.
- Hardware and software requirements
The hardware and software requirements for WebSphere Adapters are provided on the IBM Support website.- Technical overview of IBM WebSphere Adapter for Oracle E-Business Suite
The adapter supports integration of databases that are accessible through the JDBC application programming interface (API) with applications running on IBM BPM or WebSphere Enterprise Service Bus. The adapter provides outbound and inbound processing under the Java Platform, Enterprise Edition (JEE) Connector Architecture (JCA) and integrates with Service Component Architecture components.