<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
501 Ratings
55 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9 out of 100

SAP HANA

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
501 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100

Likelihood to Recommend

SAP Adaptive Server Enterprise (ASE), legacy

High-performance, high-concurrency transactions are well suited for ASE. ASE is lacking some features in my opinion such as history tables, however there are ways to implement them via workarounds or by using Replication Server. I do think the way the ASE parser and optimizer works are far superior to other products as it is a true cost-based optimizer and the order of the tables in the FROM clause does not really matter although a good SQL coder will place the tables in a meaningful order to make the SQL more readable. ASE is good for applications that require high availability and can be used for mission critical systems.
Gene Baker | TrustRadius Reviewer

SAP HANA

I am rating this tool 9 out of 10 because this tool is really good to use as a database management system because it provides very good features and high security too. IT has lots of amazing functionalities and features which basically improve efficiency and provide more flexibility to work.
Anonymous | TrustRadius Reviewer

Pros

SAP Adaptive Server Enterprise (ASE), legacy

  • Easy to setup and maintain
  • Reliable, rarely has major hiccups requiring reboots or crashes
  • Very responsive with complicated queries spanning various tablespaces and hundreds of millions of rows
Zhann Goloborodko | TrustRadius Reviewer

SAP HANA

  • Data collection is in real time. When the data source of the various sectors is integrated, SAP Hana is able to collect accurate and real-time information, be it from negotiations, advertising, customer service and much more. This data collection in real time allows us to obtain graphs that advance in real time, and thus we can know exactly the movement of each area of ​​the company at all times without having to wait a long time for a report to be generated.
  • The SAP Hana database is very secure, all our data remains safe at all times and we can choose the privacy of the information, so that each person in charge of managing the platform can see specific information. We can import and export data at any time, without fear that any of our essential data will be leaked or stolen.
  • It supports an amount of data greater than 40TB, this helps us too much to be able to collect information and store it, to be able to have a much broader graphical analysis that covers several days or several weeks, and even months.
Edward McCallister | TrustRadius Reviewer

Cons

SAP Adaptive Server Enterprise (ASE), legacy

  • Full database encryption - need to utilize external keys vs internal - for better separation of duties.
  • History Tables.
Gene Baker | TrustRadius Reviewer

SAP HANA

  • Implementing SRS patches incurs significant cost to upgrade the existing system.
  • It runs only in Linux Environment. Does not compatible in other OS.
  • The older version gets outdated more often due to frequent SPS updates and releasing enhanced SAP HANA’s versions.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

SAP Adaptive Server Enterprise (ASE), legacy

SAP Adaptive Server Enterprise (ASE), legacy 10.0
Based on 1 answer
Our licenses are perpetual. It is the support that we will be renewing. We will renew because we continue to use and receive value from the product.
Gene Baker | TrustRadius Reviewer

SAP HANA

SAP HANA 2.8
Based on 5 answers
At this moment we are not focusing on SAP, however would love to in the future. This is primarily because of our limited ability to generate more revenue to fund for SAP partnerships and products. Our initial tryst with SAP Partneredge open ecosystem didn't go as planned and we have shelved that for now. Hope we can revive in the future
Ganapathy Sivakumar | TrustRadius Reviewer

Usability

SAP Adaptive Server Enterprise (ASE), legacy

SAP Adaptive Server Enterprise (ASE), legacy 9.0
Based on 1 answer
It does almost everything we need and for the things it doesn't do natively, we are still able to do using other features. For example, natively history tables weren't supported but we were able to create them using triggers.
Gene Baker | TrustRadius Reviewer

SAP HANA

SAP HANA 7.4
Based on 10 answers
In addition to the points described in the previous parts of the review, I believe that as I gain more experience with the product over time, I will be able to better describe my experience with this tool. Meanwhile, I can confirm that the possibilities presented to my organization by the change to SAP HANA, at the moment, have been very important to evolve the analytical and strategic field towards a new path.
Filippo Orlando | TrustRadius Reviewer

Support Rating

SAP Adaptive Server Enterprise (ASE), legacy

SAP Adaptive Server Enterprise (ASE), legacy 9.7
Based on 4 answers
Incredibly responsive, saving us countless hours in troubleshooting.
Zhann Goloborodko | TrustRadius Reviewer

SAP HANA

SAP HANA 8.2
Based on 276 answers
SAP HANA is a very amazing and famous database management system tool. Our organization uses almost all the features of this tool such as data visualization, data modification, data storage, real-time data collection, etc. Whenever we face any challenges, the SAP HANA support team always helps us to figure them out and resolve the challenges.
Evon Shera | TrustRadius Reviewer

Alternatives Considered

SAP Adaptive Server Enterprise (ASE), legacy

Much less effort than Oracle. Much better customer support than Oracle.Roughly equivalent to SQL Server in performance and ease of use. Much better customer service than SQL Server.Different ballpark from IQ. Same customer service.
Zhann Goloborodko | TrustRadius Reviewer

SAP HANA

I can definitely confirm that SAP HANA cloud solution is by far the best seeing that their machine learning capabilities and sophisticated algorithms are worth the cost. It also leads in in-memory database features hence its great performance.
Anonymous | TrustRadius Reviewer

Scalability

SAP Adaptive Server Enterprise (ASE), legacy

No score
No answers yet
No answers on this topic

SAP HANA

SAP HANA 4.5
Based on 1 answer
Limitation of training deliverable by organization
Shoaib Ansari | TrustRadius Reviewer

Return on Investment

SAP Adaptive Server Enterprise (ASE), legacy

  • Negative - Costs a lot ... but so do they all.
  • Positive - It does what we need it to do.
Zhann Goloborodko | TrustRadius Reviewer

SAP HANA

  • The [strategies] and the time consumed on migrating to HANA was time [consuming] and costly during the initial phases of the project.
  • The time and resources utilized to set up the infra plan from requirements to production was huge.
  • But once we were getting into cadence of utilizing the open architecture of HANA we were able to utilize its features that helped us to leverage.
  • Again I would say that overall for us HANA [has] proved to be worth spending for as it helped us achieve our business's objectives.
Anonymous | TrustRadius Reviewer

Pricing Details

SAP Adaptive Server Enterprise (ASE), legacy

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

SAP HANA

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
Optional

Add comparison