- OLTP features
- Robustness
- Reliability
SAP Adaptive Server Enterprise delivers customizable operations and reliable OLTP features crucial for banking, being resource-efficient and SQL-capable while maintaining high security and performance standards, though updates and cross-platform conversion can be challenging.

| Author info | Rating | Review Summary |
|---|---|---|
| Project and IT Architecture Manager at a security firm with 1,001-5,000 employees | 5.0 | After 20 years, I find ASE robust, reliable, and scalable for high transaction loads, with easy setup and good support. My main concern is the Cluster Edition's reliability compared to the Enterprise version. |
We receive millions of events from our customers and ASE. We are able to process them with thousand of operators working concurrently 24/7.
Usual activity is 1900 user & application connections, 1,500 transactions/sec, and 38,000 queries/sec
Cluster features: The Cluster Edition didn't get the same level of reliability as the Enterprise Edition did.
I have been using it for the last 20 years.
During the last 20 years, I have never had a stability problem with this product. Small specific bugs, but not affecting 24/7 operations.
Old versions had problems with scalability, due to blocking issues with high concurrence. After version 15, this was improved.
I have had no problems with tech support. Most of the issues were related to licensing problems. For bugs, we got quick fixes or workarounds.
We used MS SQL. We switched to ASE due to the scalability of the solution. We still use MS SQL in other small solutions.
Compared to other database engines, I think it's one of the easier ones, in terms of initial setup.
If you have more than one SAP product, it's good to take advantage of the platform licenses because you can move them from one product to another on demand.
Yes, Oracle Database with RAC. We considered it more complex to setup, maintain, and it's more expensive.
Check the new Hana evolution. They are building a new solution that isolates applications to the database layer. It has very interesting features. We are in the process of evaluating it.
| Product | Mindshare (%) |
|---|---|
| SAP Adaptive Server Enterprise | 1.6% |
| Oracle Database | 10.3% |
| SQL Server | 10.2% |
| Other | 77.9% |
| Company Size | Count |
|---|---|
| Small Business | 3 |
| Large Enterprise | 10 |
| Company Size | Count |
|---|---|
| Small Business | 64 |
| Midsize Enterprise | 29 |
| Large Enterprise | 48 |
SAP Adaptive Server Enterprise is tailored for environments needing secure, efficient data handling. Its OLTP capabilities make it a top choice for banking and finance by ensuring smooth transactions. While the database supports multiple data types and cloud integration, it is essential to address the need for user-friendly interfaces and better synchronization features. Although its transaction management isn't as competitive compared to Oracle and PostgreSQL, its SQL capabilities and security tools remain highly regarded. Users primarily utilize it for data storage, scripting, and operational management across development environments, including banking, enabling effective data manipulation and storage.
What are the standout features of SAP Adaptive Server Enterprise?SAP Adaptive Server Enterprise is widely implemented in banking, dealing with efficient data manipulation and storing historical data crucial for operations. It is leveraged for both financial and operational management tasks, including planning and logistics. The database's robust features extend benefits to industries requiring rigorous data management, such as development, testing, and production environments connected across banking networks, focusing on main data handling and replication tasks.
SAP Adaptive Server Enterprise was previously known as SAP ASE.
City of Buenos Aires, ASR Group, Citrix, EarlySense, Usha International Limited, Automotive Resources International (ARI), Takisada-Osaka Co. Ltd., Coelba (Grupo Neoenergia), RZD Russian Railways, National Basketball Association - NBA, TALLY