We performed a comparison between SAP HANA and SingleStore 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."
"I like the integration process. Also, the data is trusted by our management, and we use the data from transactions for analysis."
"The solution operates well."
"Some functions have good performance."
"It is very flexible to integrate with SaaS components."
"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."
"SAP HANA's best features are its programmability and extensibility - you can size and shape the software however you need."
"What I like best about SAP HANA is that it's faster than Microsoft SQL Server."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The paramount advantage is the exceptional speed."
"Uses a large amount of RAM and is costly."
"I give the scalability of SAP HANA a six out of ten."
"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."
"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."
"The installation process could be more straightforward."
"The performance and integration with other products are areas in need of improvement."
"There could be better management for faster updates, last year there were some changes in India to the e-invoicing feature."
"SAP HANA isn't user-friendly, and it's very hard to train newcomers to use it."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
"We don't get good discounts in Pakistan."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
SAP HANA is ranked 1st in Embedded Database with 79 reviews while SingleStore is ranked 6th in Database as a Service with 7 reviews. SAP HANA is rated 8.4, while SingleStore is rated 8.8. The top reviewer of SAP HANA writes "Excellent compatibility between modules and the control". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". SAP HANA is most compared with Oracle Database, SQL Server, MySQL, IBM Db2 Database and Apache Spark, whereas SingleStore is most compared with SQL Server, MySQL, Teradata, Oracle Database and CockroachDB.
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.