Regarding a data consolidation scenario, are there any comparative analysis that compares Apache Kafka and Oracle Goldengate for remote data streaming?
In the scenario, we have to integrate sensory structured data from multiple (~100) sources to a single destination over internet.
Note: If my question is general, your questions in comment may help me to describe the situation more accurately.
Thanks in advance.
Presuming the 100 sources are all Oracle Databases then Oracle Goldengate would be the best choice if you want to configure vs code. You can use Oracle Goldengate to "replicate" the 100 sources to a single location for processing.
Also remember that Oracle Goldengate and Kafka are not either or, Oracle Goldengate can deliver the changes to a Kafka topic.