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

OpenText Analytics Database (Vertica) vs Oracle Autonomous Data Warehouse 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 Cloud Data Warehouse
11th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (6th)
Oracle Autonomous Data Ware...
Ranking in Cloud Data Warehouse
10th
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
19
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2025, in the Cloud Data Warehouse category, the mindshare of OpenText Analytics Database (Vertica) is 5.8%, up from 5.4% compared to the previous year. The mindshare of Oracle Autonomous Data Warehouse is 5.0%, up from 4.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud 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…
Kwajah Mohiuddin - PeerSpot reviewer
Provides self-repair features, but the setup is complex
We use the product for online applications. We use it in the financial industry The product has self-repair features. The tool tunes itself. It separates compute from storage. We can scale storage and compute separately. The setup is complex. Oracle is a complex tool. I have been using Oracle…

Quotes from Members

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

Pros

"Its projections and encoding are excellent tools for tuning large volumes."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"The extensibility and efficiency provided by their C++ SDK."
"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 performance is very good and the aggregate records are fast."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"I like the projection feature, which increases query performance."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"It is a very stable tool...It is an extremely scalable tool."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"The performance and scalability are awesome."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"The solution has a self-backup, so you don't need a DBA (database administrator) to do a backup."
"It is a stable and scalable solution."
"The product has self-repair features."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
 

Cons

"We faced some challenges when trying to use the temporary tables feature."
"I have found that coding support could be simplified."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"I believe the installation process could be streamlined."
"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."
"In our company, we have faced difficulties in scaling the solution for certain use cases."
"They could improve on customer service."
"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."
"Ease of connectivity could be improved."
"The solution lacks visibility options."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle."
"The initial setup was pretty complex. It was not easy."
"Oracle Autonomous Data Warehouse is not available as an on-premises solution."
"They should make the solution more user-friendly."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
 

Pricing and Cost Advice

"Vertica is an expensive tool."
"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 pricing and licensing depend on the size of your environment and the zone where you want to implement."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"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 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."
"It's an expensive product"
"The pricing could improve, it is a little expensive."
"The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"ROI is high."
"The solution is expensive."
"On a scale from one to ten, where one is a low price and ten is a high price, I rate the pricing an eight."
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"The price depends on the configuration we choose."
"Cloud solutions are cheaper, but in the long run, they may not be much cheaper. They certainly have a lower initial cost. The licensing is yearly, and it is based on the size of the hardware and the number of users."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
861,170 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
17%
Manufacturing Company
8%
Comms Service Provider
4%
Educational Organization
18%
Financial Services Firm
12%
Computer Software Company
9%
Manufacturing Company
7%
 

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 do you like most about Oracle Autonomous Data Warehouse?
With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main...
What is your experience regarding pricing and costs for Oracle Autonomous Data Warehouse?
We pay approximately $70,000 per month. The cost includes maintenance and support.
What needs improvement with Oracle Autonomous Data Warehouse?
Optimization should be better. The SQLs are sometimes very slow. I also noticed that Java is not supported, which is not ideal.
 

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.
Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
Find out what your peers are saying about OpenText Analytics Database (Vertica) vs. Oracle Autonomous Data Warehouse and other solutions. Updated: June 2025.
861,170 professionals have used our research since 2012.