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

Likelihood to Recommend

SAP Adaptive Server Enterprise (ASE), legacy

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.
Gene Baker | TrustRadius Reviewer

Valentina

If you have to manage a lot of different databases from different vendors, you could do well by standardizing on this product. It checks all the boxes for a proper database management studio. You would only have to learn one product to manage them all.However, if you are looking to find a good product for a single database vendor, you might be better off finding a tool that was designed specifically for that vendor product.
Aaron Smith | TrustRadius Reviewer

Pros

SAP Adaptive Server Enterprise (ASE), legacy

  • 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
Zhann Goloborodko | TrustRadius Reviewer

Valentina

  • Foreign Key Constraint data viewer! This was a tremendously helpful feature that not many other products have. Just pick a constraint and see the data in the child tables! No setup required!
  • Supports any and every database imaginable.
Aaron Smith | TrustRadius Reviewer

Cons

SAP Adaptive Server Enterprise (ASE), legacy

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

Valentina

  • Somewhat laggy performance. Boot up speed was on the slow side and connecting to our database servers was also a little slower than other products.
  • User interface can be a little clunky. Instead of the usual tree view of servers, databases, and schemas, you are presented with lists that you click on and get new windows to pick the new list of data from. Not organized efficiently.
Aaron Smith | TrustRadius Reviewer

Likelihood to Renew

SAP Adaptive Server Enterprise (ASE), legacy

SAP Adaptive Server Enterprise (ASE), legacy 10.0
Based on 1 answer
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.
Gene Baker | TrustRadius Reviewer

Valentina

No score
No answers yet
No answers on this topic

Usability

SAP Adaptive Server Enterprise (ASE), legacy

SAP Adaptive Server Enterprise (ASE), legacy 9.0
Based on 1 answer
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.
Gene Baker | TrustRadius Reviewer

Valentina

No score
No answers yet
No answers on this topic

Support Rating

SAP Adaptive Server Enterprise (ASE), legacy

SAP Adaptive Server Enterprise (ASE), legacy 9.7
Based on 4 answers
Incredibly responsive, saving us countless hours in troubleshooting.
Zhann Goloborodko | TrustRadius Reviewer

Valentina

No score
No answers yet
No answers on this topic

Alternatives Considered

SAP Adaptive Server Enterprise (ASE), legacy

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.
Zhann Goloborodko | TrustRadius Reviewer

Valentina

Compared to Microsoft's SQL Management Studio, Valentina studio was comparable, just harder to get used to in the UI department. It ran slightly slower than other products but did save some time with neat features they baked into the product.However, in using DBeaver Community and DBForge Studio for PostgreSQL from Devart, we found different products that the team ultimately decided to use. DBeaver has all of the features we needed most (minus the constraint data viewer) and a more intuitive UI that we were used to. DBForge Studio for PostgreSQL has a very standard Windows look and feel and lacks some features, like database/table designers, but makes up for those shortcomings in the much easier filtering and sorting options right in the data grids. You can even write a query and edit the data returned, which is something we don't see in many of these tools.Our team ultimately settled on the developers using DBeaver and the support team that needs data viewing/editing capabilities using DBForge Studio.
Aaron Smith | TrustRadius Reviewer

Return on Investment

SAP Adaptive Server Enterprise (ASE), legacy

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

Valentina

  • It saved time in some areas of finding child data by not having to write queries to find it.
  • The user interface caused some extra training for some users and ultimately caused them to not like using it.
Aaron Smith | TrustRadius Reviewer

Pricing Details

SAP Adaptive Server Enterprise (ASE), legacy

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Valentina

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?

Add comparison