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

Oracle Database Appliance vs Vertica comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

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

Oracle Database Appliance
Ranking in Data Warehouse
6th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
44
Ranking in other categories
No ranking in other categories
Vertica
Ranking in Data Warehouse
5th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Cloud Data Warehouse (11th)
 

Mindshare comparison

As of April 2025, in the Data Warehouse category, the mindshare of Oracle Database Appliance is 5.2%, down from 6.5% compared to the previous year. The mindshare of Vertica is 8.6%, down from 8.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

Charu Mazumdar - PeerSpot reviewer
Simplifies database management tasks and provides high availability and disaster recovery
Oracle Database Appliance has simplified our database management tasks. Our clients are using the solution for high availability and disaster recovery. Our overall experience with the solution was good, especially the DR. Oracle Database Appliance's integrated storage solutions have enhanced our data management. Oracle Database Appliance's integration with other solutions was straightforward. We faced compatibility issues while moving from another device to this one, and the integration was not seamless. I would recommend the solution to other users. Overall, I rate the solution an 8 out of 10.
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…

Quotes from Members

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

Pros

"The product is very light."
"The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"Oracle Database Appliance provides high stability."
"The initial setup was straightforward and quick - I was able to configure everything within an hour."
"The solution's function we use to benefit the customers is database verification."
"The solution is pretty automated, which takes out the possibility of human error."
"The performance due to the all-flash of ODA is very nice."
"The most valuable feature is Vertica's performance and the ease of using the database."
"Speed and resiliency are probably the best parts of this product."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"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 extensibility and efficiency provided by their C++ SDK."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"I like the projection feature, which increases query performance."
 

Cons

"The main thing would be to make ODA more affordable, to make it a more economical machine. Also, I would like to see virtualization, so you could implement all of your functions on one machine. Finally, improvement in the speed and performance would be good."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
"The setup is a bit complex."
"The solution's initial setup is not easy."
"Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else."
"Even though the solution can handle a lot of data, it's just too expensive currently."
"Technical support is not so great. It could be much better. The maintenance, for an enterprise system, isn't so great. It's also extremely expensive."
"Oracle's product support is an area of concern where improvements are required."
"In our company, we have faced difficulties in scaling the solution for certain use cases."
"It would be great if this were a managed service in AWS."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"The integration with AI has room for improvement."
"Documentation has become much better, but can always use some improvement."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"Suboptimal projection design causes queries to not scale linearly."
"The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases."
 

Pricing and Cost Advice

"The price should be lower."
"Get benefit from the capacity-on-demand features. License your cores according to your licenses."
"I would rate the pricing a four on a scale of one (high price) to ten (low cost)."
"Oracle’s pricing is ridiculously high."
"I don’t know ODA and alternative system prices. But Oracle the database license is quite expensive and a lot of my customers plan to migrate to open source databases like PostgreSQL."
"You must pay for the license."
"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing seven and a half or eight out of ten."
"Oracle Database Application's support and maintenance are included in the contract."
"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 pricing could improve, it is a little expensive."
"The solution is relatively cost-effective."
"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."
"From a cost perspective, the software is less than most of its competitors."
"It's free up to three nodes and 1TB, and then get in contact with their sales guys."
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"The pricing and licensing depend on the size of your environment and the zone where you want to implement."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
842,767 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
29%
Computer Software Company
12%
Manufacturing Company
9%
Government
8%
Financial Services Firm
20%
Computer Software Company
18%
Manufacturing Company
8%
Real Estate/Law Firm
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Oracle Database Appliance?
Oracle Database Appliance provides high stability.
What is your experience regarding pricing and costs for Oracle Database Appliance?
While I'm somewhat familiar with standard licensing, pricing isn't really my area of expertise. However, Oracle is on the higher end of the pricing spectrum, along with SAP.
What needs improvement with Oracle Database Appliance?
There is room for improvement in better integration with third-party tools, such as Power BI or Redshift. When dealing with federated data sources, this integration can be a challenge.
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.
 

Also Known As

X5-2
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

LifeLock, Incarlopsa, Al Yusur Industrial Contracting
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Oracle Database Appliance vs. Vertica and other solutions. Updated: February 2025.
842,767 professionals have used our research since 2012.