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 > Technical overview
Advanced Queue integration overview
Advanced Queue is an interface type in Oracle E-Business Suite. It allows outbound integration with Oracle E-Business Suite and helps in transferring data to the application. It also interacts with the Oracle advanced queue. The interface services contain a common standard-based approach for integration between Oracle E-Business Suite and other third-party applications (Example: Enterprise Application Integration).
IBM WebSphere Adapter for Oracle E-Business Suite supports the advanced queue feature, which integrates Oracle E-Business Suite with other EIS. When the advanced queue interface is selected, the adapter generates the advanced queue header and payload business objects. Using the external service wizard you can create the advanced queue header and payload business object to start outbound or inbound at runtime.
Oracle advanced queue integration is applicable for IBM BPM or WebSphere Enterprise Service Bus only.
WebSphere Adapter for Oracle E-Business Suite creates a dynamic SQL script, which uses some Oracle AQ PL/SQL API to enqueue or dequeue. After sending the business data to Oracle E-Business Suite by starting the runtime method, you can use Oracle E-Business Suite's import request to import such business data. Messages can be queried using standard SQL. This means SQL can be used to access the message properties, the message history, and the payload.
There are few supporting terms used in this feature, which are described as follows:
- Queue Header contains the properties used in enqueue and dequeue operation. In the enterprise metadata discovery process, these properties are populated with the sample value based on the property type (Example: string, integer). The sample value with an incorrect property type causes failure in the runtime. Example: Priority (int), Delay (int), and Correlation (string).
- Queue table Payload is an Oracle PL/SQL type that contains the business information required for the business process in advanced queue integration. The adapter will generate the BO for it after configuring the module for the advanced queue integration.
- Queue Name is the name of Oracle advanced queue, which receives and send out the integration data.
- Enqueue operation
The Enqueue operation is used to run a dynamic PL/SQL script for enqueuing. The external service wizard generates the required advanced queue business object that corresponds to the advanced queue definition in the database. The adapter uses the Enqueue operation to process the advanced queue business object.- Dequeue operation
The Dequeue operation dequeues messages from the advanced queue using PL/SQL or JMS. The dequeued message constituents are payload, message properties, and message ID.
Technical overview of IBM WebSphere Adapter for Oracle E-Business Suite
Related tasks: