SAP ASE Reviews

49 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.9 out of 100

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (1-2 of 2)

Gene Baker | TrustRadius Reviewer
December 08, 2019

SAP ASE offers great performance and value

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.
Read Gene Baker's full review
Zhann Goloborodko | TrustRadius Reviewer
November 20, 2019

SAP ASE is a surprisingly durable and easy to use enterprise DB

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.
Read Zhann Goloborodko's full review

About SAP ASE

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 Features

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

SAP ASE Integrations

SAP ASE Competitors

Microsoft SQL Server, Oracle MySQL, IBM DB2

SAP ASE Technical Details

Operating Systems: Unspecified
Mobile Application:No