TrustRadius: an HG Insights company

Exasol

Score9.1 out of 10

1 Reviews and Ratings

Get a Demo

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

Most Frequent Users

Top 3 industries using Exasol
Based on HG Insights installation data
View all Reviews
#1 most frequent

Professional, Scientific, and Technical Services

22.9%

22 installations of 96

#2 most frequent

Information

13.5%

13 installations of 96

#3 most frequent

Manufacturing

10.4%

10 installations of 96

Reviews

What users are saying about Exasol.
View all reviews

Exasol performance is excellent

Peter Michael Soerensen
Senior DW/BI Consultant at DataBi Danmark Aps (1-10 employees 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 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 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