Import Tool page

Repository > Import/Export > Import

Purpose of the page

This page makes it possible to import files from previously created tables into databases.

Buttons and/or links on the page

Element	Description
Load local files	Loads the files selected by a computer accessible by the user.
Load remote files	Loads the selected files into the file upload folder in the application server.
Abort	Stops the import process.
Schedule	Opens the Scheduling window to schedule the import.
Run	Run the import.

Advanced import options

Element	Description
Delete all Analytical Workspace partitions	For imports to Analytical workspace tables, delete all partitioning tables before importing the data.
Write mode	Sets the write mode for the imported data: - Deletion/Insertion: deletes the data in the tables before inserting the imported data. - Only insertion: adds the imported data to the existing data. - Only deletion: empties the tables for which data will be imported without inserting new data.
Continue import from the table	Resumes the export from the point at which it was previously interrupted due to an error.
Tables with CLOB fields with bulk insertion	Governs the behaviour of the import for tables with at least one CLOB (character large objects) column. Accelerates data loading during mass insertions. Note: only use when you are certain that the original database contains only a few small columns with these characteristics.
Empty the DB before importing	Empties the database before importing the new tables. This makes it possible to delete all the tables not involved in the import.

Page fields

Please find below the most important fields.

Field	Description
Files to import
File location	Location of the file to upload.
Database
Database	Database into which to import the data and list of tables contained in the imported file