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."It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."
"The application development is very user-friendly."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"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."
"The most valuable feature is that Database-In-Memory is more consistent and faster than traditional databases as it requires fewer CPUs to process instructions."
"I like Oracle because it is a backward-compatible solution."
"The scalability is very good."
"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."
"SAP HANA is a stable solution."
"We are using the solution for the DW system. The primary function of the solution is for the database in memory."
"The most valuable features are the flexibility and the integration with other solutions in data quality."
"Technically it resembles Oracle, but as a somewhat lighter version."
"SAP HANA's most valuable features are monitoring, reporting, and price and stock control."
"What I like most are the dashboards and pervasive analytics."
"One feature I find very valuable, is the response time of the application on the database memory."
"Using this solution has given us better details for reporting and analytics."
"They should improve the solution's scalability for large databases."
"The platform’s pricing needs improvement."
"The high cost of the product is an area of concern where improvements are required."
"Lacks sufficient integration with other tools."
"The solution should move to the new way of writing software code with AI that is intelligent and learns."
"I would like Oracle Database In-Memory to include a data replication feature."
"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 product could be more economical."
"I don't have direct access to SAP, and instead, I need to go through the SAP office in India."
"This is an expensive solution."
"The product is very demanding on memory requirements."
"The SAP ERP processes are quite complex and it can be challenging."
"I give the scalability of SAP HANA a six out of ten."
"The solution needs to work on its performance and make it faster."
"The bid process needs to be improved."
"The solution could improve by having better migration flexibility. For example, it would be helpful if there was a way for customers could check their nonproduction and production deployments."
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.