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
88
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

"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The most valuable feature of Vertica is the unmatchable database performance."
"Initiate on one node, and the RPM propagates automatically to all other nodes. ​"
"Its projections and encoding are excellent tools for tuning large volumes."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"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 reason we use it."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"It is a stable and scalable solution."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"The analytics have been very good. We've found them to be quite useful."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"Self-patching and runs machine-learning across its logs all the time"
 

Cons

"The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases."
"It should provide a GUI interface for data management and tuning."
"OpenText Analytics Database (Vertica) does not have a cloud-based UI that Snowflake has, which features a very good comprehensive GUI for querying and analyzing data."
"The integration with AI has room for improvement."
"It needs integration with multiple clouds."
"Very bad support, I would rate it two out of 10."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"A lot of the tools that were previously there have now been taken away."
"Ease of connectivity could be improved."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."
"We are not satisfied with the technical support. Their understanding is lacking."
"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."
"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."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
 

Pricing and Cost Advice

"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."
"Read the fine print carefully."
"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."
"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."
"It's free up to three nodes and 1TB, and then get in contact with their sales guys."
"The pricing could improve, it is a little expensive."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"It is fast to purchase through the AWS Marketplace."
"The price depends on the configuration we choose."
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"The solution is expensive."
"You pay as you go, and you don't pay for services that you don't use."
"ROI is high."
"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."
"The solution's cost is reasonable."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
882,410 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 Enterprise41
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,410 professionals have used our research since 2012.