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."We have found the solution to be customizable and it is beneficial it comes as a bundled package. Additionally, it is user-friendly."
"The most valuable feature of SAP HANA is the modeling of the databases."
"Using this solution has given us better details for reporting and analytics."
"SAP HANA's best features are its programmability and extensibility - you can size and shape the software however you need."
"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."
"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."
"All features are valuable."
"The most valuable features are the flexibility and the integration with other solutions in data quality."
"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."
"The solution is quick, has good compression data, and is not expensive."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"The performance is very good and the aggregate records are fast."
"Allows us to take volumes and process them at a very high speed."
"Speed and resiliency are probably the best parts of this product."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"Eighty percent of the ETL operations have improved since implementing this solution."
"The solution could improve by having better migration flexibility. For example, it would be helpful if there was a way for customers could check their nonproduction and production deployments."
"The surface side or Attack dashboard needs improvement because there are some gaps after sales services."
"Ease of use could be improved in SAP HANA. I like SAP because SAP solutions can be used by anyone, which means even laymen can start working on SAP tools, but in SAP HANA modeling, you'll need to know some other technologies and sequel scripting, and you need a separate skillset, so if you don't have the skillset, you won't be able to work on SAP HANA. Making SAP HANA low-code would make it even better."
"If the developers were to enhance or improve the application logic while processing the transactions, that would be great."
"What needs improvement in SAP HANA is its automation, in particular, it needs more enhancements in that area."
"The openness of the system could be more developed. The solution should go into the cloud. The cloud mechanism should be more invested."
"When you do a report on a non-SAP platform, you face some compatibility problems."
"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."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"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."
"Suboptimal projection design causes queries to not scale linearly."
"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."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"I believe the installation process could be streamlined."
"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."
SAP HANA is ranked 1st in Embedded Database with 79 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 SAP IQ, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Microsoft Azure Synapse Analytics.
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.