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."The solution is very fast."
"The on-premise version is stable. We have different teams and resources for the server side, for admin, and for development. We can easily take care of all the services and applications."
"We can integrate it with any data sources as well."
"Security is the most valuable feature."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"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."
"The scalability of the solution is very good. It's able to support large amounts of data."
"The scalability is very good."
"SAP HANA is one of the best databases known for its performance...The new version of the solution is stable."
"A very feature-rich solution with excellent performance."
"The most valuable feature of SAP HANA is its performance and integration."
"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 is marvelous because it controls everything including workflow and that makes our company more productive."
"SAP HANA is a stable solution."
"It's user-friendly so long as you use it frequently."
"The UX experience is very good."
"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."
"The pricing could be improved. It would ideal if it was more reasonable."
"The product could be more economical."
"The query optimization and backup features should be added."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"The high cost of the product is an area of concern where improvements are required."
"The solution should move to the new way of writing software code with AI that is intelligent and learns."
"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."
"High availability and disaster recovery are very poor in HANA."
"The installation process could be more straightforward."
"A documents preview could be helpful."
"In terms of improvement, the speed is not as good as we thought it would be. That is why we are trying different solutions that will be built with different technologies."
"Ease of use could be improved in SAP HANA. I like SAP because SAP solutions can be used by anyone, which means even laymen can start working on SAP tools, but in SAP HANA modeling, you'll need to know some other technologies and sequel scripting, and you need a separate skillset, so if you don't have the skillset, you won't be able to work on SAP HANA. Making SAP HANA low-code would make it even better."
"When we are using SAP HANA we have some difficulty with the customization. We would like to be able to add and make customized menus."
"The product is very demanding on memory requirements."
"The pricing could be better."
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, MariaDB and Apache Derby, 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.