CDC: KafkaConnect & Oracle

#CDC (Change Data Capture), its a very core requirement before we start planning a #ETL.

And to avoid query based change capture and do it real time changeEvent based with the help of logs, https://debezium.io/ — is an excellent implementation to do it with KafkaConnect.

Incase of #Oracle RDBMS they have nice tools like Oracle Golden Gate and Oracle XStream and both can be used with #KafkaConnect and #Debezium but sadly both are licensed. Fortunately there is a simple community implementation with KafkaConnect and Oracle as guideline https://github.com/erdemcer/kafka-connect-oracle.

This article explains more in detail https://rmoff.net/2018/12/12/streaming-data-from-oracle-into-kafka/