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