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 solution is pretty automated, which takes out the possibility of human error."
"The product’s valuable feature is its capability to pre-configure and pre-install the settings."
"The performance due to the all-flash of ODA is very nice."
"The product is very light."
"Oracle Database Appliance provides high stability."
"The main feature is the management and manageability of the tool. We can create a VM on a laptop within a couple of clicks."
"We primarily use it for OLTP, which has improved our costs."
"The most valuable feature of Oracle Database Appliance is the ease of management."
"Allows us to take volumes and process them at a very high speed."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"The most valuable feature is Vertica's performance and the ease of using the database."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"In my opinion only one single command should be used for all ODA models, as it’s confusing."
"It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."
"Sometimes, we cannot upgrade or patch it easily. The performance needs to improve."
"I would like it if the scalability could be increased without having to change versions."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"Oracle Database Appliance patching comes out two to three months after the regular patching cycle."
"The setup is a bit complex."
"Support is an area where it could get better."
"It would be great if this were a managed service in AWS."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"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."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"The integration of this solution with ODI could be improved."
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.