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."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."
"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."
"The analytics have been very good. We've found them to be quite useful."
"It is a stable and scalable solution."
"The product is easy to use."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"Allows us to take volumes and process them at a very high speed."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"The most valuable feature of Vertica is the unmatchable database performance."
"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."
"I enjoy the cybersecurity and backup features."
"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."
"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."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"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."
"The installation process is complex. Oracle can make the installation process better."
"Ease of connectivity could be improved."
"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 a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"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."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"We faced some challenges when trying to use the temporary tables feature."
"It should provide a GUI interface for data management and tuning."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
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 6th 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 IBM Db2 Warehouse, 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.