"The memory is the solution's most valuable feature. It's the main feature of HANA. Others are still the regular IT databases that are on storage and are therefore much slower than HANA. The solution is quite fast."
"The in-memory computing and the efficient response time are very good features."
"The performance in terms of processing time is unmatched due to the in-memory processing capability."
"SAP HANA is vertically and horizontally scalable."
"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."
"We've had good experiences with technical support."
"It's easy to use, and the Hana Studio is pretty good."
"The performance is very, very good. It's one of the best aspects of the solution."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"It has improved my organization's functionality and performance."
"I have found the solution to be scalable."
"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 performance is very good and the aggregate records are fast."
"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."
"I would have rated the solution higher if this version was not missing some key features the newer version has."
"There's an issue in the partition. When you record more than two million records, partitioning does not work well. In Oracle it's easy. SAP must resolve this issue in order to be more competitive with Oracle."
"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 user interface and CRM need to be more user-friendly."
"There could be better management for faster updates, last year there were some changes in India to the e-invoicing feature."
"SAP HANA is not strong like Oracle when it comes to finance. They are only strong with the logistic business project."
"Uses a large amount of RAM and is costly."
"Technical support could be better."
"I have found that coding support could be simplified."
"They could improve the integration and some of the features in the cloud version."
"When it is about to reach the maximum storage capacity, it becomes slow."
"They could improve on customer service."
"Support is an area where it could get better."
"The geospatial functionality could be designed better."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"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."
The SAP HANA® platform helps you reimagine business by combining a robust database with services for creating innovative applications. It enables real-time business by converging trans-actions and analytics on one in-memory platform. Running on premise or in the cloud, SAP HANA untangles IT complexity, bringing huge savings in data management and empowering decision makers everywhere with new insight and predictive power.
Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.
To learn more about Micro Focus Vertica Advanced Analytics, visit our website.
SAP HANA is ranked 1st in Embedded Database Software with 25 reviews while Vertica is ranked 3rd in Data Warehouse with 11 reviews. SAP HANA is rated 8.0, while Vertica is rated 9.2. The top reviewer of SAP HANA writes "Very robust solution with good data access". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". SAP HANA is most compared with SQL Server, Oracle Database, MySQL, Apache Spark and Exasol, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, SQL Server and Cloudera Distribution for Hadoop.
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.