I am working on a POC application where I need to stream CDC from an Oracle database into a Kafka topic. I have been able to get this up and running using an Debezium connected to a Oracle database running in a Docker container. The problem I'm having is that the Oracle container is very bloated, and often enters into an unhealthy state because of resource contraints on the Docker host. As such, I would like to take advantage of whatever is available in the Oracle Cloud Free tier.
Oracle is just one of the many databases in the POC, so I was looking for a quick start guide on how to quickly stand up a Oracle database with CDC enabled. Ideally I would like to have our on-premise Debezium instance be able to connect to the Oracle database and stream the CDC events to our on-premise Kafka instance.
However, if that is not possible, then for this use case, if Oracle ran on its own Kafka instance in the cloud, that is perfectly fine. I can quickly develop a sink connector that will subscribe and stream the reading into my master database on-premise. The only thing that is important is that I need to stream CDC events in real-time. And, it has to be free (no judgement, please. I am working on a student budget).
I completely understand that I am freeloader asking for people's time on how to use free resources on Oracle Cloud, but if anyone could lend me a little of your time and sympathy, that would be much appreciated.
I am not familiar with the Oracle line of products. And, for the same reason, I am not particularly concerned with what products we use to get this up and running. My only objective is to demo CDC, real-time analytics and an event-driven design. As such, I am coming into this will an open mind as to how I can get this up and running quickly.