Load Data from External Sources

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 EXAoperation (see Manage JDBC Drivers) and then use the generic JDBC interface for 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 through subselects. You can even specify a statement instead of a table name for the external data source which is executed on that system, for example, to load a certain part of a table into Exasol.

This section describes how you can connect to sources with Exasol for importing or exporting of data. The section covers the following topics: