We performed a comparison between SAP HANA and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about SAP, Oracle, Progress Software and others in Embedded Database Software."The most valuable features are the flexibility and the integration with other solutions in data quality."
"What's most valuable in SAP HANA is that it covers the business process systems of my company. The solution also helps because it makes almost everything automated. Another valuable feature of SAP HANA is that it can be integrated with third parties and other enhancements needed by the company."
"The solution offers advanced features that the company was struggling to implement."
"SAP HANA's best features are its programmability and extensibility - you can size and shape the software however you need."
"SAP HANA is vertically and horizontally scalable."
"When we upgraded, we received more functions or more features."
"The in-memory database is excellent."
"The solution is easy to manage enterprise resources and the reporting and analytics are including. It is good for company growth and all module are managed well."
"The most valuable feature of Vertica is the unmatchable database performance."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"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."
"Allows us to take volumes and process them at a very high speed."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"I have found the solution to be scalable."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"The relationship with a partner that sells SAP could be better. We depend much more on our own development, and the partner is for selling us the solutions, so we need them to be able to supply help and answers. The partner isn't very helpful, and we have to rely on our own knowledge and research."
"HANA could be improved by adding analytics and development models in the institution."
"It would be nice to know when SAP plans to stop its maintenance of a previous version of SAP ECC ERP because, at this point, anyone utilizing SAP will have no choice but to go on S/4HANA Database."
"The product lacks some flexibility in its settings and configurations."
"The pricing is expensive."
"It's a complex initial setup."
"The performance and integration with other products are areas in need of improvement."
"There could be better management for faster updates, last year there were some changes in India to the e-invoicing feature."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"We faced some challenges when trying to use the temporary tables feature."
"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."
"Support is an area where it could get better."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"The biggest problem is the cost of cloud deployment."
SAP HANA is ranked 1st in Embedded Database Software with 33 reviews while Vertica is ranked 4th in Data Warehouse with 14 reviews. SAP HANA is rated 8.4, while Vertica is rated 8.6. The top reviewer of SAP HANA writes "Very robust solution with good data access". On the other hand, the top reviewer of Vertica writes "Enhanced capabilities, good customer service, large data scalability and stable". SAP HANA is most compared with Oracle Database, SQL Server, MySQL, IBM Db2 Database and SAP IQ, whereas Vertica is most compared with Snowflake, Teradata, Amazon Redshift, SQL Server and IBM Netezza Performance Server.
We monitor all Embedded Database Software 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.
