The Oracle Advanced Queuing (AQ) Adapter enables you to integrate Oracle AQ in an on-premises application as well as cloud applications in the Oracle database, Oracle Autonomous Transaction Processing (ATP) database, Oracle Autonomous Data Warehouse (ADW) database, and Oracle Database Classic Cloud Service (DBaaS) database.

The Oracle Advanced Queuing (AQ) Adapter provides the following capabilities:

• Supports the dequeue operation. The dequeue operation polls for incoming messages on a queue.

• Supports opaque, sample JSON, XML schema (XSD) document/archive, Avro Schema (AVSC) document, and sample XML document as message types.

• Supports queues of the Oracle Business Event System type. See Route Business Event Data to an Oracle Advanced Queue.

• Supports raw and object queues.

• Supports the enqueueing of messages in the outbound (invoke) direction.

• Supports enqueuing and dequeuing of payloads up to 10 MB in size. It is recommended that you configure max_retries at the AQ level so that the message is eventually moved to the exception queue.

  Note:

  In Java, Unicode characters are represented as 2 bytes.
• Supports the Oracle Wallet security policy to connect with the Oracle Autonomous Transaction Processing instance, Oracle Autonomous Data Warehouse instance, and Oracle Database Classic Cloud Service instance over SSL.
• Supports customers implementing secure egress (dedicated NAT Gateway) for invoking Java Database Connectivity (JDBC) APIs using a private endpoint. See Connect to Private Resources in Provisioning and Administering Oracle Integration 3 and Configure the Endpoint Access Type. This type of connection does not use the connectivity agent.
• Supports connecting to the Oracle Database using a Single Client Access Name (SCAN).
• Supports standard headers for both enqueuing and dequeuing operations.

  Note:

  The standard headers for dequeuing operations are available in the mapper. To process messages based on priority, make sure you configure the Queue table with the sort order as PRIORITY. This ensures that messages with higher priorities are processed first.

The Oracle Advanced Queuing (AQ) Adapter is one of many predefined adapters included with Oracle Integration. You can configure the Oracle Advanced Queuing (AQ) Adapter as a trigger or invoke connection in an integration in Oracle Integration.