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 most valuable feature is that you have the same familiar environment of an Oracle database but with the additional performance you get from this architecture."
"Oracle is known to be the number one in their industry; the help and support, the features they are giving the clients comparing to other databases, the new technology, the provide a good solution."
"Exadata is also a very stable environment. Their Smart Scan feature is great for every banking environment and financial institutions willing to implement it."
"We have used this solution for a long period of time so it has become easy for us to query any kind of data from Oracle Exadata which has been valuable."
"The tool's performance is good."
"Compression is a great feature, where one can really save a lot of storage."
"They just have a lot of products, and they work well together."
"Oracle is easy to use for peripheral things, such as the data vault and the data firewall, data sync, and partitions. These are the features that give an edge to other databases."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"I have found Oracle Exadata to be scalable. However, you have to purchase more hardware, such as memory."
"It's too expensive per terabyte. It's complex."
"Certification should also be improved. Today, Oracle doesn't certify applications with engineered systems."
"The handling of temp space has room for improvement."
"Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly."
"Tech support sometimes takes some time to identify and rectify issues."
"We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components."
"Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up."
"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."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"I have found that coding support could be simplified."
"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 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 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."
Oracle Exadata is ranked 2nd in Data Warehouse with 124 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. Oracle Exadata is rated 8.4, while Vertica is rated 8.4. The top reviewer of Oracle Exadata writes "Very fast, scalable, stable, and demonstrates good performance". 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.