1. Using the Oracle Advanced Queuing (AQ) Adapter with Oracle Integration 3
  2. Understand the Oracle Advanced Queuing (AQ) Adapter
  3. Oracle Advanced Queuing (AQ) Adapter Capabilities

Oracle Advanced Queuing (AQ) Adapter Capabilities

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 and XML schema 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 processing payloads up to 10 MB in size. The Oracle Advanced Queuing (AQ) Adapter does not consume messages greater than the 10 MB threshold 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).

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.