Adapter Developer Resources

Quick Links
Adapter Tutorials
Adapter Technical Notes
Adapter Discussion Forum

Download Oracle Adapters

 Tutorial 1: Invoking Oracle Applications API through the Oracle AS Adapter (PDF)
Application Programming Interfaces (APIs) are stored procedures that enable you to insert and update data in Oracle Applications. For example, using APIs, you can insert a customer record in Oracle Applications. The Oracle AS Adapter for Oracle Applications exposes the Oracle Applications API as a Service via WSDL with JCA binding. This tutorial describes how to invoke Oracle Application API interface and insert a customer record. The File Adapter read operation is used to read the customer record from a delimited file and trigger the BPEL process which inturn calls the create customer API in Oracle Applications.
Download Tutorial
 Tutorial 2 : Invoking a CICS transaction through the Oracle AS Adapter (PDF)
This tutorial describes the steps needed to integrate the BPEL Process Manager with CICS through the Oracle AS Adapter for CICS. The Adapter uses EXCI (EXternal Call Interface) to invoke CICS transactions and uses COMMAREA transactions to exchange message buffers. The Adapter creates a metadata schema for CICS by importing COBOL copybooks and transforming them into mapping definitions for Oracle Connect for CICS on the OS/390 machine and by associating the data structures with specific physical files. The Adapter is also capable of receiving events from CICS. These steps are not covered as part of this tutorial.
Download Tutorial
 Tutorial 3 : Invoking SAP BAPI through the Oracle AS Adapter (PDF)
The Oracle AS Adapter for SAP exposes the SAP BAPIs and RFCs as a Service via WSDL with JCA binding. This tutorial describes how to invoke a SAP BAPI interface and query the inverntory given Material ID. The BPEL process is a synchronous request-response service that invokes the SAP BAPI_MATPHYSINV_GETDETAIL API.
Download Tutorial
 Tutorial 4 : Receiving SAP IDOC through the Oracle AS Adapter (PDF)
The Oracle AS Adapter for SAP exposes the SAP IDOC events as a Service via WSDL with JCA binding. This tutorial describes how to receive a SAP DEBMAS IDOC within a BPEL process. The BPEL process is an asynchronous service that is triggered by the arrival of a SAP DEBMAS event.
Download Tutorial
 Tutorial 5 : Invoking Siebel Business Object through the Oracle AS Adapter (PDF)
The Oracle AS Adapter for Siebel exposes the Siebel Business Object and Services as a Service via WSDL with JCA binding. This tutorial describes how to invoke a Siebel Account Business Object interface through a synchronous BPEL process.
Download Tutorial
 Tutorial 6 : Receiving Siebel Integration Object through the Oracle AS Adapter (PDF)
The Oracle AS Adapter for Siebel exposes the Siebel events - Integration Objects as a Service. The Service is expressed as WSDL with JCA binding. This tutorial describes how to receive a Siebel Integration Object within a BPEL process. The BPEL process is an asynchronous service that is triggered by the arrival of a Siebel Integration Object.
Download Tutorial
 Tutorial 7 : Invoking Peoplesoft Component Interface through the Oracle AS Adapter (PDF)
The Oracle AS Adapter for Peoplesoft exposes the Peoplesoft Business Object and Services and RFCs as a Web Service via WSDL with JCA binding. This tutorial describes how to invoke a Peoplesoft Account Business Object interface through a synchronous BPEL process.
Download Tutorial
 Tutorial 8 : Oracle Apps BES Organization Insert Event Publish To Siebel Cust Acct Insert (PDF)
The Oracle AS Adapter for AQ interfaces with the Business Event System to receive Oracle Applications events in real-time. The Oracle AS Adapter for Database can invoke any stored procedure or function. The Oracle AS Adapter for Siebel interfaces with Siebel Business Objects and Services to post and query Siebel data. This tutorial shows the integration of Oracle Applications with Siebel using the AQ, Database and Siebel adapters. The business process is triggered by the arrival of Oracle Applications business event and it inturn invokes Peoplesoft CustAccount Insert Business Object interface.
Download Tutorial
 Tutorial 9 : MQSeries Queue integration through the Oracle AS Adapter for JMS (PDF)
The Oracle Adapter for JMS provides standards based connectivity to various enterprise messaging software and provides comprehensive support for the JMS specification. This example showcases MQSeries Queue to Queue integration.
Download Tutorial
 Tutorial 10 : MQSeries Queue to Topic integration using Oracle BPEL PM and Oracle AS Adapter for JMS (PDF)
The Oracle Adapter for JMS provides standards based connectivity to various enterprise messaging software and provides comprehensive support for the JMS specification. This example showcases MQSeries Queue to Topic integration.
Download Tutorial
 Tutorial 11 : File DB Integrations � Handling of opaque data types (PDF)
The Oracle Adapter for Databases is used for invoking stored procedures and performing data manipulation operations and queries and does not require coding. It supports a rich set of databases � Oracle, DB2, Microsoft SQL, Sybase, Informix and can support any standard JDBC 1.x, 2.0 compliant database. The Oracle Adapter for Files rapidly integrates information stored in a variety of formats and supports both File Read and Write operations.
Download Tutorial
 Tutorial 12 : File DB Stored Procedure Integrations (PDF)
The Oracle Adapter for Databases is used for invoking stored procedures and performing data manipulation operations and queries and does not require coding. It supports a rich set of databases � Oracle, DB2, Microsoft SQL, Sybase, Informix and can support any standard JDBC 1.x, 2.0 compliant database. The Oracle Adapter for Files rapidly integrates information stored in a variety of formats and supports both File Read and Write operations.
Download Tutorial
 Tutorial 13 : Using BPEL correlation sets � File Adapter mid-process receive (PDF)
The Oracle Adapter for Files rapidly integrates information stored in a variety of formats and supports both File Read and Write operations. Correlation sets are a BPEL mechanism that provides for the correlation of asynchronous messages based on message body contents. When an asynchronous service is initiated with the invoke activity, a correlation ID unique to the client request is sent (using WS Addressing) and the response received is mapped to the appropriate request by the Oracle BPEL Server based on the correlation id. The correlation between request and response is automatically taken care of by WS Addressing by the BPEL server and no extra step is required. However, correlation sets needs to be defined when the interactions are not simple invoke-receive activities. This example illustrates how to use BPEL correlation sets for a process having mid-process receive activity and no associated invoke activity.
Download Tutorial

 Technical Note #001: File Adapter Control Files
The purpose of this document is to describe the Control Files created by the File Adapter for persisting buffered data, cursors and select set of parameters. Tampering with the control files will lead to instability of the File Adapter and result in undesirable behavior. The control files must be edited only when certain error conditions happen and recovery needs to be performed.
 Technical Note #002: FTP Adapter�Secure FTP
The purpose of this document is to describe the SecureFTP feature of the FTP Adapter. The Oracle AS FTP Adapter supports sending and retrieval of files to/from remote FTP servers. As with any exchange of data with different types of remote servers (e.g. sending credit card info to HTTP servers), the issue of security inevitably becomes important. Security here primarily refers to two things � being able to trust the remote server you�re exchanging data with and protection from third parties trying to intercept the data. This is where SSL certificates and encryption come into the picture. When SSL is used in the context of FTP, the resulting security mechanism is known as FTPS (or FTP over SSL).
 Technical Note #003: JMS Adapter � MQSeries Integration
The purpose of this document is to address queries related to JMS Adapter integration with IBM MQSeries application.
 Technical Note #004: Adapter – Error Management
The purpose of this document is to describe the error management features of the Oracle AS Adapters and the underlying Adapter Framework.

Technical Note #005: Adapter Headers
This document describes the Adapter Headers and how to use them within the
BPEL process.

 Technical Note #006: Correlation of Adapter messages within
BPEL Process

This document describes the various ways in which the Adapter asynchronous messages can be correlated within a BPEL process.
   
Left Curve
Popular Downloads
Right Curve
Untitled Document
Left Curve
More Middleware Downloads
Right Curve