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."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."
"If you want to scale with new processes and new reports, that's fairly easy."
"The UX experience is very good."
"Using this solution has given us better details for reporting and analytics."
"The in-memory computing and the efficient response time are very good features."
"Eases management of databases."
"It's user-friendly so long as you use it frequently."
"As I only worked part-time on SAP HANA, I did not have the opportunity to explore the advanced features of the solution. However, I did work with basic features, such as user administration and access controls for the accounting department. The feature that stood out to me the most was the Single Sign-On and user administration, backup, and server management. My experience with SAP HANA was mainly focused on basic server improvements."
"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."
"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 ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The paramount advantage is the exceptional speed."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The solution needs to work on its performance and make it faster."
"In a future release, SAP HANA should add a module for taxation, such as income tax and withholding tax."
"The JDBC connectors are very slow."
"The relationship with a partner that sells SAP could be better. We depend much more on our own development, and the partner is for selling us the solutions, so we need them to be able to supply help and answers. The partner isn't very helpful, and we have to rely on our own knowledge and research."
"High availability and disaster recovery are very poor in HANA."
"I'd just like to see some more improvements done on the training, both on the functional training and technical training sides as a part of the complete solution."
"The openness of the system could be more developed. The solution should go into the cloud. The cloud mechanism should be more invested."
"The initial setup was very, very complex, tedious, and costly and required someone with great expertise to complete it."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"We don't get good discounts in Pakistan."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"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."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
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.