OpenText Analytics Database (Vertica) vs Oracle NoSQL comparison

Why PeerSpot?

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

OpenText Analytics Database...

Read 90 OpenText Analytics Database (Vertica) reviews

10,194 Views
5,913 Comparison Views

91% willing to recommend

Oracle NoSQL

Read 8 Oracle NoSQL reviews

1,925 Views
1,829 Comparison Views

100% willing to recommend

OpenText Analytics Database...

Oracle NoSQL

Comparison Buyer's Guide

Download the report

Executive Summary

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

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

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

Buyer's Guide

NoSQL Databases

October 2026

Download the complete report

Helped 920,929 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

OpenText Analytics Database...

Average Rating

8.2

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Warehouse (5th), Cloud Data Warehouse (12th)

Oracle NoSQL

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

NoSQL Databases (16th)

Featured Reviews

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

Susantha Kumar

Support on banking at Aithent

Handles large data volumes effectively but connection issues require attention

The Oracle NoSQL solution is used primarily for storing data for our web applications. We work alongside the DBA team for this purpose, given that specific departments manage aspects of its use. We choose it specifically to handle large scales of data, such as in one of our bank customer's scenarios using more than nine hundred gigabytes of data.

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

"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."

"We could run group by queries thousand of times faster, we are able to test more models and improve accuracy."

"We can also load massive amounts of data in seconds and query it with SLA for online dashboards."

"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."

"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."

"The service and support from Vertica was excellent. Every tech and sales rep I dealt with was very responsive, pleasant, and helped me solve any engineering issues we ran into in very short order."

"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."

"Before we used Vertica we used another columnar database which turned out to be very unstable and its performance was inconsistent, Vertica turned that around, to the point that it is now our go-to database."

More OpenText Analytics Database (Vertica) pros

"The product meets expectations when it comes to stability."

"NoSQL has high availability; I think it's perfect from a technical perspective, and it's quick to run and go."

"Try it! You’ll be impressed."

"So far, we find stability to be very reasonable, it is dependable and we do not have any big issues."

"The tool is easy to learn."

"With Oracle NoSQL, our clients have a highly scalable, simple to set up database that performs very well when data is organized correctly from the beginning."

"Oracle NoSQL is pretty scalable."

"The features I've found to be most valuable are the speed of reading and writing (read/write performance levels are really high), the transactions model (semantics for data manipulation), and just the overall simplicity of using it."

More Oracle NoSQL pros

Cons

"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."

"Customer Service: It was a green field solution, and getting quick customer service was a challenge."

"Node recovery is very inconsistent and impacts performance."

"If your product has lots of concurrent queries this solution is not suitable for you, or you need to implement a cache layer."

"It is usually very stable, but we occasionally see some nodes going down."

"Even with some optimization (adding projections for merge joins and grouped by pipelined), it's still taking a longer time than a Spark job in some cases."

"Suboptimal projection design causes queries to not scale linearly."

"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."

More OpenText Analytics Database (Vertica) cons

"The main areas that need improvement with NoSQL are in the area of big data and user-friendly presentation."

"I would rate Oracle NoSQL six or 6.5 out of ten based on my experience."

"Focusing on making the administration easier compared to other solutions like MongoDB could be beneficial. Simplifying the administrative tasks could enhance the user experience."

"You will get high performance when you organize your data correctly at the beginning. Otherwise, there are instability issues."

"The installation is difficult."

"Handling big data in a user-friendly way is currently a bit of an issue. The dashboard for this needs some work."

"We've had some issues with stability. During our testing, we were able to drop an entire database by writing huge amounts of data."

"Oracle could improve how NoSQL works in containers. I don't think NoSQL needs any new features, but I want to see new features in the Oracle Cloud Infrastructure. I would like to see some improvements in OCI's building options."

More Oracle NoSQL cons

Pricing and Cost Advice

"The pricing and licensing depend on the size of your environment and the zone where you want to implement."

"Vertica is an expensive tool."

"The pricing for this solution is very reasonable compared to other vendors."

"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."

"It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."

"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."

"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."

"It's free up to three nodes and 1TB, and then get in contact with their sales guys."

More OpenText Analytics Database (Vertica) pricing and cost advice

"The product is expensive and Oracle could work to lower the licensing cost."

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

920,929 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

16%

Outsourcing Company

13%

Manufacturing Company

10%

Comms Service Provider

Financial Services Firm

14%

Outsourcing Company

14%

Comms Service Provider

10%

Construction Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

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

By reviewers
Company Size	Count
Midsize Enterprise	3
Large Enterprise	5

Questions from the Community

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

What is your experience regarding pricing and costs for Oracle NoSQL?

We use the enterprise edition of Oracle NoSQL.

See all answers

What needs improvement with Oracle NoSQL?

Sometimes we face problems with the connection between our applications and the database. It may be due to network issues or performance issues on Oracle's side. Our DBA team requests validations f...

See all answers

What is your primary use case for Oracle NoSQL?

We use Oracle NoSQL ( /products/oracle-nosql-reviews ) to store data for our web applications. It is being used for customer projects, and we handle one of our bank customers using more than nine h...

See all answers

Comparisons

Teradata vs OpenText Analytics Database (Vertica)

Compared 7% of the time

Snowflake vs OpenText Analytics Database (Vertica)

Compared 6% of the time

Oracle Exadata vs OpenText Analytics Database (Vertica)

Compared 5% of the time

Microsoft Parallel Data Warehouse vs OpenText Analytics Database (Vertica)

Compared 5% of the time

SAP IQ vs OpenText Analytics Database (Vertica)

Compared 4% of the time

More OpenText Analytics Database (Vertica) Competitors

Cloudera Distribution for Hadoop vs Oracle NoSQL

Compared 20% of the time

MongoDB Enterprise Advanced vs Oracle NoSQL

Compared 13% of the time

Cassandra vs Oracle NoSQL

Compared 11% of the time

Amazon QLDB vs Oracle NoSQL

Compared 10% of the time

MarkLogic vs Oracle NoSQL

Compared 3% of the time

More Oracle NoSQL Competitors

Product Reports

Buyer's Guide

OpenText Analytics Database (Vertica)

October 2026

OpenText Analytics Database (Vertica) report

Download OpenText Analytics Database (Vertica) product report

Buyer's Guide

NoSQL Databases

October 2026

Download Oracle NoSQL product report

Also Known As

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand

No data available

Overview

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

Oracle NoSQL is known for its distributed architecture, which ensures scalability and high availability, making it ideal for handling substantial data across diverse applications.

Oracle NoSQL leverages its distributed nature to offer automatic load balancing and powerful schema evolution tools. With features such as a Java table API and seamless integration with Oracle Database, it efficiently manages unstructured data and supports high read/write operations. Departments dealing with large-scale data benefit from fast data retrieval and effective data replication, with support agreements facilitating easy management.

What are Oracle NoSQL's key features?

Distributed Architecture: Ensures data availability and scalability.
Automatic Load Balancing: Distributes workloads evenly across servers.
Table API for Java: Facilitates integration with Java applications.
Powerful Schema Evolution: Allows changes without downtime.
Efficient Data Replication: Supports high availability and disaster recovery.

What benefits should users expect?

High Performance: Fast data retrieval for large datasets.
Seamless Integration: Compatibility with Oracle Database enhances usability.
Easy Data Management: Simplifies handling of unstructured data.
Scalability: Supports future data growth effortlessly.

In telecom solutions, Oracle NoSQL helps store structured data and logs, supporting relational databases. It plays a crucial role in banking by managing over 900 gigabytes of data, facilitating data fetching and updates efficiently. Its implementation across infrastructure and web applications highlights its robustness in varied use cases.

Oracle

Sample Customers

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

Airbus, Globacom, WebAction

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

DOWNLOAD NOW

920,929 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.