Try our new research platform with insights from 80,000+ expert users

OpenText Analytics Database (Vertica) vs Oracle Big Data Appliance comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jun 19, 2025

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...
Ranking in Data Warehouse
7th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Cloud Data Warehouse (10th)
Oracle Big Data Appliance
Ranking in Data Warehouse
13th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
6
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of August 2025, in the Data Warehouse category, the mindshare of OpenText Analytics Database (Vertica) is 7.8%, down from 9.3% compared to the previous year. The mindshare of Oracle Big Data Appliance is 1.4%, up from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…
Mohammed Hamad - PeerSpot reviewer
Provides clean, centralized data
From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera. Oracle could also improve Big Data Appliance by having one technology on their stack and working on it instead of continually changing the name or technologies or features. In addition, they could have a program to enable their partners to use this technology because right now, I have to have an expert to use the AI elements.

Quotes from Members

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

Pros

"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."
"Vertica uses advanced Azure technologies to compress raw data using indexing, allowing a large amount of data to be stored with minimal physical space. Advanced algorithms are employed in data compression."
"Allows us to take volumes and process them at a very high speed."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"The solution is quick, has good compression data, and is not expensive."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"This is a comprehensive solution that is easy to deploy."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard."
 

Cons

"It should provide a GUI interface for data management and tuning."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"In our company, we have faced difficulties in scaling the solution for certain use cases."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Very bad support, I would rate it two out of 10."
"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."
"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera."
"The product should be simplified for the average user."
 

Pricing and Cost Advice

"The solution is free and we pay for the storage."
"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."
"Vertica is an expensive tool."
"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​"
"From a cost perspective, the software is less than most of its competitors."
"The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
"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."
"Oracle's prices are too high compared to others in the market."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
865,384 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
16%
Manufacturing Company
9%
Comms Service Provider
4%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
What needs improvement with Oracle Big Data Appliance?
Areas of Oracle Big Data Appliance that can be improved include the pricing perspective because nowadays they have competition. We have so many technologies that have come to the market for less th...
What is your primary use case for Oracle Big Data Appliance?
The typical use case for Oracle Big Data Appliance, which my clients use, is usually that the customer who has an Oracle application uses it because they can leverage the storage part. I don't need...
 

Also Known As

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
No data available
 

Overview

 

Sample Customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Caixa Bank
Find out what your peers are saying about OpenText Analytics Database (Vertica) vs. Oracle Big Data Appliance and other solutions. Updated: August 2025.
865,384 professionals have used our research since 2012.