Compare Oracle Autonomous Data Warehouse vs. Vertica

Oracle Autonomous Data Warehouse is ranked 6th in Cloud Data Warehouse with 4 reviews while Vertica is ranked 3rd in Cloud Data Warehouse with 7 reviews. Oracle Autonomous Data Warehouse is rated 8.8, while Vertica is rated 9.2. The top reviewer of Oracle Autonomous Data Warehouse writes "Saves time by allowing me to simply load my data and go". On the other hand, the top reviewer of Vertica writes "Allows us to take volumes and process them at a very high speed". Oracle Autonomous Data Warehouse is most compared with Snowflake, Microsoft Azure SQL Data Warehouse and Amazon Redshift, whereas Vertica is most compared with Snowflake, Apache Hadoop and Amazon Redshift. See our Oracle Autonomous Data Warehouse vs. Vertica report.
Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. Vertica and other solutions. Updated: March 2020.
406,607 professionals have used our research since 2012.
Quotes From Members

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

Pros
The analytics have been very good. We've found them to be quite useful.I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system.I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW.Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets.

Read more »

The performance is very good and the aggregate records are fast.Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.Allows us to take volumes and process them at a very high speed.Eighty percent of the ETL operations have improved since implementing this solution.It maximize cloud economics for mission-critical big data analytical initiatives.It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands.Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics.Any novice user can tune vertical queries with minimal training (or no training at all).

Read more »

Cons
Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable.I would like to see an on-premise solution in the future.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.An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud.

Read more »

When it is about to reach the maximum storage capacity, it becomes slow.Support is an area where it could get better.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.Fact-to-fact joins on multi-billion record tables perform poorly.It needs integration with multiple clouds.It should provide a GUI interface for data management and tuning.Monitoring tools need to be lightweight. They should not take up heavy resources of the main server.If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer.

Read more »

Pricing and Cost Advice
The cost is perfect with Oracle Universal credit.

Read more »

It is fast to purchase through the AWS Marketplace.The pricing and licensing depend on the size of your environment and the zone where you want to implement.Read the fine print carefully.

Read more »

report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
406,607 professionals have used our research since 2012.
Ranking
6th
Views
2,061
Comparisons
1,300
Reviews
4
Average Words per Review
366
Avg. Rating
8.8
3rd
Views
16,008
Comparisons
8,979
Reviews
7
Average Words per Review
199
Avg. Rating
9.1
Top Comparisons
Compared 17% of the time.
Compared 13% of the time.
Compared 12% of the time.
Also Known As
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Learn
Oracle
Video Not Available
Micro Focus
Overview

Autonomous Data Warehouse is market-leading Oracle Database software running on proven Oracle Exadata infrastructure that is optimized to deliver unbeatable performance for data warehouse workloads. Built-in adaptive machine learning eliminates manual labor for administrative management. With Oracle, business and enterprise users can now build their own data warehouse, data mart, or sandbox in a few minutes.

Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

Offer
Learn more about Oracle Autonomous Data Warehouse
Learn more about Vertica
Sample Customers
Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-TankCerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Top Industries
VISITORS READING REVIEWS
Software R&D Company61%
Comms Service Provider10%
K 12 Educational Company Or School4%
Construction Company4%
REVIEWERS
Software R&D Company21%
Media Company21%
Marketing Services Firm17%
Comms Service Provider14%
VISITORS READING REVIEWS
Software R&D Company37%
Comms Service Provider21%
Media Company7%
Financial Services Firm5%
Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. Vertica and other solutions. Updated: March 2020.
406,607 professionals have used our research since 2012.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.