We performed a comparison between Oracle Big Data Appliance and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard."
"This is a comprehensive solution that is easy to deploy."
"The most valuable feature of Vertica is the unmatchable database performance."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Eighty percent of the ETL operations have improved since implementing this solution."
"The solution is quick, has good compression data, and is not expensive."
"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."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"The product should be simplified for the average user."
"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera."
"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
"Suboptimal projection design causes queries to not scale linearly."
"They could improve on customer service."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"The integration of this solution with ODI could be improved."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"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."
"I believe the installation process could be streamlined."
"The biggest problem is the cost of cloud deployment."
Oracle Big Data Appliance is ranked 12th in Data Warehouse with 5 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Oracle Big Data Appliance is rated 8.0, while Vertica is rated 8.2. The top reviewer of Oracle Big Data Appliance writes "Fast, and you don't need technical expertise to use it and produce results". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Oracle Big Data Appliance is most compared with Oracle Exadata, Apache Hadoop, Teradata and Microsoft Azure Synapse Analytics, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
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.