Loading Data from External Sources

You can integrate any database with Exasol by using IMPORT and EXPORT statements. You need to upload the corresponding JDBC driver into the Exasol (see Manage JDBC Drivers) and then use the generic JDBC interface for IMPORT and EXPORT. By supporting native interfaces to the database systems Exasol and Oracle, we achieve even better performance.

You can load data by an SQL command 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: