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 Dec 28, 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
12th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
87
Ranking in other categories
Data Warehouse (10th)
Oracle Autonomous Data Ware...
Ranking in Cloud Data Warehouse
11th
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
19
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of February 2026, in the Cloud Data Warehouse category, the mindshare of OpenText Analytics Database (Vertica) is 5.7%, up from 5.6% compared to the previous year. The mindshare of Oracle Autonomous Data Warehouse is 5.7%, up from 4.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse Market Share Distribution
ProductMarket Share (%)
Oracle Autonomous Data Warehouse5.7%
OpenText Analytics Database (Vertica)5.7%
Other88.6%
Cloud Data Warehouse
 

Featured Reviews

PS
Senior Software Engineer at a tech vendor with 5,001-10,000 employees
Reporting has become faster and more cost-effective but data cleanup and writes still need work
The best features OpenText Analytics Database (Vertica) offers are that it is parallel, with Massively Parallel Processing (MPP), and it is a columnar database. It works in append-only mode, which is ideal for analytics and read queries. Additionally, I can use it in Eon Mode in which I can store the data in cheaper storage such as Amazon S3 and have different compute nodes. That helped me save costs. Beyond that, it is massively scalable, which was quite useful for our fintech use case. The read speed was excellent, and the data compression is good. OpenText Analytics Database (Vertica) has positively impacted our organization by helping us reduce storage costs and improve reporting efficiency in our fintech company. The analytics team could run reports much faster, and we saved significant costs on compute and storage, especially with Eon mode and compression.
reviewer1297710 - PeerSpot reviewer
IT Administrator at a manufacturing company with 1,001-5,000 employees
Analytics and data security needs are met but optimization requires improvement
We are using Oracle Autonomous Data Warehouse for analytics in my company The solution is used for analytics and it works for our data security needs. We continue to use it with satisfaction. Optimization should be better. The SQLs are sometimes very slow. I also noticed that Java is not…

Quotes from Members

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

Pros

"Eighty percent of the ETL operations have improved since implementing this solution."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"It has improved my organization's functionality and performance."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"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."
"The product is easy to use."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"The solution is used for analytics and it works for our data security needs."
"The analytics have been very good. We've found them to be quite useful."
"The product has self-repair features."
"The solution is used for analytics and it works for our data security needs."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
 

Cons

"I have found that coding support could be simplified."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"In our company, we have faced difficulties in scaling the solution for certain use cases."
"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."
"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."
"Documentation has become much better, but can always use some improvement."
"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."
"The setup is complex."
"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."
"Optimization should be better."
"The solution lacks visibility options."
"A lot of the tools that were previously there have now been taken away."
"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."
"Oracle Autonomous Data Warehouse is not available as an on-premises solution."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
 

Pricing and Cost Advice

"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."
"Vertica is an expensive tool."
"The solution is free and we pay for the storage."
"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."
"From a cost perspective, the software is less than most of its competitors."
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"It is fast to purchase through the AWS Marketplace."
"The price depends on the configuration we choose."
"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."
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"The solution's cost is reasonable."
"The cost is perfect with Oracle Universal credit."
"In terms of architecture and pricing structure, I feel it is a little bit costly compared to Azure. It's fine compared to RedShift, but compared to Azure, it's a bit pricey when you calculate for one TB storage plus around five hours of reporting with the frequency of 1TB data. The cost adds up, making Oracle a bit expensive."
"You pay as you go, and you don't pay for services that you don't use."
"ROI is high."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
882,207 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
14%
Manufacturing Company
8%
Comms Service Provider
5%
Manufacturing Company
10%
Media Company
8%
Computer Software Company
8%
Insurance Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise23
Large Enterprise39
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise1
Large Enterprise11
 

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 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.
What is your primary use case for Oracle Autonomous Data Warehouse?
We are using Oracle Autonomous Data Warehouse for analytics in my company.
 

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: February 2026.
882,207 professionals have used our research since 2012.