We performed a comparison between SAP Adaptive Server Enterprise and SAP HANA based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."SAP Adaptive Server Enterprise is a good transactional database."
"I like that SAP ASE can match code and the database index to index data in the programming language. There are many other valuable features, such as the table buffer, tuning, and various control agents like dispatcher. SAP ASE can handle many different data types, including views, domains, data elements, structures, objects, and various table types that are most useful in the application. Its modularization technique is also handy."
"Provides very good integration."
"It's user-friendly, especially in the logistics field."
"They provide easy integration with other systems."
"The most valuable part of the tool stems from the fact that it is a very cost-efficient product compared to the newer technologies because it needs a very small amount of RAM."
"It's pretty good at handling a large number of transactions, which is critical for a banking client."
"This is a wonderful database that is, in my opinion, underrated. Users are able to get the most out of my experience by taking advantage of its centralized environment."
"The solution is easy to manage enterprise resources and the reporting and analytics are including. It is good for company growth and all module are managed well."
"SAP HANA is one of the best databases known for its performance...The new version of the solution is stable."
"The solution is marvelous because it controls everything including workflow and that makes our company more productive."
"The performance is very, very good. It's one of the best aspects of the solution."
"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."
"It has a very huge bandwidth and data transfer."
"The best feature of SAP HANA is column computing. The computing speed of the solution is also very high, so developers can easily develop programs through SAP HANA."
"The in-memory computing and the efficient response time are very good features."
"Because the solution is customized. we do occasionally face unique bugs. There are always some changes that need to be made here and there."
"SAP should refine its debugging method, and the process needs to be a little faster. It should use more Pragmas and fewer pseudocomments. I would like if SAP added more features based on advanced technologies, like artificial intelligence and voice control. The modularization and if-else techniques could also incorporate the latest technology to code and solve complex problems. The SAP Editor should be more elaborative, and it should allow many more types of statements for all uses."
"The solution should improve view partitioning. The documentation is very confined and available only for users. Distributors also would like access to it."
"Cost-wise, SAP is still expensive compared to other available products."
"In my opinion, product support is not that great from SAP because they have already declared the end-of-date for SAP ASE. They will be stopping product support."
"User interface could be more user friendly."
"There could be some improvements in barcode scanning and RFID access."
"The overall performance of the product is an area where the tool has certain shortcomings and needs to improve."
"Technical support could be better."
"HANA could be improved by adding analytics and development models in the institution."
"You cannot apply mulit-join inside the calculation views, for example, when you are joining tables."
"I would like to see improvement on the feedback from the road-map; it is currently extremely hard to get insight in this area."
"The high price of the product is an area of concern where improvements are required."
"I would like to see improvements in the connectivity of the solution with other BI software. Not every software can connect to it natively."
"The inclusion of a well-performing Time Machine is vital."
"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."
More SAP Adaptive Server Enterprise Pricing and Cost Advice →
SAP Adaptive Server Enterprise is ranked 17th in Relational Databases Tools with 12 reviews while SAP HANA is ranked 3rd in Relational Databases Tools with 81 reviews. SAP Adaptive Server Enterprise is rated 8.4, while SAP HANA is rated 8.4. The top reviewer of SAP Adaptive Server Enterprise writes " Offers cost-efficiency as it needs a very small amount of RAM to function". On the other hand, the top reviewer of SAP HANA writes "Excellent compatibility between modules and the control". SAP Adaptive Server Enterprise is most compared with SQL Server, SAP SQL Anywhere, Oracle Database, IBM Db2 Database and SAP IQ, whereas SAP HANA is most compared with Oracle Database, SQL Server, MySQL, IBM Db2 Database and Oracle Database In-Memory. See our SAP Adaptive Server Enterprise vs. SAP HANA report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.