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

Cloud Storage Systems

Exasol easily integrates with the following cloud storage systems.

Product	Manufacturer	Integration
Amazon S3	AWS	Exasol Cloud Storage Extension Virtual Schema for Document Files in S3
Azure Blob Storage	Microsoft	Exasol Cloud Storage Extension
Data Lake (Gen1) Storage	Microsoft	Exasol Cloud Storage Extension
Data Lake (Gen2) Storage	Microsoft	Exasol Cloud Storage Extension
DynamoDB	AWS	Virtual Schema for AWS DynamoDB
Google Cloud Storage	GCP	Exasol Cloud Storage Extension

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
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
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
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