The solidDB® Speed Loader is a tool for loading data from external files into a solidDB® database.
There are two variants of the solidDB® Speed Loader:
▪solloado provides support for Unicode and partial Unicode databases. It also enables loading of data with multiple threads. solloado is based on the solidDB® ODBC API; the client-side configuration parameters can be used to control the behavior of solloado.
▪solload provides support for partial Unicode databases only. solload is based on the solidDB® SA API.
The solidDB® Speed Loader can load data in various formats and produce detailed information of the loading process into a log file. The format of the import file, that is, the file containing the external data, is specified in a control file.
Key characteristics
▪The data is loaded into the database through the solidDB® engine. This enables online operation of the database during the loading.
▪The data to be loaded does not have to be located on the computer as the solidDB® server.
▪The data is loaded in batches. You can control the number of records committed in one batch.
▪The tables must exist in the database in order to perform data loading.
▪Catalogs are supported with the following syntax:
catalog_name.schema_name.table_name
▪The following constraints are checked:
– referential
– NOT NULL
– unique
▪solidDB® Speed Loader does not support check constraints that are defined using the CREATE TABLE and ALTER TABLE statement and specify data value restrictions in columns.
However, solidDB® Speed Loader always checks for unique or foreign key constraints that are defined using the CREATE TABLE statement.