問題描述
我想從我的 oracle 數據庫中公開數據表并公開到 apache kafka 中.技術上可行嗎?同樣,我需要從我的 oracle 表中流式傳輸數據更改并將其通知給 Kafka.你知道這個用例的好文檔嗎?謝謝
您需要 Kafka Connect JDBC 源連接器才能從 Oracle 數據庫加載數據.Confluent 有一個開源的捆綁連接器.它已經與 Confluent 平臺的其余部分一起打包和測試,包括模式注冊表.使用此連接器就像編寫簡單的連接器配置并啟動獨立的 Kafka Connect 進程或向 Kafka Connect 集群發出 REST 請求一樣簡單.可以在此處找到此連接器的文檔/p>
要將變更數據從 Oracle 事務數據庫實時移動到 Kafka,您需要首先使用變更數據捕獲 (CDC) 專有工具,該工具需要購買商業許可,例如 Oracle 的 Golden Gate、Attunity Replicate、Dbvisit復制或 Striim.然后,您可以利用它們都提供的 Kafka Connect 連接器.它們都列在此處
Debezium 是 Redhat 的一個開源 CDC 工具,它計劃開發一種不依賴于 Oracle Golden Gate 許可的連接器.相關的 JIRA 是這里.
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
You need Kafka Connect JDBC source connector to load data from your Oracle database. There is an open source bundled connector from Confluent. It has been packaged and tested with the rest of the Confluent Platform, including the schema registry. Using this connector is as easy as writing a simple connector configuration and starting a standalone Kafka Connect process or making a REST request to a Kafka Connect cluster. Documentation for this connector can be found here
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, 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.
這篇關于Oracle 使用 Apache kafka 復制數據的文章就介紹到這了,希望我們推薦的答案對大家有所幫助,也希望大家多多支持html5模板網!