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 main feature is that the processes are very flexible, they are able to be adapted to the business and their departments."
"It's sufficed all of our requirements. We primarily needed it to run SAP applications, like NetWeaver or S/4HANA, and it has been really good at that."
"The solution offers advanced features that the company was struggling to implement."
"The in-memory database is excellent."
"SAP HANA's best features are its programmability and extensibility - you can size and shape the software however you need."
"Provides us with predictive capabilities for asset maintenance, and real-time forecasts."
"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."
"Some functions have good performance."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"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."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"The performance is very good and the aggregate records are fast."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"More standards would help in the future."
"While new users to this solution have the benefit of the new design, existing ERP users may experience issues with migrating legacy data. We would like to see development of ready-made tools that allow for easy mapping when upgrading."
"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."
"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."
"A documents preview could be helpful."
"Needs graphical programming without coding."
"The initial setup of SAP HANA is complex. We did the implementation of one site, and a global deployment will take another three to four years."
"I would have rated the solution higher if this version was not missing some key features the newer version has."
"Support is an area where it could get better."
"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."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"When it is about to reach the maximum storage capacity, it becomes slow."
"I believe the installation process could be streamlined."
"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."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
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.