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

Likelihood to Recommend

Cassandra

Apache Cassandra is a NoSQL database and well suited where you need highly available, linearly scalable, tunable consistency and high performance across varying workloads. It has worked well for our use cases, and I shared my experiences to use it effectively at the last Cassandra summit! http://bit.ly/1Ok56TKIt is a NoSQL database, finally you can tune it to be strongly consistent and successfully use it as such. However those are not usual patterns, as you negotiate on latency. It works well if you require that. If your use case needs strongly consistent environments with semantics of a relational database or if the use case needs a data warehouse, or if you need NoSQL with ACID transactions, Apache Cassandra may not be the optimum choice.
Rekha Joshi | TrustRadius Reviewer

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 | TrustRadius Reviewer

Feature Rating Comparison

NoSQL Databases

Cassandra
8.0
Oracle Data Integrator
Performance
Cassandra
8.5
Oracle Data Integrator
Availability
Cassandra
8.7
Oracle Data Integrator
Concurrency
Cassandra
7.6
Oracle Data Integrator
Security
Cassandra
8.0
Oracle Data Integrator
Scalability
Cassandra
9.4
Oracle Data Integrator
Data model flexibility
Cassandra
6.7
Oracle Data Integrator
Deployment model flexibility
Cassandra
7.0
Oracle Data Integrator

Cloud Data Integration

Cassandra
Oracle Data Integrator
7.8
Pre-built connectors
Cassandra
Oracle Data Integrator
7.6
Connector modification
Cassandra
Oracle Data Integrator
7.8
Support for real-time and batch integration
Cassandra
Oracle Data Integrator
7.7
Data quality services
Cassandra
Oracle Data Integrator
8.3
Data security features
Cassandra
Oracle Data Integrator
7.9
Monitoring console
Cassandra
Oracle Data Integrator
7.6

Pros

Cassandra

  • Continuous availability: as a fully distributed database (no master nodes), we can update nodes with rolling restarts and accommodate minor outages without impacting our customer services.
  • Linear scalability: for every unit of compute that you add, you get an equivalent unit of capacity. The same application can scale from a single developer's laptop to a web-scale service with billions of rows in a table.
  • Amazing performance: if you design your data model correctly, bearing in mind the queries you need to answer, you can get answers in milliseconds.
  • Time-series data: Cassandra excels at recording, processing, and retrieving time-series data. It's a simple matter to version everything and simply record what happens, rather than going back and editing things. Then, you can compute things from the recorded history.
David Prinzing | TrustRadius Reviewer

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.
Anonymous | TrustRadius Reviewer

Cons

Cassandra

  • Cassandra runs on the JVM and therefor may require a lot of GC tuning for read/write intensive applications.
  • Requires manual periodic maintenance - for example it is recommended to run a cleanup on a regular basis.
  • There are a lot of knobs and buttons to configure the system. For many cases the default configuration will be sufficient, but if its not - you will need significant ramp up on the inner workings of Cassandra in order to effectively tune it.
Anonymous | TrustRadius Reviewer

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 | TrustRadius Reviewer

Likelihood to Renew

Cassandra

Cassandra 8.6
Based on 16 answers
I would recommend Cassandra DB to those who know their use case very well, as well as know how they are going to store and retrieve data. If you need a guarantee in data storage and retrieval, and a DB that can be linearly grown by adding nodes across availability zones and regions, then this is the database you should choose.
Anonymous | TrustRadius Reviewer

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.
Anonymous | TrustRadius Reviewer

Usability

Cassandra

Cassandra 7.0
Based on 1 answer
It’s great tool but it can be complicated when it comes administration and maintenance.
Glen Kim | TrustRadius Reviewer

Oracle Data Integrator

No score
No answers yet
No answers on this topic

Support Rating

Cassandra

Cassandra 7.0
Based on 2 answers
Sometimes instead giving straight answer, we ‘re getting transfered to talk professional service.
Glen Kim | TrustRadius Reviewer

Oracle Data Integrator

No score
No answers yet
No answers on this topic

Alternatives Considered

Cassandra

We evaluated MongoDB also, but don't like the single point failure possibility. The HBase coupled us too tightly to the Hadoop world while we prefer more technical flexibility. Also HBase is designed for "cold"/old historical data lake use cases and is not typically used for web and mobile applications due to its performance concern. Cassandra, by contrast, offers the availability and performance necessary for developing highly available applications. Furthermore, the Hadoop technology stack is typically deployed in a single location, while in the big international enterprise context, we demand the feasibility for deployment across countries and continents, hence finally we are favor of Cassandra
yixiang Shan | TrustRadius Reviewer

Oracle Data Integrator

I have used Trifacta Google Data Prep quite a bit. We use Google Cloud Platform across our organization. The tools are very comparable in what they offer. I would say Data Prep has a slight edge in usability and a cleaner UI, but both of the tools have comparable toolsets.
Cameron Gable | TrustRadius Reviewer

Return on Investment

Cassandra

  • I have no experience with this but from the blogs and news what I believe is that in businesses where there is high demand for scalability, Cassandra is a good choice to go for.
  • Since it works on CQL, it is quite familiar with SQL in understanding therefore it does not prevent a new employee to start in learning and having the Cassandra experience at an industrial level.
Anonymous | TrustRadius Reviewer

Oracle Data Integrator

  • From a business intelligence perspective, it allows us to provide users with the necessary data and information to make informed decisions.
  • Compared with other Oracle products and licensing, I do not think the pricing was unreasonable.
  • It is part of a larger install, so for ease of use, we purchased it with other Oracle products.
Anonymous | TrustRadius Reviewer

Pricing Details

Cassandra

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

Cassandra
6.8
Oracle Data Integrator
8.2

Likelihood to Renew

Cassandra
8.6
Oracle Data Integrator
10.0

Usability

Cassandra
7.0
Oracle Data Integrator

Support Rating

Cassandra
7.0
Oracle Data Integrator

Implementation Rating

Cassandra
7.0
Oracle Data Integrator
7.0

Add comparison