"The database is solid."
"The most valuable feature is the performance."
"The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day."
"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 pretty automated, which takes out the possibility of human error."
"It has improved my organization's functionality and performance."
"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 is very good and the aggregate records are fast."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"Allows us to take volumes and process them at a very high speed."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"I have found the solution to be scalable."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"In terms of what can be be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated within the solution."
"Oracle could improve its capacity for built-in visualization."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"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."
"Support is an area where it could get better."
"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 the integration and some of the features in the cloud version."
"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."
"They could improve on customer service."
"When it is about to reach the maximum storage capacity, it becomes slow."
"The geospatial functionality could be designed better."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
The Oracle Database Appliance saves time and money by simplifying deployment, maintenance, and support of database solutions for organizations of every size. Optimized for the world's most popular database--Oracle Database--it integrates software, compute, storage, and network resources to deliver database services for a wide range of custom and packaged online transaction processing (OLTP), in-memory database, and data warehousing applications. All hardware and software components are engineered and supported by Oracle, offering customers a reliable and secure system with built-in automation and best practices. In addition to accelerating the time to value when deploying database solutions, the Oracle Database Appliance offers flexible Oracle Database licensing options and reduces operational expenses associated with maintenance and support.
Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.
To learn more about Micro Focus Vertica Advanced Analytics, visit our website.
Oracle Database Appliance is ranked 5th in Data Warehouse with 5 reviews while Vertica is ranked 3rd in Data Warehouse with 11 reviews. Oracle Database Appliance is rated 8.0, while Vertica is rated 9.2. The top reviewer of Oracle Database Appliance writes "Affordable, user-friendly, and offers good technical support". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, SAP BW4HANA, IBM Netezza Performance Server and IBM Integrated Analytics System, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, SQL Server and Oracle Exadata. See our Oracle Database Appliance vs. Vertica report.
See our list of best 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.