This section describes how you can connect Exasol to external sources to import and export data.
You can integrate any database with Exasol as long as the external source supports a JDBC interface. You need to upload the corresponding JDBC driver into IMPORT and EXPORT. By supporting native interfaces to Exasol and Oracle databases, we achieve even better performance.
You can load data using the IMPORT and EXPORT statements and combine that with further post-processing using subselects. You can specify a statement instead of a table name for the external data source that is executed on that system, for example, to load a certain part of a table into Exasol.
The articles in this section describe how to connect and load data from the following source types:
