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 EXAoperationl (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:
- 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