Ecosystem Overview

This overview provides links to information about many different tools that can connect to Exasol.

This page does not include all of the many currently available integrations for Exasol on the market, and it is regularly updated. If you want us to add an integration to this list, open a support case.

Exasol takes no responsibility for changes in functionality or terms of use for third-party tools. For more details about the compatibility and use of these tools with Exasol, refer to the respective software vendor’s website.

Business intelligence (BI)

Business intelligence tools (BI tools) help you analyze data from internal systems or external sources to make better business decisions. BI tools are used to generate reports, dashboards, and data visualizations from your data.

Exasol integrates with the following BI tools:

Product Manufacturer Integration Notes
Amazon QuickSight Amazon Exasol as a data source  

Business Objects

SAP Exasol as a data source  

IBM Cognos

IBM Exasol as a data source  

Looker

Looker Exasol as a data source  
Metabase Metabase Exasol as a data source  

Microstrategy

Microstrategy Exasol as a data source  

Pentaho Business Analytics

Hitachi Vantara Exasol as a data source  

PowerBI

Microsoft

Exasol as a data source

 

Pyramid Analytics OS Pyramid Analytics Exasol as a data source  

Qlik Sense

Qlik Exasol as a data source  

SAS

SAS Exasol as a data source  
Sisense Sisense Exasol as a data source The connection is made using a certified Connector.

SQL Server Analysis Services

Microsoft Exasol as a data source  

Superset

Apache Exasol as a data source  

Tableau

Tableau Exasol as a data source  
Veezoo Veezoo Exasol as a data source  

Yellowfin

Yellowfin Exasol as a data source  

WebFOCUS BI

Information Builders Exasol as a data source  

Change management

To track and manage database changes, Exasol integrates with the following change management tools:

Product Manufacturer Integration Notes

Sqitch

Sqitch Database change management Contact support for more details.

Data catalogs

Data catalogs play a significant role in managing all your data needs. Exasol integrates with the following data catalog platforms: 

Product Manufacturer Integration Notes
Alation Alation Custom Connector Contact Alation for more details.
Azure Data Catalog Microsoft Exasol as a data source  
Collibra Collibra Exasol as a data source  
D-QUANTUM Synabi Exasol as a data source Contact Synabi for more details

Data virtualization and query engines

Data virtualization allows applications to operate on data in a virtual layer instead of replicating data between systems.

The following data virtualization tools support Exasol as a data source:

Product

Manufacturer Integration Notes

Denodo

Denodo

Exasol as a data source

Cache module

Driver for Exasol is included in Denodo.
Data Virtuality Data Virtuality Exasol as a data source  
Trino Trino Exasol as a data source  

Data warehouse automation

Data warehouse automation refers to the process of automating the steps involved in a data warehouse development cycle. The following is a list of data warehouse tools that you can integrate with Exasol.

Product

Manufacturer Integration Notes

Datavault Builder

Datavault Builder Exasol as DWH  
datavault4dbt Scalefree Exasol as DWH  

WhereScape

WhereScape Exasol as DWH Contact support for more details.
Yotilla Exasol Exasol as DWH  

Database clients

Exasol easily connects with the following database clients: 

Product

Manufacturer Integration Notes

Advanced Query Tool

Cardett Associates Ltd. Supported Database  

DBeaver

DBeaver Supported Database DBeaver is also available as an Eclipse Plugin.

DataGrip

Jetbrains Supported Database  

DBVisualizer

DbVis Software Supported Database  
PushMetrics PushMetrics Exasol as a data source  
VSCode Microsoft Community Extension The extension is created and maintained by Revolut.

Database drivers and connectors

You can connect to third party applications using the following list of drivers and connectors:

Product

Manufacturer Integration Notes

ADO.NET Data Provider

Exasol .Net Data Provider  

Exasol Go SQL Driver

Exasol Go Language  
Exasol REST API service (ERA) Exasol

REST-compliant API

ERA (alpha) is an extension for the Exasol database that provides the ability to interact with the database via REST API endpoints.
Ibis   Python Ibis is an open source project which defines a Python dataframe API that can execute with Exasol as a backend.
Javascript/Typescript driver Exasol Javascript/Typescript Exasol Typescript/Javascript driver for Node and the browser.

JDBC Driver

Exasol JDBC Driver(Java)  

ODBC Driver

Exasol ODBC Driver (C++ / .Net)  

PyExasol

Exasol Python PyExasol was originally developed by Vitaly Markov and is now officially supported by Exasol.

R Integration

Exasol R  
Rust   exasol v0.3.2 This is an open source project which is not officially supported by Exasol. The maintainer is the Rust community, and current owner is Bogdan Mircea.

SQLAlchemy

Exasol

SQLAlchemy Dialect for Exasol DB

 

Turbodbc

Blue Yonder Python This is an open source project which is not officially supported by Exasol.
WebSockets Exasol Websockets API This JSON over WebSockets client-server protocol enables implementation of your own drivers for all kinds of platforms using a connection-based web protocol.

Development and testing tools

Exasol integrates with the following tools used to perform database integration testing:

Product

Manufacturer Integration Notes

Exasol Testcontainers

Exasol

Java Testcontainers

 
Integration Test Docker Environment Exasol

Docker

 
jOOQ jOOQ

Java

 
SOL Statement Builder Exasol

Java

 
Test DB Builder Exasol

Java

 

ETL

ETL data integration tools are used to combine heterogeneous data sources into the same platform for analytics purposes. Exasol integrates with the following ETL tools:

Product

Manufacturer Integration Notes
Ab Initio Ab Initio Exasol as target Contact Ab Initio for more details.
Aecorsoft Aecorsoft Exasol as target  

Alteryx

Alteryx Exasol as source or target  
Azure Data Factory Microsoft Exasol as source or target You can also use the Exasol Bulk Loader using our Azure Data Factory Functions.

CloverDX

CloverDX Partner  

datasqill

datasqill Exasol as source or target Contact support for more details.

Data Virtuality

Data Virtuality Exasol as source or target  
AWS Glue Amazon Exasol as source or target Allows accessing Exasol database in Glue Studio.
Informatica Informatica

Generic ODBC as source or target

Connection is made using the generic ODBC interface.
Keboola Keboola Exasol as target  

Oracle Data Integrator

Oracle Exasol as source or target Contact support for more details.

Pentaho Data Integration (PDI)

Hitachi Vantara Exasol as a data source  
SAP Data Services (BODS) SAP Exasol as a data source Connection is made using the generic ODBC interface.

Xtract Universal

Theobald Software

Exasol as target

 

Low-code platforms

Low-code development platforms enable creation of business applications with minimal knowledge of coding or software development. Exasol integrates with the following low-code platforms:

Product

Manufacturer Integration Notes

OutSystems

OutSystems Supported Database  
Microsoft Power Apps Microsoft

The Power Apps Connector for Exasol

Exasol REST API (ERA)

Exasol Reference

The Power Apps Connector for Exasol enables organizations to build low-code Power Apps that communicate with the Exasol database. The Power Apps Connector for Exasol utilizes the ERA.
UI Bakery UI Bakery Exasol as a data source  

Machine learning

You can train a system with data from an Exasol database. The following list describes some machine learning tools that can integrate with Exasol.

See also the Advanced Analytics section for information about how to use Exasol AI Lab and other tools for data science and machine learning.

Product

Manufacturer Integration Notes

AWS SageMaker Autopilot

Amazon

Exasol SageMaker Extension

Try out now in Exasol AI Lab

Dataiku Dataiku Exasol Connector  
DataRobot DataRobot Exasol as a data source  
H20.ai H20.ai Exasol as a data source Exasol can be integrated using the JDBC driver
Exasol AI Lab Exasol Exasol AI Lab  
KNIME KNIME Exasol as a data source Exasol can be integrated using the JDBC driver
RapidMiner RapidMiner Exasol as a data source  
SPSS Modeler IBM Exasol as a data source  
Zingg Zingg Exasol as a data source  

Modeling

You can use data modeling tools to simplify the process of defining, structuring, and organizing data in a database management system. Exasol integrates with following data modeling tools: 

Product

Manufacturer Integration Notes

DbSchema

Wise Coders GmbH Modeling client  
SAP PowerDesigner SAP Plug-in for Exasol  

Workflow management tools

Workflow management tools can help you automate and control business processes to boost productivity and effectively reduce cost. The following tools can be used with Exasol to provide an infrastructure for setting up, scheduling, and monitoring a defined sequence of tasks arranged as a workflow application.

Product Manufacturer Integration Notes

Apache Airflow

Apache Supported Database  
Automic (UC4) Broadcom Supported Database  
dbt dbt Exasol as supported data platform Community plugin
Prefect Prefect Supported Database