使用Apache Kafka的Oracle复制数据 [英] Oracle replication data using Apache kafka

问题描述

我想从oracle数据库中公开数据表，并公开到apache kafka中.技术上可行吗? 同样，我需要从oracle表中流式传输数据更改并将其通知给Kafka. 您知道此用例的良好文档吗? 谢谢

I would like to expose the data table from my oracle database and expose into apache kafka. is it technicaly possible? As well i need to stream data change from my oracle table and notify it to Kafka. do you know good documentation of this use case? thanks

推荐答案

1. 您需要Kafka Connect JDBC源连接器才能从Oracle数据库加载数据.有一个来自Confluent的开源捆绑式连接器.它已与Confluent平台的其余部分(包括架构注册表)一起打包和测试.使用此连接器就像编写简单的连接器配置并启动独立的Kafka Connect进程或向Kafka Connect集群发出REST请求一样容易.可以在此处

要将变更数据从Oracle事务数据库实时移至Kafka，您首先需要使用变更数据捕获(CDC)专有工具，该工具需要购买商业许可证，例如Oracle的Golden Gate，Attunity Replicate，Dbvisit复制或Striim.然后，您可以利用它们都提供的Kafka Connect连接器.它们都在此处

To move change data in real-time from Oracle transactional databases to Kafka you need to first use a Change Data Capture (CDC) proprietary tool which requires purchasing a commercial license such as Oracle’s Golden Gate, Attunity Replicate, Dbvisit Replicate or Striim. Then, you can leverage the Kafka Connect connectors that they all provide. They are all listed here

Debezium是Redhat的开源CDC工具，它计划在不依赖Oracle Golden Gate许可证的连接器上工作.相关的JIRA在此处.

Debezium, an open source CDC tool from Redhat, is planning to work on a connector that is not relying on Oracle Golden Gate license. The related JIRA is here.

这篇关于使用Apache Kafka的Oracle复制数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！