Exasol vs. InterSystems IRIS

Exasol is suited to applications requiring fewer & larger queries (reporting/data analytics/business intelligence tools). Its per-query overhead makes it unsuitable as an operational database (those are optimized for many & smaller queries.)

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

• Performance in ELT/ETL transformations
• Analytical queries for ad-hoc reporting
• Python and java code directly in the database near the data!

• 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.

• SaaS offering in Azure
• Upgradability
• Management interface

• 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

I gave it 9/10 instead of 10/10 only because it lacks in a few advanced enterprise features that require manual workarounds. Otherwise our users have had no problem getting up to speed with it (other than SQL syntax issues that are specific to it, but that's true of any DB)

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.

I have had only positive experiences with their support. They are fast, knowledgeable, and courteous. Online support requests get picked up within hours. I've only once had to use their hotline and that was for an emergency. There was even one minor non-security bug report that I reported and which they fixed in the following week's minor release. I was quite impressed.

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!

Will done based on a proper planning, so this will makes execution more easier and better.

Exasol have the best performance by far in analytical queries (DW/BI). Compared to the other database we use much less time on maintenance, actually almost 0 time on indexes distributing data on nodes etc. The system just works out-of-box as long as you have memory enough

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[.]

• Reduced support needs
• Monetisation
• Huge performance benfits

• 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.