Name: Connecting Tableau with Exasol
Uploaded: 2019-01-08T10:49:44.000Z
Duration: 2 min 4 s
Description: This video shows you how to connect to an Exasol database using Tableau, including our own Dataviz cluster.

Customer Training

Help Desk

Web and Video Conferencing

Customer Support

Cross-Browser Testing

Feature Management

Product Analytics

Virtual Reality

Development

Business Intelligence (BI)

Collaboration

Contract Analysis

Emissions Management

Payment Facilitation

Workflow

Enterprise

Accounting

Accounts Receivable

CTRM

Travel Management

Treasury Management

Finance and Accounting

Applicant Tracking

Corporate Learning Management

HR Management

Payroll

Talent Intelligence

Talent Management

Workforce Analytics

Workforce Management

Human Resources

API Management

Change and Configuration Management

Cloud Migration

Cloud Storage

Configuration Management

Data Deduplication

Database-as-a-Service (DBaaS)

Fraud Detection

Game Engine

Integration Platform as a Service (iPaaS)

Managed Public Cloud Infrastructure

Migration

Mobile Data Security

Mobile Identity

Network Performance Monitoring

SaaS Management

Sensitive Data Discovery

Software Composition Analysis (SCA)

Time Series Databases

Information Technology

A/B Testing

Ad Serving & Retargeting

All-in-One Marketing

Content Management

Content Marketing

Email Marketing

Marketing Automation

Online Reputation Management

Social Media Management

Social Media Publishing

Survey & Forms Building

Web Analytics

Marketing

AI Meeting Assistants

Project Management

Task Management

Professional Services

Customer Relationship Management (CRM)

Lead Generation

Sales Enablement

Sales Incentive Compensation Management

Sales Performance Management

eCommerce Analytics

Sales

Cloud Infrastructure Entitlement Management

Intrusion Detection

Security

Aviation

Banking

Geographic Information

Insurance Agency Management

Insurance Claims Management

Physical Therapy

Vertical-Specific

Find top rated software and services based on in-depth reviews from verified users. 400+ software categories including PaaS, NoSQL, BI, HR, and more.

Priority Matrix

Appfluence

eMeetingsOnline

ReportsNow

FastPIPE

FastEST, Inc.

AspenOne Supply Chain Management

Aspen Technology

Crowdtap

Frosmo

Frosmo Ltd

Azurepath

Azurepath, LLC.

Screenful

Screenful Oy

Aras PLM

Aras Corporation

### Performance Optimization
Reviewers consistently highlight Exasol's performance optimization as a standout feature, with many praising its ability to handle complex queries with remarkable speed and efficiency. Users appreciate the platform's scalability and cost-effectiveness, noting that it significantly improves query performance compared to other solutions. The automatic maintenance of indexes and parallel processing capabilities contribute to the overall positive sentiment towards Exasol's performance optimization functionalities.

### Scalability Solutions
Users consistently highlight Exasol's scalability solutions as a key strength, emphasizing its ability to handle large volumes of data efficiently and effectively. The platform's scalability features are commended for enabling smooth scaling without compromising performance, making it a preferred choice for organizations dealing with extensive datasets. Additionally, users appreciate the minimal maintenance required for optimizing Exasol's scalability solutions, noting that the system's reliability and speed contribute significantly to their operational efficiency.

### Analytics and Reporting
Users consistently highlight Exasol's analytics and reporting functionalities as robust and efficient. They appreciate the ease of generating complex SQL queries, the speed at which reports run, and the ability to handle multiple users working on the same dataset without compromising performance. Exasol's self-service analytics capabilities empower business users to derive insights quickly, reducing the workload on data teams. The platform's fast iteration loops and scalability contribute to faster decision-making processes, enabling organizations to respond promptly to business challenges.

### Business Intelligence and Decision Making
Users appreciate Exasol's robust business intelligence capabilities, noting its ability to provide fast, accurate, and timely data for informed decision-making. The platform's self-service analytics feature empowers business users to derive insights swiftly, reducing the workload on data teams. Additionally, the UDF framework allows for the execution of custom code, enhancing business process agility and facilitating seamless integration with various systems.

Exasol has been widely used by various organizations for a range of use cases. Users have found success with self-service analytics, leveraging the platform's capabilities to gain insights and make data-driven decisions. Additionally, Exasol has proven valuable for ad-hoc queries, allowing users to quickly retrieve specific information on-demand. Financial reporting is another area where the product shines, providing fast, accurate, and timely reports that have resulted in high client satisfaction.

One of the key problems that Exasol addresses is the high cost and poor performance of traditional enterprise data warehouses. By offering an efficient and powerful database technology, Exasol has helped organizations overcome these challenges and streamline their data storage and retrieval processes. Moreover, Exasol serves as a crucial repository for collected data, acting as a central data source for various dashboards and enabling users to monitor and analyze their data effectively.

The flexibility of Exasol has also proven beneficial for resource-constrained environments where internet signals may be weak. Users have been able to deploy more tools on the platform, thanks to its power and adaptability. The multiuser interface of Exasol has facilitated simultaneous data analysis for users and their colleagues, enhancing collaboration capabilities within organizations.

Another significant advantage of Exasol is its ability to improve query performance over Hadoop/Hive. Users have turned to Exasol to address the latency issues associated with these platforms while maintaining fast and efficient data retrieval processes.

In addition to these use cases, organizations in the financial industry rely on Exasol as the backend for reporting and business intelligence. The product replaces Tableau extracts, enabling live connections and true incremental load strategies while centrally managing business logic. This centralized approach ensures efficient data audits and enables timely payments to surgeons.

Overall, the diverse use cases of Exasol highlight its role as a powerful database technology that addresses various challenges in data management, analytics, financial reporting, and more. It offers organizations the flexibility, speed, and reliability needed to make informed decisions and derive meaningful insights from their data.

1. Lack of native support for composite data types: Some users have mentioned that Exasol lacks native support for composite data types, which can be seen as a drawback. This limitation has been noted by multiple reviewers.

2. Absence of native partial backup: Reviewers have pointed out the absence of native partial backup in Exasol, which requires them to use EXPORT instead. This limitation has been raised by several users.

3. Difficulty in detecting data lineage: Users have expressed difficulties in detecting data lineage within Exasol unless it is implemented externally. This lack of built-in functionality has been highlighted by multiple reviewers.

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.

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.

DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.

Db2 Standard Edition

Db2 Advanced Edition

Db2 on Cloud Standard

Db2 on Cloud Enterprise

Db2 Warehouse on Cloud Flex One

Db2 Warehouse on Cloud Flex

Db2 Warehouse on Cloud Flex Performance

Db2 Warehouse on Cloud Flex for AWS

Db2 Warehouse on Cloud Flex Performance for AWS

Db2 on Cloud Lite

Amazon Relational Database Service (Amazon RDS) is a database-as-a-service (DBaaS) from Amazon Web Services.

Amazon RDS for MySQL

Amazon RDS for PostgreSQL

Amazon RDS for MariaDB

Amazon RDS for Oracle

Amazon RDS for SQL Server

Amazon Relational Database Service (RDS)

Exasol

A relational database is a database structured to recognize relations among stored items of information.

Relational Databases

Learn from Johannes Schildgen, database technology professor at OTH Regensburg, how can you try these features on your own by starting an Exasol VM on your PC, or by registering for Exasol's free public demo. 

Find out more at https://community.exasol.com/t5/get-it/ct-p/get_it

50 Awesome features of the Exasol database

Dramatically speed up your Tableau visualizations with EXASOL

Tableau Turbo Enterprise by EXASOL – a live demo

Built for speed: demo – Exasol versus the competition

Für Schnelligkeit entwickelt: Demo - Exasol vs andere Anbieter

Likelihood to Recommend

Usability

Support Rating

Connecting Tableau with Exasol

This video shows you how to connect to an Exasol database using Tableau, including our own Dataviz cluster.

Teradata Vantage

SingleStore

Teradata Database, now Teradata Vantage

Senior Database Administrator

Exasol 2020-11-30 09:54:15

TrustRadius is a technology and business research firm based in Austin, Texas. The company is known as a review platform for verified B2B technology and software reviews through a proprietary algorithm and human verification.

TrustRadius

Level security

Data analytics

Business intelligence

Data import

Large data

Real time

Data sets

Low maintenance

Large data sets

High throughput

Reporting tools

Home

It used as the reporting and business intelligence backend for our primary financial products.

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.

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.

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.

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

Exasol

Overview

What is Exasol?