Dear Team,

I hope this email finds you well. I am reaching out to request your
assistance with setting up a connection between an Oracle database and
Apache Kafka using Debezium CDC (Change Data Capture) for real-time data
streaming. My goal is to establish bidirectional replication between the
Oracle database and a PostgreSQL database on a Windows environment. The
replication process involves using Kafka Connect with JDBC connectors to
facilitate seamless data flow between the two databases.

Specifically, I need guidance on configuring and deploying the necessary
components, including the Debezium Oracle connector for capturing changes
from the Oracle database, the Kafka Connect framework for data streaming,
and the JDBC connector to replicate data to the PostgreSQL database.
Additionally, I am interested in understanding how to set up the reverse
replication process from PostgreSQL back to Oracle using the same or
similar tools.

Your expertise and advice on best practices for setting up this replication
pipeline would be greatly appreciated. Any step-by-step guidance,
configuration tips, or troubleshooting suggestions you can provide would be
invaluable as I work on this implementation.

Thank you in advance for your support. I look forward to your insights and
assistance.

Regards,

Dhanesh M

Reply via email to