Data Migration

This section describes how you can load or migrate data from a legacy system directly into Exasol or access data virtually on a legacy database.

IMPORT Command

To transfer data from an external data source into Exasol, use the IMPORT SQL command. Data can be imported directly into a table or returned as result set. The source can be another database, a file, or a script.

For more information, see IMPORT.

Data Migration Scripts

You can use data migration scripts that are provided in an open source project on GitHub to migrate data from different sources into Exasol. The migration process consists of two phases: In the first phase, the table metadata is read from the source system and table definitions (DDL) are transformed for Exasol. In the second phase, the actual data is migrated into Exasol using ExaLoader.

For more information about the data migration scripts, see Exasol's GitHub repository for Database Migration.

Virtual Schema

Exasol supports Virtual Schemas that make external data sources accessible to Exasol without persistent data import. A virtual schema adapter reads schema metadata from the source system and makes these tables accessible in Exasol through regular SQL commands that are handed down to the source system for execution.

For more information about virtual schemas, see How Virtual Schemas Work.