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."The most valuable features of the solution revolve around its performance, simplicity, and its installation phase."
"The product is very light."
"The most valuable feature is the performance."
"I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes."
"We use the solution for our Java applications."
"The most valuable feature of Oracle Database Appliance is the ease of management."
"The solution is simple to use and easy to maintain."
"Oracle has good technical support."
"Speed and resiliency are probably the best parts of this product."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"I enjoy the cybersecurity and backup features."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"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."
"The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface."
"Oracle could improve its capacity for built-in visualization."
"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 solution's initial setup is not easy."
"I would like it if the scalability could be increased without having to change versions."
"Even though the solution can handle a lot of data, it's just too expensive currently."
"I would be happy to see the Oracle Auto Service Request (ASR) pre-installed in it instead of installing it in a separate machine."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Very bad support, I would rate it two out of 10."
"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."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Limitations in group by projections is where I would like to see an improvement."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
Oracle Database Appliance is ranked 6th in Data Warehouse with 39 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. Oracle Database Appliance is rated 8.0, while Vertica is rated 8.4. The top reviewer of Oracle Database Appliance writes "Stable solution with opportunities for performance enhancement". 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.