We performed a comparison between Oracle Exadata and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The ease of setup is an eight out of ten."
"They just have a lot of products, and they work well together."
"On-premises Exadata is just as stable as the cloud version. It's a very stable platform."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"Complete management occurs from one single address instead of different servers."
"The most valuable feature is storage offloading."
"The data replication is very good."
"The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"The product's initial setup phase is extremely simple."
"The most valuable feature is Vertica's performance and the ease of using the database."
"Eighty percent of the ETL operations have improved since implementing this solution."
"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 setup is a little bit complex. We would like to see the installation part get easier."
"I would like to see more database features and maybe more archiving features, because we need to do data archiving."
"I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination."
"A room for improvement in Oracle Exadata is that it's not very easy to use in a microservices environment. It's not easy to split databases, and if this was easier to do in Oracle Exadata, it would make the solution better. What I'd like to see in the next release of Oracle Exadata is for it to become more modular, so you can use it in a context where the data layer is spread between many independent services."
"The scalability can be improved as it is not a parallel execution."
"The integration with third-party applications regarding access management security could be better."
"The handling of temp space has room for improvement."
"I have found Oracle Exadata to be scalable. However, you have to purchase more hardware, such as memory."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"We faced some challenges when trying to use the temporary tables feature."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"When it is about to reach the maximum storage capacity, it becomes slow."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"It should provide a GUI interface for data management and tuning."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
Oracle Exadata is ranked 2nd in Data Warehouse with 125 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Oracle Exadata is rated 8.4, while Vertica is rated 8.2. The top reviewer of Oracle Exadata writes "Offers a variety of valuable features". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Oracle Exadata is most compared with Oracle Database Appliance, Teradata, Oracle Autonomous Data Warehouse, Snowflake and Apache Hadoop, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and BigQuery. See our Oracle Exadata vs. Vertica report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.