We performed a comparison between Oracle Database Appliance 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."I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes."
"The most valuable feature of the solution is the ability to combine all the data without the need for additional devices."
"The performance of the system is the solution's most valuable aspect. In combination with the database, it gives perfect results. It's a better system than using other kinds of integrated systems. In general, the ODA control is much simpler to use and offers up the best performance."
"NVM Express (NVMe) solid-state drives: This technology brings outstanding I/O performance for midsize databases. We have tested it by doing POCs on customer sites and the results were quite satisfying."
"The product is very light."
"Oracle Database Appliance provides high stability."
"If the database goes down on one of the servers, the load is automatically shifted to another server. You can troubleshoot the one that is down without affecting uptime."
"The solution is simple to use and easy to maintain."
"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 solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"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."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"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 extensibility and efficiency provided by their C++ SDK."
"I enjoy the cybersecurity and backup features."
"Even though the solution can handle a lot of data, it's just too expensive currently."
"If we were able to use Oracle Database to create mobile apps, that would be great. I don't know multiple languages, like Java, etc. I need to learn a separate language, right now in order to do this."
"The product's technical support services need improvement."
"The main thing would be to make ODA more affordable, to make it a more economical machine. Also, I would like to see virtualization, so you could implement all of your functions on one machine. Finally, improvement in the speed and performance would be good."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"Virtualization needs improvement. It's not easy to back up the virtual machines in the Oracle VM architecture. I would also like to see native support for Veeam Backup Software."
"Sometimes, we cannot upgrade or patch it easily. The performance needs to improve."
"Support is an area where it could get better."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"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."
"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's native cloud support could be improved, and its installation could be made easier."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"The biggest problem is the cost of cloud deployment."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
Oracle Database Appliance is ranked 6th in Data Warehouse with 40 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Oracle Database Appliance is rated 8.0, while Vertica is rated 8.2. The top reviewer of Oracle Database Appliance writes "Simplifies database management tasks and provides high availability and disaster recovery". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and Azure Data Factory, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata. See our Oracle Database Appliance 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.