TrustRadius: an HG Insights company

Exasol

Score8.6 out of 10

4 Reviews and Ratings

What is Exasol?

Exasol, from the company of the same name in Nuremberg, is presented by the vendor as a high-performance in-memory analytics database that aims to transform how organizations works with data, on-premises, in the cloud or both.

Categories & Use Cases

Videos

Exasol Key Features

Learn about the best (and worst!) features Exasol has to offer, as determined by TrustRadius' reviewers.
Based on 4 ratings of Exasol's features
View all Exasol features

Top Performing Features

  • Database locking

    Locking mechanisms prevent users from accessing data while it is being updated.

    Category average: 8.9

  • Encryption

    Data is encrypted in-motion and at rest, preventing unauthorized access and security breaches.

    Category average: 8.6

  • Disaster recovery

    Data can be recovered in the event of a disaster.

    Category average: 8.6

Areas for Improvement

  • ACID compliance

    The database complies with ACID (atomicity, consistency, isolation, durability), ensuring transactions are processed reliably.

    Category average: 8.9

  • Database monitoring

    Teams can monitor database usage and performance metrics.

    Category average: 9

  • Flexible deployment

    The database can be deployed in a variety of environments and operating systems.

    Category average: 8.4

Who Buys & Uses Exasol

Exasol Reviews

What users are saying about Exasol.
View all Exasol reviews

Loved the Exasol Xperience26

Verified User
Analyst in Human Resources (10,001+ employees)

Use Cases and Deployment Scope

Joined the Exasol Xperience26 event. Really good speakers and amazing coverage of topics around AI.
Exasol provides a highly reliable and fast foundation layer for the organizations to build AI with the added benefit of data sovereignty.

Pros

  • High reliablility
  • Data sovereignty
  • Fast

Cons

  • None

Return on Investment

  • Solves AI use cases

Usability

Alternatives Considered

Google BigQuery

Exasol performance is excellent

Peter Michael Soerensen
Senior DW/BI Consultant at DataBi Danmark Aps (1-10 employees)

Use Cases and Deployment Scope

We use Exasol as the main databaseplatform for Data Warehouse / BI and all ELT processes. We transitioned from MS SQL server in 2018 to Exasol, because of huge performance problems. Exasol solved these issues and going from 2-3 days between new data, we are now able to have daily updates in the big fact tables and dimensions, but also intraday updating every 5 minutes from +100 end points. Ad-hoc reporting that sometimes stalled the system is now running in minuttes. All the ETL/ELT processes is much faster than before and we have 10 times more users on the system than before on a small cluster.

Pros

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

Cons

  • Better backup possibilities
  • Better management tool like the exaplus

Return on Investment

  • Public sector, so it does not influence ROI, but it has answered a lot of political questions that was not able to be answered earlier in time.

Usability

Alternatives Considered

Microsoft SQL Server, MySQL and Oracle Database

Other Software Used

Talend Data Integration, DBeaver

Speed and performance like nothing else

Dominic AlbrechtView profile
Head of Analytics in Information Technology at Digital Planet (51-200 employees)

Use Cases and Deployment Scope

We used Exasol to replace a SQL based reporting solution with massively positive results in usability - huge improvements for the internal team and clients, which has turned in to a solution that we have been able to monetize. All of which would not be possible without the speed that Exasol brings.

Pros

  • Speed
  • Usability
  • Performance

Cons

  • SaaS offering in Azure
  • Upgradability
  • Management interface

Return on Investment

  • Reduced support needs
  • Monetisation
  • Huge performance benfits

Usability

Alternatives Considered

Snowflake

Other Software Used

Yellowfin, Acumatica

Exasol is so powerful it's fun.

Peter KiokoView profile
Senior Database Administrator in Information Technology at Grant Street Group (201-500 employees)

Pros

  • We have found Exasol to be very fast at summarizing large data sets. It has been a great backend for both reporting tools and data analytics/business intelligence. Combined with the fact that data import is also very fast it makes it ideal for a real-time ELT architecture.
  • Exasol is low maintenance. No indexes to maintain (The database auto-manages them) and very little tuning is required.
  • Query processing is optimized for high throughput and high parallelization. This means that even under high loads performance degrades gracefully as opposed to having "pile-ups" and "meltdowns". This has made it a very reliable database for us.

Cons

  • Exasol doesn't have some of the advanced enterprise-y features found in some other large corporate database systems (e.g. native row-level and column-level security). However it's pretty customizable (SQL pre-processing, virtual schemas, powerful user-defined-function frameworks) so many of these features can be implemented manually.

Return on Investment

  • When we first migrated to Exasol (from a MySQL-backed reporting tool) our clients spent over an order of magnitude less time waiting on reports and since then it has opened up possibilities for reporting and analyzing data that were simply not possible beforehand.

Alternatives Considered

SingleStore (formerly MemSQL) and Teradata Vantage Advanced SQL Engine (Teradata Database)

Usability