59 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.7 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

Attribute Ratings

  • SAP Adaptive Server Enterprise (ASE), legacy is rated higher in 1 area: Likelihood to Recommend

Likelihood to Recommend

10.0

SAP Adaptive Server Enterprise (ASE), legacy

100%
2 Ratings
7.0

Valentina

70%
1 Rating

Likelihood to Renew

10.0

SAP Adaptive Server Enterprise (ASE), legacy

100%
1 Rating

Valentina

N/A
0 Ratings

Usability

9.0

SAP Adaptive Server Enterprise (ASE), legacy

90%
1 Rating

Valentina

N/A
0 Ratings

Support Rating

9.7

SAP Adaptive Server Enterprise (ASE), legacy

97%
4 Ratings

Valentina

N/A
0 Ratings

Likelihood to Recommend

SAP

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.
Read full review

Paradigma Software

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.
Read full review

Pros

SAP

  • 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
Read full review

Paradigma Software

  • 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.
Read full review

Cons

SAP

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

Paradigma Software

  • 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.
Read full review

Pricing Details

SAP Adaptive Server Enterprise (ASE), legacy

Starting Price

Editions & Modules

SAP Adaptive Server Enterprise (ASE), legacy editions and modules pricing
EditionModules

Footnotes

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    Valentina

    Starting Price

    $0

    Editions & Modules

    Valentina editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Likelihood to Renew

      SAP

      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.
      Read full review

      Paradigma Software

      No answers on this topic

      Usability

      SAP

      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.
      Read full review

      Paradigma Software

      No answers on this topic

      Support Rating

      SAP

      Incredibly responsive, saving us countless hours in troubleshooting.
      Read full review

      Paradigma Software

      No answers on this topic

      Alternatives Considered

      SAP

      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.
      Read full review

      Paradigma Software

      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.
      Read full review

      Return on Investment

      SAP

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

      Paradigma Software

      • 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.
      Read full review

      Add comparison