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:
- Loading Data from Amazon Redshift
- Apache Kafka Integration
- Apache Spark Integration
- Loading Data from DB2
- Loading Data using Generic JDBC
- Loading Data from Google BigQuery
- Hadoop and Other Systems
- Loading Data from Hive
- Loading Data from MySQL
- Loading Data from Oracle
- Loading Data from PostgreSQL
- Loading Data from Microsoft SQL Server
- Loading Data from Teradata