Item: SAP Adaptive Server Enterprise (ASE)
Rating: 8
Author: Verified User

Overall Satisfaction with SAP Adaptive Server Enterprise (ASE)

Use Cases and Deployment Scope

We use SAP ASE to run in-house built-in applications related to cybersecurity. We use it to monitor the DBMS-related vulnerabilities. We store, process, and manage a large amount of product-related data and query statements, alert management, and security threat mechanisms. This helps us to efficiently handle a large number of SQL statements and generate alerts in case of any security vulnerability by generating alerts to the DBA and other users for the DB.

Pros and Cons

Pros

Handle large amount of data.
Highly secure database.
High throughput, i.e., transactions per second, is on the higher side compared to other similar DBMS.
Minimal cost of handling compared to other vendors.
Less DBA intervention is needed.

Cons

More frequent patch and feature updates are required.
Very less DBA resources available.
A lot of dependencies in setting up setup for the SAP ASE DBMS.
Supported OS platforms can be increased.

Return on Investment

Licensing cost is significantly less compared to peer vendors.
Better performance in a scaled and cybersecurity-specific environment.
Significantly fewer CVEs for the database.
Need to spend a significant amount of time in training and development.

Usability

Well-suited in the security domain, high performance, and low latency of the DBMS. In terms of the DBA perspective, a dedicated monitoring tool (Cockpit) helps a lot in terms of managing the database, which helps in identifying bottlenecks during performance issues. Also, it helps us to send custom alerts related to Database activities.

Alternatives Considered

Oracle Database, SAP HANA Cloud and PostgreSQL

Key Insights

Do you think SAP Adaptive Server Enterprise (ASE) delivers good value for the price?

Yes

Are you happy with SAP Adaptive Server Enterprise (ASE)'s feature set?

Yes

Did SAP Adaptive Server Enterprise (ASE) live up to sales and marketing promises?

Yes

Did implementation of SAP Adaptive Server Enterprise (ASE) go as expected?

Yes

Would you buy SAP Adaptive Server Enterprise (ASE) again?

Yes

Other Software Used

Jenkins, IntelliJ IDEA, Apache JMeter, Atlassian Jira, Atlassian Confluence, Eclipse, Google Gemini, ChatGPT, GitHub, Microsoft Visual Studio Code

Likelihood to Recommend

We use this for an inbuilt security management system, where it performs well in a scaled setup with a large volume of live data with high availability. Also, the performance is up to the mark for the large statement flow. From a DBA perspective, a lot of parameters need to be fine-tuned for the specific environment needs, which can cause overhead. Expertise is limited, and the learning curve is steep for the SAP ASE.

SAP Adaptive Server Enterprise (ASE) Feature Ratings

Comments

Please log in to join the conversation

SAP ASE in Cyber Security Domain.