Ecosystem Overview

Exasol seamlessly fits into customer environments and has a native connector for a wide range of tools for various purposes such as business intelligence, data integration / ETL, programming languages, and query tools. If you (as a Solution Architect) want to know how Exasol fits into your data infrastructure, see Planning Guide.

This page provides you with a list of tools that you can connect to Exasol.

The list below is not all-inclusive of every type of integration. We are working on updating this list with new information. If there is any specific type of integration that you would like us to include, please contact us.

Business Intelligence (BI)

Business Intelligence tools (BI tools) helps you analyze data to make better business decisions. This data can be from internal systems or external sources. BI tools analyze these data, generate reports, dashboards, and data visualizations that offer information at- a- glance.

Exasol integrates with the following BI tools:

Product Manufacturer Integration Notes

Business Objects

SAP Exasol as a data source  

IBM Cognos

IBM Exasol as a data source  

Looker

Looker Exasol as a data source  

Microstrategy

Microstrategy Exasol as a data source  

PowerBI

Microsoft

Exasol as data source

Power BI is available as a custom connector. For more information, refer to Power BI - Exasol Connector.

Pyramid Analytics OS Pyramid Analytics Exasol as data source  

Qlik Sense

Qlik Q Exasol as a data source .
RapidMiner RapidMiner Exasol as a data source  

SQL Server Analysis Services

Microsoft Exasol as a data source  

Superset

Apache Exasol as data source  

Tableau

Tableau Exasol as a data source  

Yellowfin

Yellowfin Exasol as a data source  

Pentaho Business Analytics

Hitachi Vantara Exasol as a data source  

WebFOCUS BI

Information Builders Exasol as a data source  

SAS

SAS 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  

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  

EXAPlus CLI

Exasol Supported Database  

SQL Workbench

SQL Workbench Supported Database  

Distributed Computing

Exasol integrates with the following distributed computing platforms: 

Product

Manufacturer Integration Notes

Amazon Kinesis Data Streams

AWS Kinesis Connector Extension Refer to How to import data from Amazon Kinesis Data Stream knowledgebase article for more information.

Athena

Amazon

Virtual Schema

Import from JDBC

 

Big Query

Google

Virtual Schema

Import from JDBC

 
ElasticSearch Elastic Virtual Schema  

Hive

Apache

Virtual Schema

Import from JDBC

 

Impala

Apache

Virtual Schema

Import from JDBC

 

Kafka

Apache

Kafka Connect JDBC Exasol

Kafka Connector Extension

 

Spark

Apache

Spark Exasol Connector

 

Database Drivers and Connectors

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

Product

Manufacturer Integration Notes

ADO.NET Data Provider

Exasol .Net Data Provider  

go-exasol-client

Grant Street Group Go Language This is an open source project which is not officially supported by Exasol.

JDBC Driver

Exasol JDBC Driver(Java)  

ODBC Driver

Exasol ODBC Driver (C++ / .Net)  

PyExasol

Badoo Python  

R Interface

Exasol R  

SQLAlchemy

Blue Yonder

SQLAlchemy Dialect for Exasol DB

This is an open source project which is not officially supported by Exasol.

Turbodbc

Blue Yonder Python This is an open source project which is not officially supported by Exasol.

Data Formats

Exasol has integration with the following data formats.

Product Manufacturer Integration Nodes

Apache Avro

Apache Exasol Cloud Storage Extension Import

Apache Orc

Apache Exasol Cloud Storage Extension Import

Apache Parquet

Apache Exasol Cloud Storage Extension Import / Export

Delta Lake

Databricks Exasol Cloud Storage Extension Import

Data Governance

Data Governance plays a significant role in managing all your data needs. Exasol integrates with the following data governance platforms: 

Product Manufacturer Integration Notes
Collibra Collibra Exasol as datasource  

Data Warehouse Automation

A data warehouse is a centralized repository for your data and data warehouse automation refer 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  

WhereScape

WhereScape Exasol as DWH  

Development and Testing Tools

Exasol integrates with the following testing tools using which you can perform database integration testing.

Product

Manufacturer Integration Notes

Exasol Testcontainers

Exasol

Java Testcontainers

 
Integration Test Docker Environment Exasol

Docker

 
SQL Statement Builder Exasol

Java

 
Test DB Builder Exasol

Java

 

ETL

ETL (Extract, Load, Transfer) tools help combine heterogeneous data source into the same platform for the purpose of analytics. Exasol integrates with the following ETL tools:

Product

Manufacturer Integration Notes

Ab Initio

Ab Initio Exasol as source or target  

Alteryx

Alteryx Exasol as source or target  

Apache Hadoop

Apache Hadoop ETL UDFs  

Attunity

Attunity Partner  

CloverDX

CloverDX Partner  

datasqill

datasqill Exasol as source or target  

Data Virtuality

Data Virtuality Exasol as source or target  

Oracle Data Integrator

Oracle Exasol as source or target  

Pentaho Data Integration (PDI)

Hitachi Vantara Exasol as a data source  

Talend

Talend Exasol as source or target  

Xtract Universal

Theobald Software

Exasol as target

 

Key-Value Stores

A key-value store is a type of database that uses a simple key/value method to store data. Exasol integrates with the following key-value stores: 

Product

Manufacturer Integration Notes

Redis

Redis Virtual Schema  

Machine Learning

You can train a system with data from an Exasol database. Exasol integrates with the following tools: 

Product

Manufacturer Integration Notes

AWS SageMaker

Amazon Exasol as a training data source
&
Use trained Sagemaker Endpoint for in query predictions
Data science examples are available on GitHub.

Modeling

The process of defining, structuring, and organizing data in a database management system is simplified by using data modeling tools. Exasol integrates with following tools: 

Product

Manufacturer Integration Notes

DbSchema

Wise Coders GmbH Modeling client  

Relational Databases

Exasol integrates with the following relational databases: 

Product

Manufacturer Integration Notes

Aurora

Amazon

Virtual Schema

Import from JDBC

 

DB2

IBM

Virtual Schema

Import from JDBC

 

Exasol

Exasol

Virtual Schema

Import from JDBC

 

MySQL

Oracle

Virtual Schema

Import from JDBC

 

Oracle

Oracle

Virtual Schema

Import from JDBC

 

PostgreSQL

PostgreSQL

Virtual Schema

Import from JDBC

 

Redshift

Amazon

Virtual Schema

Import from JDBC

 

HANA

SAP

Virtual Schema

Import from JDBC

 

SQL Server

Microsoft

Virtual Schema

Import from JDBC

 

Sybase

SAP

Virtual Schema

Import from JDBC

 

Rapid Application Development

Rapid Application Development (RAD) refers to the agile software development methodology that prioritizes early prototype releases and iterations. RAD enables low-code rapid application development through which businesses can roll-out new applications faster. Exasol integrates with the following tools:

Product

Manufacturer Integration Notes

OutSystems

OutSystems Supported Database  

Workflow Management Tools

Workflow Management tool helps business to automate and control their processes to boost productivity and effectively reduce cost. These tools 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  

Data Protection

Data protection tools help you enhance your data security by masking sensitive data or by substituting sensitive data with non-sensitive data as a token..

Product Manufacturer Integration Notes

Protegrity

Protegrity Supported Database