Ecosystem Overview
This overview provides links to information about many different tools that can connect to Exasol.
Exasol seamlessly fits into customer environments and has native connectors for a wide range of tools and programming languages. For more information about how Exasol fits into your data infrastructure, see also the Planning Guide section.
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, create 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 | |
| SAP | Exasol as a data source | ||
| IBM | Exasol as a data source | ||
| Looker | Exasol as a data source | ||
| Metabase | Metabase | Exasol as a data source | |
| Microstrategy | Exasol as a data source | ||
| Hitachi Vantara | Exasol as a data source | ||
| Microsoft |
|
||
| Pyramid Analytics OS | Pyramid Analytics | Exasol as a data source | |
| Qlik | Exasol as a data source | ||
| SAS | Exasol as a data source | ||
| Sisense | Sisense | Exasol as a data source | The connection is made using a certified connector. |
| Microsoft | Exasol as a data source | ||
| Apache | Exasol as a data source | ||
| Tableau | Exasol as a data source | ||
| Veezoo | Veezoo | Exasol as a data source | |
| Yellowfin | Exasol as a data source | ||
| 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 | Database change management | Fore more information, contact Support. |
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 | For more information, contact Alation. |
| Azure Data Catalog | Microsoft | Exasol as a data source | |
| Collibra | Collibra | Exasol as a data source | |
| D-QUANTUM | Synabi | Exasol as a data source | For more information, contact Synabi. |
| OpenMetadata | OpenMetadata | Exasol as a data source |
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 | Supported database |
Data sources
Exasol can integrate with the following data sources to load data using the IMPORT SQL statement, user defined functions (UDFs), or Virtual Schemas.
|
Product |
Manufacturer | Integration | Notes |
|---|---|---|---|
| Amazon | |||
| AWS | Kinesis Connector Extension | ||
| AWS | |||
| Apache | Exasol Cloud Storage Extension | ||
| Amazon | |||
| Microsoft | |||
| Azure Event Hubs | Microsoft | ||
| Microsoft | |||
| Microsoft | Exasol Cloud Storage Extension | ||
| Databricks | Databricks | Virtual schema | |
| IBM | |||
| AWS | Virtual schema for AWS DynamoDB | ||
| ElasticSearch | Elastic | Virtual schema | |
| Exasol | |||
| GCP | Exasol Cloud Storage Extension | ||
| SAP | |||
| Apache | |||
| Apache | |||
|
Apache |
|||
| Oracle | |||
| Oracle | |||
| PostgreSQL | |||
| Redis | Virtual schema | ||
| Amazon | |||
| Snowflake | Snowflake | Virtual schema | |
| Apache | |||
| Microsoft | |||
| SAP | |||
| Teradata |
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 |
|---|---|---|---|
| CData Virtuality | CData | Exasol as a data source | |
| Denodo | Driver for Exasol is included in Denodo. | ||
| 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 | Exasol as DWH | ||
| datavault4dbt | Scalefree | Exasol as DWH | |
| WhereScape | Exasol as DWH | Fore more information, contact Support. |
Database clients
Exasol easily connects with the following database clients:
|
Product |
Manufacturer | Integration | Notes |
|---|---|---|---|
| Cardett Associates Ltd. | Supported database | ||
| DBeaver | Supported database | ||
| Jetbrains | Supported database | ||
| DbVis Software | Supported database | ||
| PushMetrics | PushMetrics | Exasol as a data source | |
| VSCode | Microsoft | Supported database |
Database drivers and connectors
You can connect to third party applications using the following list of drivers and connectors:
|
Product |
Manufacturer | Integration | Notes |
|---|---|---|---|
| Exasol | ADO.NET Data Provider | ||
| Exasol | Go Language | ||
| Exasol REST API service (ERA) | Exasol | 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 that defines a Python dataframe API, which can execute with Exasol as a backend. | |
| Javascript/Typescript driver | Exasol | Javascript/Typescript | Exasol Typescript/Javascript driver for Node and the browser. |
| Exasol | JDBC Driver(Java) | ||
| Exasol | ODBC Driver (C++ / .Net) | ||
| Exasol | Python | PyExasol was originally developed by Vitaly Markov and is now officially supported by Exasol. | |
| 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. | |
| Exasol | |||
| 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 | |||
| Integration Test Docker Environment | Exasol | ||
| jOOQ | jOOQ | ||
| SOL Statement Builder | Exasol | ||
| Test DB Builder | Exasol |
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 | For more information, contact Ab Initio. |
| Aecorsoft | Aecorsoft | Exasol as target | |
| 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. |
| CData | Exasol as source or target | ||
| CloverDX | Partner | ||
| datasqill | Exasol as source or target | Fore more information, contact Support. | |
| AWS Glue | Amazon | Exasol as source or target | Allows accessing Exasol database in Glue Studio. |
| Informatica | Informatica | Connection is made using the generic ODBC interface. | |
| Keboola | Keboola | Exasol as target | |
| Oracle | Exasol as source or target | Fore more information, contact Support. | |
| 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. |
| Qlik | Exasol as source or target | ||
| Theobald Software |
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 | Supported database | ||
| Microsoft Power Apps | Microsoft | 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 in this documentation to learn more about how to use Exasol AI Lab and other tools for data science and machine learning.
|
Product |
Manufacturer | Integration | Notes |
|---|---|---|---|
| Amazon |
Try it 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 |
|---|---|---|---|
| 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 | Supported database | ||
| Automic (UC4) | Broadcom | Supported database | |
| dbt | dbt | Exasol as supported data platform | Community plugin |
