SAP Adaptive Server Enterprise (ASE), legacy Reviews

51 Ratings
<a href='' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.4 out of 100

Do you work for this company? Learn how we help vendors

Overall Rating

Reviewer's Company Size

Last Updated

By Topic




Job Type


Reviews (1-2 of 2)

Companies can't remove reviews or game the system. Here's why.
December 08, 2019
Gene Baker | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use ASE as the foundation for our 401(k) record keeping system. We store approximately 35,000 data elements spread across 24 databases and 2,000 tables. We have approximately 40 TB of data stored in our database. SAP ASE allows us to serve our many clients and business partners concurrently given its high performance and high availability features. Our application is an enterprise application used to service a number of clients both internal and external. SAP ASE is not an enterprise solution within our organization but is used by our department and several others departments for various financial applications. Our application started in 1992 and was originally sold as a licensed product and through merger and acquisition became owned by the bank.
  • High availability and reliability.
  • High performance.
  • Monitoring of threshold based events.
  • Security at multiple levels.
  • Query plan optimization.
  • Lock management.
  • Access to HANA.
  • Full database encryption - need to utilize external keys vs internal - for better separation of duties.
  • History Tables.
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.
We have what has been historically called Alliance support. Our support engineer and team are always quick to react to issues that may come up but they are also proactive to help us avoid situations based on prior experience and customer feedback.
Read Gene Baker's full review
November 20, 2019
Zhann Goloborodko | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use ASE as our primary DB. It handles data across virtually all departments. We have hundreds of billions of rows of data spanning many decades. Given the amount of work it does within our organization, it is incredibly reliable rivaled by SQL Server in stability and performance. Given that our organization doesn't employ DBAs and that all our DBs are developers, Sybase has made our lives relatively easy considering what we ask of it.
  • 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
  • A quick button for devs to switch instances into a dev mode (eliminating logs, and such).
  • Licensing is far too complicated. Simplify pricing.
Great a business that needs a Database and doesn't want to invest in DBAs.
Incredibly responsive, saving us countless hours in troubleshooting.
Read Zhann Goloborodko's full review

What is SAP Adaptive Server Enterprise (ASE), legacy?

SAP® Adaptive Server® Enterprise (SAP ASE) promises to allow you to handle massive volumes of data and thousands of concurrent users to accelerate the growth of new data-driven business applications. The value proposition is to drive value with a faster, more efficient transactional system that is designed to meet the demands of the digital economy.

SAP ASE is a legacy product. It is end of sale (EOS), and will reach End of Mainstream Maintenance December 2020.
Categories:  Relational Databases

SAP Adaptive Server Enterprise (ASE), legacy Features

Has featureImproved performance of transaction processing
Has featureEnhanced security of your OLTP database
Has featureIntegration with SAP HANA for better compatibility

SAP Adaptive Server Enterprise (ASE), legacy Integrations

SAP Adaptive Server Enterprise (ASE), legacy Competitors

Microsoft SQL Server, Oracle MySQL, IBM DB2

SAP Adaptive Server Enterprise (ASE), legacy Technical Details

Operating Systems: Unspecified
Mobile Application:No