navigation
search
Bulk loaders
Bulk loaders are components of graph that writes data to output database.
These components load data to database using database utility. It is faster than DBOutputTable. Load formats data pages directly, while avoiding most of the overhead of individual row processing that inserts incur.
Common attributes
| Attribute | Description | Example |
|---|---|---|
id | component identification | string |
type | component type. This attribute is automatically generated from gui. | string |
| Bulk loader | Description |
|---|---|
| OracleDataWriter | This component loads data to Oracle database using sqlldr load utility. |
| DB2DataWriter | This component loads data to DB2 database using db2 load utility. |
| InfobrightDataWriter | This component loads data to Infobright database. |
| InformixDataWriter | This component loads data to Informix database using dbload or load2 utility. |
| MSSQLDataWriter | This component loads data to MsSql database using the bcp utility. |
| MysqlDataWriter | This component loads data to Myql database using the mysql utility and LOAD DATA INFILE statement. |
| PostgreSqlDataWriter | This component loads data to PostgreSwl database using the psql utility and copy statement. |
