Cassandra vs OpenText Analytics Database (Vertica) comparison

Why PeerSpot?

Apache and OpenText are both solutions in the NoSQL Databases category. Additionally, 92% of Apache users are willing to recommend the solution, compared to 91% of OpenText users who would recommend it.

Cassandra

Read 25 Cassandra reviews

5,318 Views
3,350 Comparison Views

92% willing to recommend

OpenText Analytics Database...

Read 90 OpenText Analytics Database (Vertica) reviews

9,432 Views
5,376 Comparison Views

91% willing to recommend

Cassandra

OpenText Analytics Database...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Cassandra and OpenText Analytics Database (Vertica) based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, MongoDB, Redis and others in NoSQL Databases.

To learn more, read our detailed NoSQL Databases Report (Updated: September 2026).

Buyer's Guide

NoSQL Databases

September 2026

Download the complete report

Helped 915,341 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

Cassandra

Average Rating

8.0

Reviews Sentiment

6.0

Number of Reviews

Ranking in other categories

NoSQL Databases (5th), Vector Databases (12th)

OpenText Analytics Database...

Average Rating

8.2

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Warehouse (6th), Cloud Data Warehouse (11th)

Q&A Highlights

it_user1272297

Special Adviser Strategy at a university with 501-1,000 employees

Apr 19, 2020

Which is the best RDMBS solution for big data?

I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505

See all answers

Featured Reviews

Monirul Islam Khan

Head, Data Integration & Management at a non-profit with 10,001+ employees

Has maintained secure document storage and efficient data distribution with peer-to-peer architecture

The functions or features in Cassandra that I have found most valuable are that it is a distributed system similar to Mongo. It's good enough for comparison with another SQL database, so it's smooth and organized for distributed database system. The peer-to-peer architecture in Cassandra is helpful for network decentralization, and I have already introduced that feature. Cassandra features in peer-to-peer as well as another monitoring, so basically, it's good enough for our service. The tunable consistency level in Cassandra is good, and we are using that feature already. In terms of built-in caching and lightweight transactions in Cassandra, the transaction level is good, and it's optimized, so there are no more issues in that database. Based on my experience, Cassandra is good for document management system, as well as distributed database system, and the automatic recovery process is there. Additionally, the database monitoring system or auditing system is well-comparable with other database systems, so we are actually happy to be using this Cassandra database.

Read full review

Jitendrak Naik

consultant at tcs

Data warehousing has transformed reporting performance and now delivers near real-time insights

OpenText Analytics Database (Vertica) is a very powerful analytic database, but like any platform, there are areas where it can improve to make daily work even smoother. Better cloud-native experience is one area for improvement. OpenText Analytics Database (Vertica) was originally designed as an on-premises analytic database and later moved to cloud. Improvement opportunities include more seamless cloud-native features such as auto-scaling, serverless options, and easier cluster management. Competitors such as Snowflake and BigQuery provide more fully managed experiences. Easier UI is another area for improvement. Most administration is currently done by SQL and command line tools. An improvement opportunity would be a more modern web UI for monitoring, workload management, and troubleshooting. Faster ecosystem and community growth is needed. In short, OpenText Analytics Database (Vertica) could improve in areas such as cloud-native capability, modern UI for administration, stronger real-time streaming integration, and growing its ecosystem and community. These enhancements would make it easier to manage and adopt compared to newer cloud-first analytic platforms. From a day-to-day operational perspective, there are a few areas where OpenText Analytics Database (Vertica) could improve to make our work smoother. Smarter automatic projection management is needed with more intelligence, auto projection creation, automatic optimization, and reduced manual testing with better workload management. Right now, monitoring queries often requires system tables and manual analysis. Troubleshooting slow queries takes time. A modern real-time dashboard showing query bottlenecks and resource users would enable quick detection. The impact could be faster issue resolution and less time spent debugging performance. Storage native interaction with modern data tools is also important. In short, from a day-to-day perspective, improvements in automatic projection optimization, better workload monitoring dashboard, easier schema evolution, and stronger modern tool integration would significantly reduce manual tuning effort and improve developer productivity. While OpenText Analytics Database (Vertica) is very powerful, these enhancements would make it more efficient for the analytics team.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"We can add almost one million columns to the solution."

"If you need availability and consistency, you can go with Cassandra."

"Cassandra has some features that are more useful for specific use cases where you have time series where you have huge amounts of writes. That should be quick, but not specifically the reads. We needed to have quicker reads and writes and this is why we are using Cassandra right now."

"The time series data was one of the best features along with auto publishing."

"Overall, I would rate Cassandra as nine because of its fast writes, which really suit our use cases mostly."

"The technical evaluation is very good."

"The most valuable features of Cassandra are its scaling capabilities and its non-SQL nature capabilities."

"The most valuable features of this solution are its speed and distributed nature."

More Cassandra pros

"Since moving to Vertica all the manual maintenance and speed issues of the Oracle data warehouse are left behind."

"Vertica handles analytics and large queries extremely well — very high performance — and on top of all of these features, Vertica has a very low total cost ownership."

"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."

"It maximize cloud economics for mission-critical big data analytical initiatives."

"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "

"A SQL-based compute platform like Vertica enables far less human overhead in operations and analytics."

"The most valuable feature of Vertica is the unmatchable database performance at a fraction of cost compared to other similar databases."

"It is enterprise ready and a hugely cheaper option than some, and in like-for-like comparisons between HP Vertica and Oracle Exadata (workload and timings), Vertica was faster than Oracle in all but the biggest and most complex of queries."

More OpenText Analytics Database (Vertica) pros

Cons

"The interface could definitely be improved. It's a technical database and for me the features are not user friendly."

"One of the issues with the solution is that you cannot drop write like you're able to in MongoDB and MySQL, where you can join tables."

"We found some issues with the batch inserts when the data volume is large."

"The secondary index in Cassandra was a bit problematic and could be improved."

"Cassandra is very complex to manage. Sometimes, I need to involve a senior DevOps engineer if we encounter a problem."

"Row-level locking is not available; might be very helpful in update use cases."

"Cassandra can improve by adding more built-in tools. For example, if you want to do some maintenance activities in the cluster, we have to depend on third-party tools. Having these tools build-in would be e benefit."

"There were challenges with the query language and the development interface. The query language, in particular, could be improved for better optimization. These challenges were encountered while using the Java SDK."

More Cassandra cons

"Pricing could be more competitive."

"More ML, both data prep, models, evaluation and workflow."

"Sometimes users write bad queries that has brought down the cluster."

"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."

"Over the last few months with the new release of Vertica, there have been stability problems. The performance should improve."

"Some GUI tools out of the box, better Python integration. I would love to see some nice query engine, tooled specifically to Vertica extensions of SQL (with IntelliSense)."

"I have found that coding support could be simplified."

"I believe the installation process could be streamlined."

More OpenText Analytics Database (Vertica) cons

Pricing and Cost Advice

"Cassandra is a free open source solution, but there is a commercial version available called DataStax Enterprise."

"I use the tool's open-source version."

"There are licensing fees that must be paid, but I'm not sure if they are paid monthly or yearly."

"We are using the open-source version of Cassandra, the solution is free."

"We pay for a license."

"I don't have the specific numbers on pricing, but it was fairly priced."

"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."

"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October)."

"It's an expensive product"

"The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."

"I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing."

"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."

"The price could be cheaper and it is best to negotiate the price."

"The price of Vertica is less expensive than some competitors, such as Teradata."

More OpenText Analytics Database (Vertica) pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which NoSQL Databases solutions are best for your needs.

See recommendations

915,341 professionals have used our research since 2012.

Answers from the Community

it_user1272297

Special Adviser Strategy at a university with 501-1,000 employees

Apr 19, 2020

Which is the best RDMBS solution for big data?

I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505

2 out of 4 answers

Russell Rothstein

CEO at PeerSpot

Jan 27, 2020

Morten, the most popular comparisons of SQream can be found here: https://www.itcentralstation.com/products/sqream-db-alternatives-and-competitors The top ones include Cassandra, MemSQL, MongoDB, and Vertica.

Read full answer

reviewer1219965

Data Architect at a tech services company with 201-500 employees

Jan 27, 2020

I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505

Read full answer

See all 4 answers

Top Industries

By visitors reading reviews

Financial Services Firm

15%

Comms Service Provider

10%

Construction Company

Outsourcing Company

Financial Services Firm

14%

Outsourcing Company

14%

Manufacturing Company

10%

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	9
Midsize Enterprise	2
Large Enterprise	14

By reviewers
Company Size	Count
Small Business	29
Midsize Enterprise	23
Large Enterprise	43

Questions from the Community

What is your experience regarding pricing and costs for Cassandra?

The pricing for Cassandra is a little bit high, so it would be better for our community services if they consider community pricing for any non-profit organization like an NGO or other things. It w...

See all answers

What needs improvement with Cassandra?

Regarding areas of improvement for Cassandra, currently, we are not facing significant issues. Some issues arise from our vendors like Apache slowness and distribution or load balancing from HAProx...

See all answers

What is your primary use case for Cassandra?

My use case for Cassandra is for a document and other unstructured data management system as well as structured data for ultra-poor member community edition, community members' PII information, so ...

See all answers

What is your experience regarding pricing and costs for Vertica?

My experience with pricing, setup cost, and licensing is limited because the organization handled the licensing and pricing as well as the cost setup.

See all answers

What needs improvement with Vertica?

OpenText Analytics Database (Vertica) is already doing great. There could be a community which could have been much more advanced and more people can be engaged so that any kind of questions, queri...

See all answers

What is your primary use case for Vertica?

The main use case for OpenText Analytics Database (Vertica) is that we have the Hive and a Hadoop layer for data availability, and Vertica serves as a big data solution. Within a Hive table, OpenTe...

See all answers

Comparisons

ClickHouse vs Cassandra

Compared 7% of the time

MongoDB Enterprise Advanced vs Cassandra

Compared 7% of the time

Neo4j Graph Database vs Cassandra

Compared 6% of the time

DataStax Enterprise vs Cassandra

Compared 6% of the time

Cloudera Distribution for Hadoop vs Cassandra

Compared 5% of the time

More Cassandra Competitors

Teradata vs OpenText Analytics Database (Vertica)

Compared 7% of the time

Snowflake vs OpenText Analytics Database (Vertica)

Compared 7% of the time

Oracle Exadata vs OpenText Analytics Database (Vertica)

Compared 5% of the time

SAP IQ vs OpenText Analytics Database (Vertica)

Compared 4% of the time

Microsoft Parallel Data Warehouse vs OpenText Analytics Database (Vertica)

Compared 4% of the time

More OpenText Analytics Database (Vertica) Competitors

Product Reports

Buyer's Guide

Cassandra

October 2026

Download Cassandra product report

Buyer's Guide

OpenText Analytics Database (Vertica)

September 2026

OpenText Analytics Database (Vertica) report

Download OpenText Analytics Database (Vertica) product report

Also Known As

No data available

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand

Overview

Cassandra is a distributed and scalable database management system used for real-time data processing.

It is highly valued for its ability to handle large amounts of data, scalability, high availability, fault tolerance, and flexible data model.

It is commonly used in finance, e-commerce, and social media industries.

Apache

OpenText Analytics Database Vertica is known for its fast data loading and efficient query processing, providing scalability and user-friendliness with a low cost per TB. It supports large data volumes with OLAP, clustering, and parallel ingestion capabilities.

OpenText Analytics Database Vertica is designed to handle substantial data volumes with a focus on speed and efficient storage through its columnar architecture. It offers advanced performance features like workload isolation and compression, ensuring flexibility and high availability. The database is optimized for scalable data management, supporting data scientists and analysts with real-time reporting and analytics. Its architecture is built to facilitate hybrid deployments on-premises or within cloud environments, integrating seamlessly with business intelligence tools like Tableau. However, challenges such as improved transactional capabilities, optimized delete processes, and better real-time loading need addressing.

What features define OpenText Analytics Database Vertica?

Fast Data Loading: Quickly ingests large data volumes.
Columnar Storage: Optimizes storage efficiency and speed.
OLAP Support: Provides robust analytics capabilities.
Advanced Compression: Enhances storage efficiency and performance.
Parallel Data Ingestion: Enables faster data processing.
Fault Tolerance: Ensures high availability and reliability.

What benefits should users expect?

Cost Efficiency: Low cost per TB is advantageous.
Scalability: Accommodates growing data needs seamlessly.
Integration Flexibility: Works well with BI tools like Tableau.
Real-Time Reporting: Delivers immediate insights for decision-making.

OpenText Analytics Database Vertica's implementation spans industries such as finance, healthcare, and telecommunications. It serves as a central data warehouse offering scalable management, high-speed processing, and geospatial functions. Companies benefit from its capacity to integrate machine learning and operational reporting, enhancing analytical capabilities.

OpenText

Sample Customers

1. Apple 2. Netflix 3. Facebook 4. Instagram 5. Twitter 6. eBay 7. Spotify 8. Uber 9. Airbnb 10. Adobe 11. Cisco 12. IBM 13. Microsoft 14. Yahoo 15. Reddit 16. Pinterest 17. Salesforce 18. LinkedIn 19. Hulu 20. Airbnb 21. Walmart 22. Target 23. Sony 24. Intel 25. Cisco 26. HP 27. Oracle 28. SAP 29. GE 30. Siemens 31. Volkswagen 32. Toyota

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.

Find out what your peers are saying about Microsoft, MongoDB, Redis and others in NoSQL Databases. Updated: September 2026.

DOWNLOAD NOW

915,341 professionals have used our research since 2012.

See our list of best NoSQL Databases vendors.

We monitor all NoSQL Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.