Oracle AQ

You can configure Oracle AQ as a source or a target. The parameters are described in the following tables:

For message headers, see Oracle AQ Message Headers.

Oracle AQ Source Parameters

The following table describes the parameters for configuring Oracle AQ.

Field Description

Datasource URL

The URL of the connection to Oracle AQ. For example: jdbc:oracle:thin:@//localhost:1521/freepdb1.

Username

The username to authenticate with Oracle AQ. Optional. If not supplied, you must upload an Additional Properties File.

Password

The password to authenticate with Oracle AQ. Optional. If not supplied, you must upload an Additional Properties File.

Additional Properties File

A connection properties file that contains name=value pairs that assign a value to the name of a connection property. For example:

oracle.jdbc.user=<my-user-id>
oracle.jdbc.password=<my-password>

When this file is provided, the Micro-Integration appends the query parameter oracle.jdbc.config.file=file:///file-path to the datasource URL, incorporating the properties from the uploaded file.

For more information, see the Oracle connection properties file documentation.

Destination Type

Select TOPIC or QUEUE.

Destination

The name of the Oracle AQ topic or queue.

Durable Subscription Name

The name of the durable subscription multiple consumers can bind to. Durable subscriptions accumulate messages even when all consumers are offline, ensuring that no messages are lost.

This value is mandatory when the Destination Type is TOPIC.

Oracle AQ Target Parameters

The following table describes the parameters for configuring Oracle AQ.

Field Description

Datasource URL

The URL of the connection to Oracle AQ. For example: jdbc:oracle:thin:@//localhost:1521/freepdb1.

Username

The username to authenticate with Oracle AQ. Optional. If not supplied, you must upload an Additional Properties File.

Password

The password to authenticate with Oracle AQ. Optional. If not supplied, you must upload an Additional Properties File.

Additional Properties File

A connection properties file that contains name=value pairs that assign a value to the name of a connection property. For example:

oracle.jdbc.user=<my-user-id>
oracle.jdbc.password=<my-password>

When this file is provided, the Micro-Integration appends the query parameter oracle.jdbc.config.file=file:///file-path to the datasource URL, incorporating the properties from the uploaded file.

For more information, see the Oracle connection properties file documentation.

Destination Type

Select TOPIC or QUEUE.

Destination

The name of the Oracle AQ topic or queue.

Durable Subscription Name

The name of the durable subscription multiple consumers can bind to. Durable subscriptions accumulate messages even when all consumers are offline, ensuring that no messages are lost.

This value is mandatory when the Destination Type is TOPIC.

Transacted

Specifies that messages are received within a local transaction. When selected, this option indicates that the JMS consumer reads messages within a local transaction and commits the transaction when the batch has been successfully processed.