Skip to main content
TrustRadius
SAP Adaptive Server Enterprise (ASE), legacy

SAP Adaptive Server Enterprise (ASE), legacy
Formerly Sybase

Overview

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

SAP® Adaptive Server® Enterprise (SAP ASE) was a solution that handled massive volumes of data and thousands of concurrent users to accelerate the growth of new data-driven business applications. SAP ASE is a legacy product. It is end of sale…

Read more
Recent Reviews
Read all reviews
Return to navigation

Pricing

View all pricing
N/A
Unavailable

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

SAP® Adaptive Server® Enterprise (SAP ASE) was a solution that handled massive volumes of data and thousands of concurrent users to accelerate the growth of new data-driven business applications. SAP ASE is a legacy product. It is end of sale (EOS), and reached End of Mainstream Maintenance…

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

10 people also want pricing

Alternatives Pricing

N/A
Unavailable
What is Amazon RDS?

Amazon Relational Database Service (Amazon RDS) is a database-as-a-service (DBaaS) from Amazon Web Services.

What is Teradata Vantage?

Teradata Vantage is presented as a modern analytics cloud platform that unifies everything—data lakes, data warehouses, analytics, and new data sources and types. Supports hybrid multi-cloud environments and priced for flexibility, Vantage delivers unlimited intelligence to build the future of…

Return to navigation

Product Details

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

SAP® Adaptive Server® Enterprise (SAP ASE) was a solution that handled massive volumes of data and thousands of concurrent users to accelerate the growth of new data-driven business applications. SAP ASE is a legacy product. It is end of sale (EOS), and reached End of Mainstream Maintenance December 2020.

SAP Adaptive Server Enterprise (ASE), legacy Features

  • Supported: Improved performance of transaction processing
  • Supported: Enhanced security of your OLTP database
  • Supported: Integration with SAP HANA for better compatibility

SAP Adaptive Server Enterprise (ASE), legacy Integrations

SAP Adaptive Server Enterprise (ASE), legacy Competitors

SAP Adaptive Server Enterprise (ASE), legacy Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(66)

Attribute Ratings

Reviews

(1-2 of 2)
Companies can't remove reviews or game the system. Here's why
Gene Baker | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Positive ROI.
  • Ease of use with minimal training required to write high performance SQL (assumes a knowledge of SQL already).
  • Ease of database administration.
  • Sometimes upgrades can be difficult.
  • Changing platforms can be difficult (changing say from SPARC to Intel).
  • Changing operating systems can be difficult (changing from Solaris to linux).
ASE outperforms MS SQL Server, however, MS SQL Server has some nice tools that make MS SQL Server potentially a far better choice for applications that do not need to full power of ASE. HANA of course blows everything away in terms of performance. What I don't understand there is why SAP didn't make HANA use the same dialect of SQL as ASE. This would have made porting an application from ASE to HANA much easier. Oracle Exadata is more of a whole database machine but is very expensive. And you are tied to the Exadata hardware. We tried to port our application from ASE to Exadata and were making significant progress, but there was significant expense are rewrite involved in that endeavor. There really wasn't enough business value to justify the port and the project was ultimately canceled and we remained on ASE. In my opinion, ASE will provide the lowest total cost of ownership over any of the other platforms and that is what we have seen in our experience.
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.
300
Retirement
5
DBAs
DBA Mgr
  • Creating a financial ledger.
  • Creating audit trails of financial changes.
  • Making financial data available via the web/mobile devices.
  • Reconciliation of financial accounts.
  • Using temporal data to give an accurate historical view of the system at any point in time in the past. We call it time travel.
  • Account portability for our customers
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.
No
  • Price
  • Product Features
  • Product Usability
  • Vendor Reputation
Performance was a key concern at the time the product selection was made. We selected this product in 1992. Over the years we have evaluated other replacement products such as Oracle, DB2, HANA, MS-SQL and Informix. Given the cost and complexity to move to another database product, we didn't see the value and have continued to remain on the SAP (Sybase) ASE platform. The platform continues to perform well and is an excellent value for what we paid.
Hindsight of course is 20/20. Back in 1992 when we selected Sybase, the RDBMS market was relatively young. If we could have predicted where the market was going to go, perhaps we would have made a different selection and gone mainstream say with Oracle. But looking back over 27 years, Sybase ASE has always been the performance leader for us. Even though ASE is not an enterprise choice in our organization, we are still able to use it and it has served us well for the past 27 years. I see us continuing to leverage that platform at least until the end of life of our application.
Yes
We pay for a dedicated support engineer. This person is our liaison into the SAP support team but also is someone that can proactively work with our team to help keep us out of trouble when attempting to use new features or products.
Yes
We reported issues that turned out to be bugs. Yes SAP worked diligently to resolve our issue and release a patch fix for us.
When we switched from process mode to threaded mode, they proactively reviewed our system configuration and settings and made recommendations on the best settings to switch modes. This prevented us from having unnecessary slowdowns and kept the system performing optimally.
  • Stored procedures are an easy and efficient way to save queries and query plans.
  • T-SQL dialect of SQL is easy to use.
  • History tables have to be created manually either through use of a trigger or replication.
  • Cross platform migration.
  • Cross OS migration.
Yes
SAP has what they call SUP (SAP Unwired Platform) which we do not use. The SUP supports SOAP Web Services and we have standardized around REST so we do not use this.
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.
Zhann Goloborodko | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Negative - Costs a lot ... but so do they all.
  • Positive - It does what we need it to do.
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.
Incredibly responsive, saving us countless hours in troubleshooting.
Return to navigation