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 performance of the data is the most important part."
"It is the best solution for OLTP and data warehousing."
"The offloading of data to the SIM is a valuable feature."
"The tool's performance is good."
"The technical support team are real professionals. I admire their technical skills and supports. Their supports are really admirable."
"Oracle has reliable solutions and this one is no different."
"The new Exadata x9m has an even higher speed of 100GBps connectivity."
"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."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to 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."
"Allows us to take volumes and process them at a very high speed."
"Partition and join back to node are easy and simple for DBAs."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"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 has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"The performance could be improved."
"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."
"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 have a little trepidation with the system as it does have a learning curve. Also changing to a binary logging format for us feels like retrograde motion, but sadly almost all Linux variants have moved in this direction."
"Sometimes it takes too long time to get help with technical issues."
"Tech support sometimes takes some time to identify and rectify issues."
"Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly."
"Very bad support, I would rate it two out of 10."
"They could improve the integration and some of the features in the cloud version."
"The geospatial functionality could be designed better."
"The integration of this solution with ODI could be improved."
"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."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"Support is an area where it could get better."
"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."
Oracle Exadata is ranked 2nd in Data Warehouse with 124 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.