TrustRadius: an HG Insights company

SAP Adaptive Server Enterprise (ASE) vs. Sequel Pro

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    SAP Adaptive Server Enterprise (ASE)

    Score8 out of 10
    N/ASAP 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.N/A

    Sequel Pro

    Score9.5 out of 10
    N/ASequel Pro is a relational database software solution offered free and open source. It allows users to access any MySQL database through a Mac.

    $0

    Pricing
    SAP Adaptive Server Enterprise (ASE)Sequel Pro
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    SAP Adaptive Server Enterprise (ASE)Sequel Pro
    Free Trial
    NoNo
    Free/Freemium Version
    NoYes
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Features
    SAP Adaptive Server Enterprise (ASE)Sequel Pro
    Relational Databases
    Comparison of Relational Databases features of SAP Adaptive Server Enterprise (ASE) and Sequel Pro
    Feature
    SAP Adaptive Server Enterprise (ASE)
    8.3
    1 Ratings
    2% above category average
    Sequel Pro
    -
    Ratings
    ACID compliance9.01 Ratings00 Ratings
    Database monitoring10.01 Ratings00 Ratings
    Database locking8.01 Ratings00 Ratings
    Encryption9.01 Ratings00 Ratings
    Disaster recovery8.01 Ratings00 Ratings
    Flexible deployment6.01 Ratings00 Ratings
    Multiple datatypes8.01 Ratings00 Ratings
    Best Alternatives
    SAP Adaptive Server Enterprise (ASE)Sequel Pro
    Small Businesses
    Amazon RDS
    Score8.1 out of 10
    DBeaver
    Score8.6 out of 10
    Medium-sized Companies
    SingleStore
    Score8.2 out of 10
    DBeaver
    Score8.6 out of 10
    Enterprises
    SAP IQ
    Score5.4 out of 10
    DBeaver
    Score8.6 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    SAP Adaptive Server Enterprise (ASE)Sequel Pro
    Likelihood to Recommend
    8.0
    (3 ratings)
    10.0
    (13 ratings)
    Likelihood to Renew
    10.0
    (1 ratings)
    -
    (0 ratings)
    Usability
    8.0
    (2 ratings)
    8.0
    (1 ratings)
    Support Rating
    9.7
    (2 ratings)
    7.5
    (3 ratings)
    User Testimonials
    SAP Adaptive Server Enterprise (ASE)Sequel Pro
    Likelihood to Recommend
    SAP
    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.
    Incentivized
    Read full review
    Open Source
    It's a great tool when building the software, the ability to add SQL and No-SQL databases. Very convenient to write the queries and generate the filtered data we require. Gives the ability to export, import databases of various formats and generate reports from them. It might not be suitable if you want the data to be seen in a visualized manner
    Incentivized
    Read full review
    Pros
    SAP
    • High availability and reliability.
    • High performance.
    • Monitoring of threshold based events.
    • Security at multiple levels.
    • Query plan optimization.
    • Lock management.
    • Access to HANA.
    Incentivized
    Read full review
    Open Source
    • Table filters are simple and easy to use
    • I love the ability to install plugins: Export tables to Laravel migrations is one of our most used plugins
    • Super easy to connect to local Docker containers, Vagrant and remote DBs through SSH
    Incentivized
    Read full review
    Cons
    SAP
    • A quick button for devs to switch instances into a dev mode (eliminating logs, and such).
    • Licensing is far too complicated. Simplify pricing.
    Incentivized
    Read full review
    Open Source
    • It crashes CONSTANTLY. If you have more than one connection tab open and close one of them, it crashes. If you just have it open in the background, it randomly crashes. If you're using it, it randomly crashes. When you try to send a crash report, the CRASH REPORTER CRASHES.
    • Can be a bit slow.
    • No way that I'm aware of to query multiple databases in the same query.
    Incentivized
    Read full review
    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.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Usability
    SAP
    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.
    Incentivized
    Read full review
    Open Source
    It is easy to use, but the design could use updating as it's very dated.
    Incentivized
    Read full review
    Support Rating
    SAP
    Incredibly responsive, saving us countless hours in troubleshooting.
    Incentivized
    Read full review
    Open Source
    It's open-source and very convenient to work with. I can easily import any database I want using a data dump and runt the queries on them to derive the data insights on the data. I might want to use Excel to visualize that, that might be one of the disadvantages.
    Incentivized
    Read full review
    Alternatives Considered
    SAP
    Incentivized
    Read full review
    Open Source
    MySQL Workbench is a wonderful tool, but the routine editing of existing data is note nearly as straightforward as it is in Sequel Pro. The ability to sort a data view with a single click makes Sequel Pro my definite choice. phpMyAdmin is pretty ubiquitous, but the routine editing of existing data is much more cumbersome than it is in Sequel Pro.
    Incentivized
    Read full review
    Return on Investment
    SAP
    • 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).
    Incentivized
    Read full review
    Open Source
    • The user interface is great. Since all of our computers are macOS based, we can all use it and share knowledge with our colleagues
    • It enables me to make things in such a faster way that it enables us to spend our time with coding and providing more solutions to our clients
    • The workflow is much improved with the import and export feature, so we don't waste time with that kind of work.
    Incentivized
    Read full review
    ScreenShots