Configure Destination

Before we do anything, we have to start Kafka first, so let's do it:

Start Kafka

Start kafka

Configure Kafka Properties File

Configure Kafka Properties File (e.g. TRG_OGGHOME/dirprm/kafka.properties)

Configure Kafka Producer Properties file

Kafka Producer Properties file (e.g. TRG_OGGHOME/dirprm/kafka_producer.properties)

Configure Golden Gate(Replicat)

Again we have to configure the Golden Gate Replicat:

Configure Golden Gate Replicat

Test

To test the replication, we will insert some rows and see how they are being replicated.

Insert data on Oracle Source DB

Check if the data is replicated between: GG Extract → GG Replicat

Check GG Replication

Finally, we can consume the data on Kafka:

Consume the data from Kafka

So, we have configured replication: Oracle RDBMS → Golden Gate (Extract) → Golden Gate (Replicat) → Apache Kafka

Appendix

kafka server properties (e.g. $KAFKA_HOME/config/server.properties)