TrustRadius: an HG Insights company

InterSystems IRIS vs. SAP Adaptive Server Enterprise (ASE)

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    InterSystems IRIS

    Score7.7 out of 10
    N/AInterSystems IRIS is a complete cloud-first data platform that includes a multi-model transactional data management engine, an application development platform, and interoperability engine, and an open analytics platform. It is is the next generation of InterSystems' data management software. It includes…N/A

    SAP Adaptive Server Enterprise (ASE)

    Score6.9 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
    Pricing
    InterSystems IRISSAP Adaptive Server Enterprise (ASE)
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    InterSystems IRISSAP Adaptive Server Enterprise (ASE)
    Free Trial
    YesNo
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    InterSystems IRISSAP Adaptive Server Enterprise (ASE)
    Considered Both Products
    InterSystems
    No answer on this topic
    SAP
    No answer on this topic
    Key User Insights
    Would buy again
    100%
    Would buy again
    44 Answers
    No answers on this topic
    Delivers good value for the price
    100%
    Delivers good value for the price
    39 Answers
    No answers on this topic
    Happy with the feature set
    98%
    Happy with the feature set
    43 Answers
    No answers on this topic
    Lived up to sales and marketing promises
    100%
    Lived up to sales and marketing promises
    32 Answers
    No answers on this topic
    Implementation went as expected
    100%
    Implementation went as expected
    40 Answers
    No answers on this topic
    Best Alternatives
    InterSystems IRISSAP Adaptive Server Enterprise (ASE)
    Small Businesses
    SingleStore
    Score7.5 out of 10
    SingleStore
    Score7.5 out of 10
    Medium-sized Companies
    SAP HANA Cloud
    Score8.9 out of 10
    SAP HANA Cloud
    Score8.9 out of 10
    Enterprises
    SAP IQ
    Score10 out of 10
    SAP IQ
    Score10 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    InterSystems IRISSAP Adaptive Server Enterprise (ASE)
    Likelihood to Recommend
    7.4
    (44 ratings)
    10.0
    (2 ratings)
    Likelihood to Renew
    8.2
    (1 ratings)
    10.0
    (1 ratings)
    Usability
    8.2
    (3 ratings)
    9.0
    (1 ratings)
    Support Rating
    7.4
    (4 ratings)
    9.7
    (2 ratings)
    Implementation Rating
    8.2
    (1 ratings)
    -
    (0 ratings)
    User Testimonials
    InterSystems IRISSAP Adaptive Server Enterprise (ASE)
    Likelihood to Recommend
    InterSystems
    Intersystems IRIS is a really great tool for Interoperability. It has so many capabilities out of the box and then such a great developer community on top of that, that there are really no limits to what you can do in terms of data manipulation and translation. Personally I find it to be a great tool if you are looking for Interoperability software.
    Incentivized
    Read full review
    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.
    Incentivized
    Read full review
    Pros
    InterSystems
    • Connecting with mutliple vendor platforms and systems allowing us to consume and provide data as needed.
    • Allowed us to implement our own RESTful api engine to server data to our internal applications.
    • Setting up their recommendations for high availability allow us to perform server maintenance with minimal down time to our users.
    Read full review
    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
    Incentivized
    Read full review
    Cons
    InterSystems
    • Enhanced documentation, more comprehensive and user-friendly documentation, including detailed tutorials and examples
    • Improving compatibility and integrations with others programming languages
    • Introducing tools and techniques to optimize the performance of ObjectScript applications, such as profiling tools, performance monitoring utilities, and code optimization guidelines
    • A better compatibility with Python libraries
    Read full review
    SAP
    • Full database encryption - need to utilize external keys vs internal - for better separation of duties.
    • History Tables.
    Incentivized
    Read full review
    Likelihood to Renew
    InterSystems
    No answers on this topic
    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
    Usability
    InterSystems
    The interface is very intuitive, the documentation is very good so it is not complicated to operate.
    The security is complex, but you can create a special role to access and the user ONLY can operate with the part that it allows.
    Also, you can examine the data very quick with the SQL Browser integrated.
    Read full review
    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.
    Incentivized
    Read full review
    Support Rating
    InterSystems
    The InterSystems WRC has always been helpful and responsive. The folks I have spoken with are always understanding of our needs and questions and regardless of if the question is simple or complex we are always met with the same professionalism and helpfulness every time. I have no hesitations contacting InterSystems for help!
    Read full review
    SAP
    Incredibly responsive, saving us countless hours in troubleshooting.
    Incentivized
    Read full review
    Implementation Rating
    InterSystems
    Will done based on a proper planning, so this will makes execution more easier and better.
    Read full review
    SAP
    No answers on this topic
    Alternatives Considered
    InterSystems
    We are using InterSystems IRIS [especially] for database operations as the query performance is really good for [a large] amount of customer data. You can easily integrate for any application like web, desktop, and many more. It also provides BI functionality which is also very easy to implement using InterSystems IRIS[.]
    Read full review
    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.
    Incentivized
    Read full review
    Return on Investment
    InterSystems
    • Very Fast and scalable software to deal with big data flow, safe and robust.
    • The studio IDE is quite old fashion and lacks a few facilities
    • amazing for complex data consumption, its milyi-model capability wich allows multiple different models for a single set of codes.
    Read full review
    SAP
    • Negative - Costs a lot ... but so do they all.
    • Positive - It does what we need it to do.
    Incentivized
    Read full review
    ScreenShots