blocks|key|442312|text|甲骨文GoldenGate和Confluent+Platform是不可比拟的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|442313|Confluent+Platform提供了完整的流媒体平台，是多个软件的集合，可以用于您的数据流，其中GoldenGate是复制和数据集成软件。|442314|此外，GoldenGate对于db复制来说是高度可靠的，因为它维护事务完整性，而此时Kafka+Mirror+Maker或Confluent's+Replicator则不能这样说。|442315|entityMap^0|3|A|E|I|0|0|I|1F|A|0|3|A|16|I|1P|M|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|V|8|@$9|W|A|X|B|C]|$9|Y|A|Z|B|C]|$9|10|A|11|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|K|$]]

Oracle <code>GoldenGate</code> and <code>Confluent Platform</code> are not comparable. 

<code>Confluent Platform</code> provides the complete streaming platform and is a collection of multiple software which can be used for streaming your data, where as <code>GoldenGate</code> is replication and data-integration software.

Also <code>GoldenGate</code> is highly reliable for db replication since it maintains transactional integrity, same cannot be said for <code>Kafka Mirror Maker</code> or <code>Confluent's Replicator</code> at this time.

blocks|key|840772|text|首先，一般的答案是:连接甲骨文(数据库)到卡夫卡的最好方法是结合卡夫卡的connect+API和GoldenGate的现成连接器使用汇合平台。请参阅https://www.confluent.io/product/connectors/中“认证连接器”一节中的GoldenGate/Oracle条目。列出的GoldenGate卡夫卡连接器是由甲骨文维护的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|840773|汇合平台是最好的方式吗？|blockquote|840774|因此，一般来说，上述问题的答案是：“是的，是的。”|840775|但是，正如您针对有关Oracle版本的特定问题指出的那样，不幸的是，Oracle在其GoldenGate连接器的自述文件中提供了以下信息：|840776|支持的版本
Oracle+GoldenGate+Kafka连接处理程序/格式化程序是用以下产品版本进行编码和测试的。|style|BOLD|840777|用于大数据的Oracle+GoldenGate+12.2.0.1.1|unordered-list-item|840778|融合IO+Kafka/Kafka+Connect+0.9.0.1-cp1|840779|Oracle+GoldenGate+Kafka连接处理程序/格式化程序可能需要移植才能与其他版本的Oracle+GoldenGate进行大数据和/或合流IO+/Kafka连接。|840780|这意味着连接器不能使用Oracle+11g，至少据我所知。|840781|如果没有回答你的具体问题，很抱歉。至少我想给你一些关于一般方法的反馈。如果我遇到一个更具体的答案，我会更新这篇文章。|840782|更新2017年3月15日：你现在拥有的最好的选择是使用汇流JDBC连接器。但是，该连接器不能为您提供与Oracle的原生GoldenGate连接器完全相同的特性集。|840783|entityMap|0|LINK|mutability|MUTABLE|url|https://www.confluent.io/product/connectors/|1^0|22|18|0|0|0|0|0|0|3|0|0|0|0|0|0|0|D|R|9|1|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@$A|1B|B|1C|1|1D]]|C|$]]|$1|D|3|E|5|F|7|1E|8|@]|9|@]|C|$]]|$1|G|3|H|5|6|7|1F|8|@]|9|@]|C|$]]|$1|I|3|J|5|6|7|1G|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|1H|8|@$A|1I|B|1J|M|N]]|9|@]|C|$]]|$1|O|3|P|5|Q|7|1K|8|@]|9|@]|C|$]]|$1|R|3|S|5|Q|7|1L|8|@]|9|@]|C|$]]|$1|T|3|U|5|6|7|1M|8|@]|9|@]|C|$]]|$1|V|3|W|5|6|7|1N|8|@]|9|@]|C|$]]|$1|X|3|Y|5|6|7|1O|8|@]|9|@]|C|$]]|$1|Z|3|10|5|6|7|1P|8|@$A|1Q|B|1R|M|N]]|9|@$A|1S|B|1T|1|1U]]|C|$]]|$1|11|3|-4|5|6|7|1V|8|@]|9|@]|C|$]]]|12|$13|$5|14|15|16|C|$17|18]]|19|$5|14|15|16|C|$17|18]]]]

First, the general answer would be: The best way to connect Oracle (databases) to Kafka is indeed to use Confluent Platform with Kafka's Connect API in combination with a ready-to-use connector for GoldenGate. See the GoldenGate/Oracle entry in section "Certified Connectors" at <a href="https://www.confluent.io/product/connectors/" rel="nofollow noreferrer">https://www.confluent.io/product/connectors/</a>. The listed Kafka connector for GoldenGate is maintained by Oracle.

<blockquote>
 Is the Confluent platform the best way to go?
</blockquote>

Hence, in general, the answer to the above question is: "Yes, it is."

However, as you pointed out for your specific question about Oracle versions, Oracle unfortunately has the following information in the README of their GoldenGate connector:

<blockquote>
 Supported Versions
 
 The Oracle GoldenGate Kafka Connect Handler/Formatter is coded and
 tested with the following product versions.
 
 <ul>
 <li>Oracle GoldenGate for Big Data 12.2.0.1.1</li>
 <li>Confluent IO Kafka/Kafka Connect 0.9.0.1-cp1</li>
 </ul>
 
 Porting may be required for Oracle GoldenGate Kafka Connect
 Handler/Formatter to work with other versions of Oracle GoldenGate for
 Big Data and/or Confluent IO Kafka/Kafka Connect
</blockquote>

This means that the connector does not work with Oracle 11g, at least as far as I can tell.

Sorry if that doesn't answer your specific question. At least I wanted to give you some feedback on the general approach. If I do come across a more specific answer, I'll update this text.

Update Mar 15, 2017: The best option you have at the moment is to use the <a href="https://www.confluent.io/product/connectors/" rel="nofollow noreferrer">Confluent's JDBC connector</a>. That connector can't give you quite the same feature set as Oracle's native GoldenGate connector though.

blocks|key|442364|text|现在，我正在使用ojdbc6连接到Oracle11g。它足够好，但并不完美，特别是在使用池模式检查原始表上是否有新的更新时。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|442365|我还试着使用特定的模式读取所有表，但这不是很好。|442366|将Oracle+DB连接到Kafka的最佳模式(尤其是当表非常宽、列非常明智时)是对连接器使用查询。这样，您可以确保选择正确的字段，并在使用avro的情况下对数字进行一些转换。|442367|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Right now I am using ojdbc6 to connect to Oracle 11g. It is good enough but not perfect especially when using pooling mode to check if there are new updates on the original tables. 

I tried also to read all tables using certain pattern but this did not work well. 

The best mode to connect an Oracle DB to Kafka (especially when the tables are very wide, columns wise, is to use queries for the connectors. This way, you ensure that you pick the right fields and do some casting for numbers if you are using avro.

blocks|key|842952|text|如果您只想要纯事务-也请考虑使用OpenLogReplicator。它支持11.2.0.1版本的Oracle数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|842953|它可以以两种格式产生到Kafka的交易：|842954|经典格式-当每个事务都是一个Kafka消息(每个Kafka消息多个DMLS+)|unordered-list-item|842955|Debezium样式格式-事务被划分-每个DML都是一条Kafka消息。|842956|已经有了一个可行的版本。你可以试试。|842957|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|P|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|Q|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|L|$]]

If you want just pure transactions - please also consider using OpenLogReplicator. It supports Oracle database from version 11.2.0.1.

It can produce transactions to Kafka in 2 formats:

<ul>
<li>Classic format - when every transaction is one Kafka message (multiple DMLS per Kafka message)</li>
<li>Debezium style format - transactions are divided - every DML is one Kafka message</li>
</ul>

There is already a working version. You can try it.

I am looking for a solution to stream data from Oracle 11g to Kafka. I was hoping to use GoldenGate, but that only seems to be available for Oracle 12c. Is the Confluent platform the best way to go?

Thanks!

Streaming data from Oracle 11g to Kafka

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在寻找从Oracle 11g到Kafka流数据的解决方案。我本来希望使用GoldenGate，但这似乎只适用于Oracle12c。汇合平台是最好的方式吗？谢谢!

问从Oracle 11g到Kafka的流数据
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从Oracle 11g到Kafka的流数据EN