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, Firebird and others in Embedded Database."The solution is extremely stable. That's the most important aspect of the solution, for our organization. There is no downtime, and the performance is very good."
"The in-memory computing and the efficient response time are very good features."
"We use SAP HANA for Master Data Governance."
"The solution is very stable."
"It is difficult for me to narrow down what the best features are in SAP HANA because they work together to provide the overall functionality of the solution. However, the Fiori application is very good."
"It is very stable and very innovative. You can integrate many applications with it."
"The best feature of SAP HANA is column computing. The computing speed of the solution is also very high, so developers can easily develop programs through SAP HANA."
"As I only worked part-time on SAP HANA, I did not have the opportunity to explore the advanced features of the solution. However, I did work with basic features, such as user administration and access controls for the accounting department. The feature that stood out to me the most was the Single Sign-On and user administration, backup, and server management. My experience with SAP HANA was mainly focused on basic server improvements."
"The extensibility and efficiency provided by their C++ SDK."
"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."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Speed and resiliency are probably the best parts of this product."
"I have found the solution to be scalable."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"I think that the pricing is high and it needs improvement."
"I would like more technical documentation. I would like it to be easier to find online help or have a better launch-based service. SAP has a lot of functions, so we need more best practices and more detailed documentation on industry solutions. For example, it would be good to have documentation on why a certain process needs to be set up and which kinds of configurations need to be set up."
"The worst thing about SAP HANA is the price; it's very expensive. The licensing cost, implementation cost, hosting cost, and appliance cost are all high."
"The releases need to be more stable. It's surprising to still encounter significant bugs after ten years of the product being available."
"When we are using SAP HANA we have some difficulty with the customization. We would like to be able to add and make customized menus."
"The solution is very expensive for us."
"Unlike other databases, it lacks management features that legacy databases like Oracle or SQL servers have. They need to make the solution easier to manage and offer tools that make management more effective. A lot of things you have on traditional databases you have to develop into HANA."
"I'd just like to see some more improvements done on the training, both on the functional training and technical training sides as a part of the complete solution."
"It should provide a GUI interface for data management and tuning."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"Suboptimal projection design causes queries to not scale linearly."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
SAP HANA is ranked 1st in Embedded Database with 81 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. SAP HANA is rated 8.4, while Vertica is rated 8.2. The top reviewer of SAP HANA writes "Excellent compatibility between modules and the control". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". SAP HANA is most compared with Oracle Database, SQL Server, MySQL, IBM Db2 Database and Amazon Aurora, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and MongoDB.
We monitor all Embedded Database 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.