What users are saying about
45 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.6 out of 101
100 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.5 out of 101

Likelihood to Recommend

Apache Kafka

Despite the disadvantages I list, I really believe that Kafka is the right choice whenever you need a queueing or message broker system. Kafka is way too battle-tested and scales too well to ever not consider it. The only exception is if your use case requires many, many small topics. Also, Kafka doesn't support delay queues out of the box and so you will need to "hack" it through special code on the consumer side.
No photo available

Oracle Data Integrator

Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle Database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on).I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good.It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.
Paolo Borghi profile photo

Feature Rating Comparison

Cloud Data Integration

Apache Kafka
Oracle Data Integrator
7.6
Pre-built connectors
Apache Kafka
Oracle Data Integrator
7.9
Connector modification
Apache Kafka
Oracle Data Integrator
7.4
Support for real-time and batch integration
Apache Kafka
Oracle Data Integrator
7.8
Data quality services
Apache Kafka
Oracle Data Integrator
7.5
Data security features
Apache Kafka
Oracle Data Integrator
7.6
Monitoring console
Apache Kafka
Oracle Data Integrator
7.4

Pros

Apache Kafka

  • Apache Kafka is able to handle a large number of I/Os (writes) using 3-4 cheap servers.
  • It scales very well over large workloads and can handle extreme-scale deployments (eg. Linkedin with 300 billion user events each day).
  • The same Kafka setup can be used as a messaging bus, storage system or a log aggregator making it easy to maintain as one system feeding multiple applications.
No photo available

Oracle Data Integrator

  • Oracle Data Integrator nearly addresses every data issue that one can expect. Oracle Data Integrator is tightly integrated to the Oracle Suite of products. This is one of the major strengths of Oracle Data Integrator. Oracle Data Integrator is part of the Oracle Business Intelligence Applications Suite - which is highly used by various industries. This tool replaced Informatica ETL in Oracle Business Intelligence Applications Suite.
  • Oracle Data Integrator comes with many pre-written data packages. If one has to load data from Excel to Oracle Database, there is a package that is ready available for them - cutting down lot of effort on writing the code. Similarly, there are packages for Oracle to SQL, SQL to Oracle and all other possible combinations. Developers love this feature.
  • Oracle Data Integrator relies highly on the database for processing. This is actually an ELT tool rather than an ETL tool. It first loads all the data into target instance and then transforms it at the expense of database resources. This light footprint makes this tool very special.
  • The other major advantage of Oracle Data Integrator, like any other Oracle products, is a readily available developer pool. As all Oracle products are free to download for demo environments, many organizations prefer to play around with a product before purchasing it. Also, Oracle support and community is a big advantage compared to other vendors.
No photo available

Cons

Apache Kafka

  • Still a bit inmature, some clients have required recoding in the last few versions
  • New feaures coming very fast, several upgrades a year may be required
  • Not many commercial companies provide support
Juan Francisco Tavira profile photo

Oracle Data Integrator

  • ODI does not have an intuitive user interface. It is powerful, but difficult to figure out at first. There is a significant learning curve between usability, proficiency, and mastery of the tool.
  • ODI contains some frustrating bugs. It is Java based and has some caching issues, often requiring you to restart the program before you see your code changes stick.
  • ODI does not have a strong versioning process. It is not intuitive to keep an up to date repository of versioned code packages. This can create versioning issues between environments if you do not have a strong external code versioning process.
James Parks profile photo

Likelihood to Renew

Apache Kafka

Apache Kafka 9.0
Based on 1 answer
Kafka is quickly becoming core product of the organization, indeed it is replacing older messaging systems. No better alternatives found yet
Juan Francisco Tavira profile photo

Oracle Data Integrator

Oracle Data Integrator 10.0
Based on 4 answers
It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger.
No photo available

Support

Apache Kafka

Apache Kafka 10.0
Based on 2 answers
We use Heroku to host Pulsar and they have tons of Kafka experts that have helped us tune every little setting and give us advice via email or live chat (if you pay for premium support).
No photo available

Oracle Data Integrator

No score
No answers yet
No answers on this topic

Alternatives Considered

Apache Kafka

Confluent Cloud is still based on Apache Kafka but it has a subscription fee so, from a long term perspective, it is wiser to deploy your own Kafka instance that spans public and private cloud. Amazon Kinesis, Google Cloud Pub/Sub do not do well for a very number of messages and doesn't provide ordering guarantees as Apache Kafka or Confluent. Apache Kafka does better in scaling and availability than IBM MQ and Rabbit MQ.
No photo available

Oracle Data Integrator

ODI is the naturel successor of OWB, adopting the same EL-T approach but supporting a lot more technologies as source and target. The overall product is much more stable and not tied to the Oracle Database.Unlike Informatica, ODI generates all the code in the native underlying technologies used for source or target. This makes it easier to develop and usually faster to load.
Jérôme Françoisse profile photo

Return on Investment

Apache Kafka

  • Kafka is free
  • Speeds up ingest
  • Faster for UI to get data
No photo available

Oracle Data Integrator

  • Lead time to complete data integration and transformation project was reduced due to Oracle Data Integrator tools that helped in setting up transformations relatively quickly once it was set up.
  • Reduced lead time helped in reducing project cost as less resources were spent in data conversion project.
  • Overall data consolidation project resulted in quick integration of data from varied DBMS and data sources.
No photo available

Pricing Details

Apache Kafka

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Oracle Data Integrator

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Apache Kafka
9.0
Oracle Data Integrator
8.0

Likelihood to Renew

Apache Kafka
9.0
Oracle Data Integrator
10.0

Support

Apache Kafka
10.0
Oracle Data Integrator

Implementation

Apache Kafka
Oracle Data Integrator
7.0

Add comparison