Oracle Advanced Queuing and MySQL integration with Lambda - Oracle to Aurora MySQL Migration Playbook
Oracle usageMySQL usage

Oracle Advanced Queuing and MySQL integration with Lambda

With AWS DMS, you can seamlessly migrate data from Oracle Advanced Queuing to Aurora MySQL, and integrate with AWS Lambda for event-driven processing. Oracle Advanced Queuing provides message queuing capabilities for Oracle databases, while AWS Lambda allows running code without provisioning or managing servers.

Feature compatibility AWS SCT / AWS DMS automation level AWS SCT action code index Key differences

One star feature compatibility

No automation

N/A

Use AWS Lambda and Amazon Simple Queue Service with Aurora MySQL.

Oracle usage

The Oracle Advanced Queuing (AQ) feature enables database-integrated message queuing functionality. It is based on Oracle Streams and optimizes data functions by storing messages, allocating the messages to different service queues, and transmitting the messages using Oracle Net Services, HTTP, and HTTPS. AQ is implemented using database tables.

Oracle provides the oracle.jdbc.aq Java package as an interface to AQ. It contains the following items:

  • Classes:

    • AQDequeueOptions — Specifies the options for the dequeue operation.

    • AQEnqueueOptions — Specifies the options for the enqueue operation.

    • AQFactory — A factory class for AQ, which creates components such as agent or message properties.

    • AQNotificationEvent — New message notifications.

  • Interfaces:

    • AQAgent — An identity of a user, producer, or consumer of a message.

    • AQMessage — An enqueued or dequeued message.

    • AQMessageProperties — Message properties such as:

      • Correlation

      • Sender

      • Delay

      • Expiration

      • Recipients

      • Priority

      • Ordering

  • AQNotificationListener — A listener interface for receiving AQ notification events.

  • AQNotificationRegistration — A registration to be notified when a new message is enqueued on a particular queue.

For more information, see Introduction to Oracle Database Advanced Queuing in the Oracle documentation.

MySQL usage

Aurora MySQL provides built-in integration with Lambda functions, which can be called from within the database and interact with Amazon Simple Notification Service (Amazon SNS). The integration with Lambda functions provides a powerful framework for using AWS services to implement custom solutions with less code.

Examples

For examples, see Amazon Simple Notification Service.

For more information, see Invoking a Lambda function with an Aurora MySQL native function in the User Guide for Aurora.