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
5th
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
8th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Cloud Data Warehouse (11th)
 

Mindshare comparison

As of June 2025, in the Data Warehouse category, the mindshare of Oracle Database Appliance is 5.3%, down from 6.2% compared to the previous year. The mindshare of Vertica is 7.9%, down from 9.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

Ahmed-Yehia - PeerSpot reviewer
Enhanced performance and simplified operations with integrated features
All improvements for ODA are already applied or enhanced in Exadata. ODA is mainly for small businesses or limited businesses and is used predominantly for database warehouses and not for OLTP databases. You can only scale storage, not developer nodes. It's priced a little higher, which could be optimized for small or medium businesses.
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 database is solid."
"The most valuable feature is the ease of dashboarding and ease of reporting."
"We use the solution for our Java applications."
"I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes."
"The most valuable feature is the ease of dashboarding and ease of reporting."
"The solution's function we use to benefit the customers is database verification."
"Oracle Database Appliances are specifically designed for Oracle databases. They have built-in utilities and tools that simplify management, making them the best option for Oracle database management systems."
"The product is very light."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"The performance is very good and the aggregate records are fast."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. ​"
"The extensibility and efficiency provided by their C++ SDK."
 

Cons

"Sometimes, we cannot upgrade or patch it easily. The performance needs to improve."
"Oracle Database Appliance patching comes out two to three months after the regular patching cycle."
"Oracle could improve its capacity for built-in visualization."
"The product's pricing is too high. We plan to migrate to another database in three to four years."
"Oracle Database Appliance could improve by having better integration."
"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."
"Virtualization needs improvement. It's not easy to back up the virtual machines in the Oracle VM architecture. I would also like to see native support for Veeam Backup Software."
"The setup is a bit complex."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"I have found that coding support could be simplified."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"The integration with AI has room for improvement."
"Support is an area where it could get better."
"It would be great if this were a managed service in AWS."
 

Pricing and Cost Advice

"Compared to Oracle Exadata, Oracle Database Appliance is affordable."
"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
"You must pay for the license."
"Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE."
"Oracle Database Appliance is a very expensive solution. If you have opted for the on-premises licenses from Oracle, then you have to pay yearly. If you have opted for the cloud subscriptions offered by Oracle, then you can pay either monthly or yearly."
"Oracle Database Application's support and maintenance are included in the contract."
"I would rate the pricing a four on a scale of one (high price) to ten (low cost)."
"The price of the solution should be less expensive. However, they will increase the price more."
"The solution is free and we pay for the storage."
"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​"
"The pricing could improve, it is a little expensive."
"The price of Vertica is less expensive than some competitors, such as Teradata."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"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."
"Read the fine print carefully."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
856,873 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
7%
Financial Services Firm
19%
Computer Software Company
18%
Manufacturing Company
7%
University
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: May 2025.
856,873 professionals have used our research since 2012.