Let's take a look how CDC(Change Data Capture) can be done with triggers and message queuing service built directly in the Oracle Database and how easy it is to integrate it with MicroProfile Reactive Messaging. We will create Always free instance of Oracle Database in Oracle Cloud(OCI), setup simple data capture with triggers and build in queuing and consume the data with MicroProfile Reactive Messaging AQ connector in Helidon.
Good to know:
- Intermediate Java knowledge
- Basic concept of MicroProfile
- Basic concept of asynchronous messaging
- Experience with reactive streams is a plus but not necessary
You will learn:
- How to setup of free of charge Oracle Database in Oracle Cloud(OCI)
- How to setup Advance Queing in Oracle Database
- How to create Helidon app with Reactive Messaging connected to Oracle AQ
Objective of the presentation:
Leveraging MicroProfile Reactive Messaging for consuming database data changes over Oracle AQ(Advanced Queuing).
Attendee pre-requisites - If none, enter "N/A":
Intermediate Java
Basic knowledge about MicroProfile
Basics of PL/SQL