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."Eases management of databases."
"The performance is very, very good. It's one of the best aspects of the solution."
"The product handles high volumes very well and provides good integration."
"The most value for us was in terms of using it to issue tenders online. We host our server, but it is open to the public, so clients who want to buy those tenders were able to go online, put their tender documents up, and we could evaluate them using SAP."
"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."
"We have found that the Fiori Apps are particularly good."
"When we upgraded, we received more functions or more features."
"I like the integration process. Also, the data is trusted by our management, and we use the data from transactions for analysis."
"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."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"I have found the solution to be scalable."
"The solution is quick, has good compression data, and is not expensive."
"Allows us to take volumes and process them at a very high speed."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"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."
"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."
"SAP HANA isn't user-friendly, and it's very hard to train newcomers to use it."
"It's a complex initial setup."
"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."
"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."
"High availability and disaster recovery are very poor in HANA."
"It could be a bit more scalable."
"SAP HANA's long run time to extract data could be improved upon."
"The user interface and CRM need to be more user-friendly."
"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."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"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."
"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."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"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."
"Support is an area where it could get better."
SAP HANA is ranked 1st in Embedded Database with 79 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. SAP HANA is rated 8.4, while Vertica is rated 8.4. 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.