TrustRadius: an HG Insights company

SAP Adaptive Server Enterprise (ASE)

Score6.9 out of 10

65 Reviews and Ratings

Get a Demo

What is SAP Adaptive Server Enterprise (ASE)?

SAP Adaptive Server Enterprise (ASE) is a transactional relational database, boasting fast, reliable online transaction processing (OLTP). SAP ASE is the company's transactional database within the SAP Business Technology Platform portfolio.

Categories & Use Cases

Reviews

What users are saying about SAP Adaptive Server Enterprise (ASE).
View all reviews

SAP ASE offers great performance and value

Incentivized
Gene BakerView profile
Vice President, Chief Architect, Development Manager and Software Engineer in Information Technology at WySTAR Global Retirement Solutions, a Wells Fargo Company (10,001+ employees employees)

Pros

  • High availability and reliability.
  • High performance.
  • Monitoring of threshold based events.
  • Security at multiple levels.
  • Query plan optimization.
  • Lock management.
  • Access to HANA.

Cons

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

Return on Investment

  • 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).

Alternatives Considered

Oracle Exadata Database Machine, Microsoft SQL Server and SAP HANA

Other Software Used

SAP Replication Server, Microsoft SQL Server, Oracle Exadata Database Machine, MongoDB, SAP HANA

Usability

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

Incentivized
Zhann GoloborodkoView profile
Senior Programmer/Analyst in Information Technology at Investment Company Institute (51-200 employees employees)

Pros

  • 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

Cons

  • A quick button for devs to switch instances into a dev mode (eliminating logs, and such).
  • Licensing is far too complicated. Simplify pricing.

Return on Investment

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

Alternatives Considered

Oracle Database, Microsoft SQL Server and SAP IQ (formerly SAP Sybase IQ)

Other Software Used

Oracle Database, Microsoft SQL Server, SAP IQ (formerly SAP Sybase IQ)

Related Products

Products similar to SAP Adaptive Server Enterprise (ASE) that may also meet your needs.
All comparisons
Microsoft SQL Server
CompareLearn more