Ecosystem Overview

Exasol seamlessly fits into customer environments and has a native connector for a wide range of tools 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) help you analyze data to make better business decisions. This data can be from internal systems or external sources. BI tools 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 a data source
Pyramid Analytics OS	Pyramid Analytics	Exasol as a data source
Qlik Sense	Qlik Q	Exasol as a data source	.
SQL Server Analysis Services	Microsoft	Exasol as a data source
Superset	Apache	Exasol as a 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	Contact support for more details.

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 a data source
Alation	Alation	Custom Connector	Contact Alation for more details.

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

Data Sources

Exasol can integrate with the following data sources to load data using Exasol's powerful IMPORT statement, UDF Framework, or Virtual Schemas.

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.
Amazon S3	AWS	Import from CSV Exasol Cloud Storage Extension Virtual Schema for Document Files in S3
Apache Hadoop	Apache	Hadoop ETL UDFs
Athena	Amazon	Virtual Schema Import from JDBC
Aurora	Amazon	Virtual Schema Import from JDBC
Azure Blob Storage	Microsoft	Import from CSV Exasol Cloud Storage Extension
BigQuery	Google	Virtual Schema Import from JDBC
Data Lake (Gen1) Storage	Microsoft	Exasol Cloud Storage Extension
Data Lake (Gen2) Storage	Microsoft	Exasol Cloud Storage Extension
DB2	IBM	Virtual Schema Import from JDBC
DynamoDB	AWS	Virtual Schema for AWS DynamoDB
ElasticSearch	Elastic	Virtual Schema
Exasol	Exasol	Virtual Schema Import from EXA
Google Cloud Storage	GCP	Import from CSV Exasol Cloud Storage Extension
HANA	SAP	Virtual Schema Import from JDBC
Hive	Apache	Virtual Schema Import from JDBC
Impala	Apache	Virtual Schema Import from JDBC
Kafka	Apache	Kafka Connect JDBC Exasol Kafka Connector Extension
MySQL	Oracle	Virtual Schema Import from JDBC
Oracle	Oracle	Virtual Schema Import from JDBC
PostgreSQL	PostgreSQL	Virtual Schema Import from JDBC
Redis	Redis	Virtual Schema
Redshift	Amazon	Virtual Schema Import from JDBC
Spark	Apache	Spark Exasol Connector
SQL Server	Microsoft	Virtual Schema Import from JDBC
Sybase	SAP	Virtual Schema Import from JDBC
Teradata	Teradata	Import from JDBC

Data Warehouse Automation

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	Contact support for more details.

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

Development and Testing Tools

Exasol integrates with the following tools used to 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
jOOQ	jOOQ	Java

ETL

ETL (Extract, Transfer, Load) tools help combine heterogeneous data sources 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	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
Informatica	Informatica	Exasol Connector
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
Talend	Talend	Exasol as source or target
Xtract Universal	Theobald Software	Exasol as target

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.
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
KNIME	KNIME	Exasol as a data source	Exasol can be integrated using the JDBC driver
RapidMiner	RapidMiner	Exasol as a data source

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:

Product	Manufacturer	Integration	Notes
DbSchema	Wise Coders GmbH	Modeling client
SAP PowerDesigner	SAP	Plug-in for Exasol

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 tools helps businesses 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
Automic (UC4)	Broadcom	Supported Database