We performed a comparison between Oracle Database In-Memory and SAP HANA based on real PeerSpot user reviews.
Find out in this report how the two Embedded Database solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Normally, every database server uses hard disks. In-Memory has a feature, apart from their database, which is very good. When we start our server, all your data needs loading memory. We can use that. It's a very good feature. I think they added this feature in 2019. We can mount memory in the partition, create partitions in there, and create table space from that spot to share. It's a really good feature. We use it a lot."
"Security is the most valuable feature."
"We use the tool for real-time data transfer for risk management purposes. In a trading system, conversions happen fast. We use the product to handle fast transactions with low latency."
"The solution is very fast."
"The solution's ROI is excellent."
"I like Oracle because it is a backward-compatible solution."
"The scalability of the solution is very good. It's able to support large amounts of data."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"We are using the solution for the DW system. The primary function of the solution is for the database in memory."
"If you want to scale with new processes and new reports, that's fairly easy."
"The most valuable feature of SAP HANA is the modeling of the databases."
"SAP HANA is one of the best databases known for its performance...The new version of the solution is stable."
"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."
"SAP HANA is a stable solution."
"The feature I found most valuable in SAP HANA is modeling. I also like that the solution has good integration and you can integrate it with any system, even third-party systems."
"It is difficult for me to narrow down what the best features are in SAP HANA because they work together to provide the overall functionality of the solution. However, the Fiori application is very good."
"The product could be more economical."
"It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory."
"They should improve the solution's scalability for large databases."
"Oracle Database In-Memory appliance-based solutions can be restrictive for some applications, as they may require more flexibility in the database design to be tuned and sized to the customer's needs."
"Technical support is below our expectations currently. It could be improved."
"We use some partitions in In-Memory. We have a very large table and a low dose. It is very expensive in data to load all of them into In-Memory. It takes up more memory slots in the server, as well as a lot of RAM. We use last partitions on the table. We always need to create a script and make a schedule that can load a last partition in In-Memory. Oracle doesn't have features to do this automatically. I would like them to allow us to load last partitions, as well as other table partitions, in In-Memory. I think a good feature would do that automatically, letting you see a table, load a large partition, and monitor loading memory. It's quite a good feature."
"The solution should move to the new way of writing software code with AI that is intelligent and learns."
"The platform’s pricing needs improvement."
"The solution is very expensive, however. The pricing depends on the number of users and many other factors that affect licensing."
"Technical support could be better."
"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 pricing is expensive."
"What needs improvement in SAP HANA is its automation, in particular, it needs more enhancements in that area."
"They should develop and improve the solution's data management system."
"The bid process needs to be improved."
"SAP HANA is not strong like Oracle when it comes to finance. They are only strong with the logistic business project."
Oracle Database In-Memory is ranked 2nd in Embedded Database with 27 reviews while SAP HANA is ranked 1st in Embedded Database with 81 reviews. Oracle Database In-Memory is rated 8.8, while SAP HANA is rated 8.4. The top reviewer of Oracle Database In-Memory writes "User friendly with great scalability but needs to move toward intelligent AI". On the other hand, the top reviewer of SAP HANA writes "Excellent compatibility between modules and the control". Oracle Database In-Memory is most compared with IBM Db2 Database, Progress OpenEdge RDBMS, SQL Server, Apache Derby and MariaDB, whereas SAP HANA is most compared with Oracle Database, SQL Server, MySQL, IBM Db2 Database and Teradata. See our Oracle Database In-Memory vs. SAP HANA report.
See our list of best Embedded Database vendors and best Relational Databases Tools vendors.
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.