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:
| Manufacturer | Integration | Notes | |
|---|---|---|---|
| SAP | Exasol as a data source | ||
| IBM | Exasol as a data source | ||
| Looker | Exasol as a data source | ||
| Microstrategy | Exasol as a data source | ||
| Microsoft |
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 Q | Exasol as a data source | . | |
| RapidMiner | RapidMiner | Exasol as a data source | |
| Microsoft | Exasol as a data source | ||
| Apache | Exasol as data source | ||
| Tableau | Exasol as a data source | ||
| Yellowfin | Exasol as a data source | ||
| Hitachi Vantara | Exasol as a data source | ||
| Information Builders | Exasol as a data source | ||
| 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 | Database change management |
Cloud Storage Systems
Exasol easily integrates with the following cloud storage systems.
| Product | Manufacturer | Integration | Notes |
|---|---|---|---|
| AWS | |||
| Microsoft | Exasol Cloud Storage Extension | ||
| Microsoft | |||
| Microsoft | Exasol Cloud Storage Extension | ||
| AWS | Virtual Schema for AWS DynamoDB | ||
| GCP | Exasol Cloud Storage Extension |
Database Clients
Exasol easily connects with the following database clients:
|
Product |
Manufacturer | Integration | Notes |
|---|---|---|---|
| Cardett Associates Ltd. | Supported Database | ||
| DBeaver | Supported Database | DBeaver is also available as an Eclipse Plugin. | |
| Jetbrains | Supported Database | ||
| DbVis Software | Supported Database | ||
| Exasol | Supported Database | ||
| SQL Workbench | Supported Database |
Distributed Computing
Exasol integrates with the following distributed computing platforms:
|
Product |
Manufacturer | Integration | Notes |
|---|---|---|---|
| AWS | Kinesis Connector Extension | Refer to How to import data from Amazon Kinesis Data Stream knowledgebase article for more information. | |
| Amazon | |||
| ElasticSearch | Elastic | Virtual Schema | |
| Apache | |||
| Apache | |||
| Apache | |||
| Apache |
Database Drivers and Connectors
You can connect to third party application using the following list of drivers and connectors:
|
Product |
Manufacturer | Integration | Notes |
|---|---|---|---|
| Exasol | .Net Data Provider | ||
| Grant Street Group | Go Language | This is an open source project which is not officially supported by Exasol. | |
| Exasol | JDBC Driver(Java) | ||
| Exasol | ODBC Driver (C++ / .Net) | ||
| Badoo | Python | ||
| Exasol | R | ||
| Blue Yonder | This is an open source project which is not officially supported by Exasol. | ||
| 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 | Exasol Cloud Storage Extension | Import | |
| Apache | Exasol Cloud Storage Extension | Import | |
| Apache | Exasol Cloud Storage Extension | Import / Export | |
| 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 | Exasol as DWH | ||
| 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 | |||
| Integration Test Docker Environment | Exasol | ||
| SQL Statement Builder | Exasol | ||
| Test DB Builder | Exasol |
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 | Exasol as source or target | ||
| Alteryx | Exasol as source or target | ||
| Apache | Hadoop ETL UDFs | ||
| Attunity | Partner | ||
| CloverDX | Partner | ||
| datasqill | Exasol as source or target | ||
| Data Virtuality | Exasol as source or target | ||
| Oracle | Exasol as source or target | ||
| Hitachi Vantara | Exasol as a data source | ||
| Talend | Exasol as source or target | ||
| Theobald Software |
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 | Virtual Schema |
Machine Learning
You can train a system with data from an Exasol database. Exasol integrates with following tools:
|
Product |
Manufacturer | Integration | Notes |
|---|---|---|---|
| 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 |
|---|---|---|---|
| Wise Coders GmbH | Modeling client |
Relational Databases
Exasol integrates with the following relational databases:
|
Product |
Manufacturer | Integration | Notes |
|---|---|---|---|
| Amazon | |||
| IBM | |||
| Exasol | |||
| Oracle | |||
| Oracle | |||
| PostgreSQL | |||
| Amazon | |||
| SAP | |||
| Microsoft | |||
| SAP | |||
| Teradata |
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 | 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 | Supported Database |