Oracle AQ

You can configure Oracle AQ as a source or a target.

To configure the connection details for Google Cloud Pub/Sub in your Micro-Integration, see Oracle AQ Connection Parameters

You must also define at least one Micro-Integration Flow that specifies:

the endpoints where data is consumed from and published to. For more information, see Micro-Integration Flow Parameters.
how the header and payload fields should be mapped. For more information, see Mapping Headers and Payloads

For message headers, see Oracle AQ Message Headers.

Oracle AQ Connection Parameters

The following table describes the connection parameters for the 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.

Micro-Integration Flow Parameters

You must configure the endpoint parameters for each Flow. Each Flow can have different settings, but they all share the connection details of the parent Micro-Integration. These parameters differ depending on whether Oracle AQ is configured as a source or a target.

Oracle AQ Source Parameters

The following table describes the parameters for configuring Oracle AQ as a source.

Field

Description

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 as a target.

Field	Description
Destination Type	Select TOPIC or QUEUE.
Destination	The name of the Oracle AQ topic or queue.
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.

Provide feedback