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 data replication is very good."
"The performance on the databases is good."
"The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain."
"This product can noticeably enhance performance of contextual Oracle databases."
"On-premises Exadata is just as stable as the cloud version. It's a very stable platform."
"Exadata with the In-Memory option is several levels about SAP HANA."
"Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement."
"The ease of setup is an eight out of ten."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"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."
"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."
"Partition and join back to node are easy and simple for DBAs."
"It would be good if Exadata made some new features available regarding data retrieval and speed capacity functions."
"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."
"Checking the Smart Scan issues is complicated."
"Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly."
"We used the support from Oracle Exadata to complete the implementation."
"Oracle Exadata could improve by having faster data retrieval. We receive data at four or five seconds and want to reduce that number to one second."
"We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components."
"The biggest problem is the cost of cloud deployment."
"Limitations in group by projections is where I would like to see an improvement."
"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."
"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."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"They could improve on customer service."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"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."
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 "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.