We performed a comparison between Oracle Autonomous Data Warehouse and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Self-patching and runs machine-learning across its logs all the time"
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"It is a stable and scalable solution."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"A very good integration feature that restricts access to unauthorized people."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"The most valuable feature of Vertica is the unmatchable database performance."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"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)."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"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."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"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."
"Ease of connectivity could be improved."
"The solution lacks visibility options."
"The installation process is complex. Oracle can make the installation process better."
"A lot of the tools that were previously there have now been taken away."
"I would like to see an on-premise solution in the future."
"Documentation has become much better, but can always use some improvement."
"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."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"The biggest problem is the cost of cloud deployment."
"We faced some challenges when trying to use the temporary tables feature."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews while Vertica is ranked 7th in Cloud Data Warehouse with 83 reviews. Oracle Autonomous Data Warehouse is rated 8.6, while Vertica is rated 8.2. The top reviewer of Oracle Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Apache Hadoop, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata. See our Oracle Autonomous Data Warehouse vs. Vertica report.
See our list of best Cloud Data Warehouse vendors.
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.