Exasol vs. SAP SQL Anywhere

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

SAP SQL Anywhere is better than not using a database, let's be clear there! However, I wouldn't pick it as my first or even second or third choice. I'd recommend looking at other options. Largely, it appears less powerful both in terms of its robustness and general performance and in its implementation of SQL. The standard Sybase utilities provided are lacking in basic features, and the interactive SQL utility is quite horrendous. However, the great thing is it is an ODBC-compliant SQL-compliant relational database.

Incentivized

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

• Good performance with relatively large data sets - its cost-based query optimizer is particularly robust
• ANSI SQL compliant
• Supports T-SQL
• Scales well between the desktop (single user) and client/server installations supporting 50-1000 users

• SaaS offering in Azure
• Upgradability
• Management interface

• I think it should be more user friendly for non-technical users.
• More functional functionalities should be added to the object explore when working with a table to transform data/manipulate data.

Incentivized

Ease of use, relationship to existing software's used in house and familiarity with the product

Incentivized

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)

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.

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

I worked with Oracle for years during my career. I wouldn't select SQL Anywhere to implement a global ATM system with tens of thousands of concurrent connections, but SQL Anywhere is much easier to use and deploy and works very well in workgroup settings. Query performance often exceeds some Oracle versions without having to rely on database tuning.

• Reduced support needs
• Monetisation
• Huge performance benfits

• Skilled/experienced resources are less prominent than Microsoft SQL Server or even Oracle, or MySQL, so finding solutions and assistance, if needed, takes more time than it would with other platforms
• You will need to find a good SQL query tool by yourself because the Sybase Central / Interactive SQL utilities are lacking in many basic features, and just generally have a bad user interface

Incentivized