TrustRadius Insights for Exasol are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
High Performance: Many users have praised the amazing performance of Exasol, stating that it is incredibly powerful and never compromises computational efficiency. This has been mentioned by multiple reviewers who appreciate being able to focus on building complex logic for their analytics pipelines.
Cost-to-Performance Ratio: Several users have found the cost-to-performance ratio of Exasol to be very competitive, mentioning that it requires much less hardware compared to other options. This has been highlighted by a number of reviewers who value the affordability and efficiency of Exasol.
Efficient Indexed JOINs: The efficient indexed JOINs provided by Exasol are considered best in class by some users. They appreciate the effectiveness and speed of these joins, which enable smooth data processing and analysis.
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
Likelihood to Recommend
Exasol is well suited for data warehousing, BI, ML, AI - all analytical queries. It has almost no operation cost, because it is selfmaintening the indexes etc.
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
Likelihood to Recommend
Really solid data solution for warehousing and data processing. Super fast with really great performance to handle huge data volumes efficiently and easily. Great support team to help with implementation and onboarding as well as aftersales support - can't speak highly enough of the team and how easy it is to work with them.
It used as the reporting and business intelligence backend for our primary financial products.
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.
Likelihood to Recommend
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.)