DataLoader
Description
The DataLoader can be used to load data into the target system. The DataLoader uses the load utilities of each supported DBMS.
Input parameters
| Parameter | Description |
|---|---|
url |
The url of the target system. |
user |
The user of the DBMS |
password |
The user’s password. |
osuser |
The user of the operating system. |
host |
The host machines address. |
sshport |
The port to create a SSH connection. Default: 22 |
ospassword |
The password of the operating system user. |
useEncryptedPassword |
Shows if the given password has to be decrypted. Default: true |
connectionType |
Here the connection type can be set. It is possible to set: "FTP", "FTPS" or "SFTP". Default: "SFTP" |
threadCount |
Here you can define how many threads the DataLoader can use. Default: 5 |
databaseType |
This property controls witch database type the target database is. Possible values are: "DB2_LUW", "ORACLE", "DB2_ZOS", "MS_SQL_SERVER" or "POSTGRESQL". |
sourceInputFile |
This is the object container from the source of the data. |
targetInputFile |
This is the object container from the target system. |
errorFile |
In case the DataLoader produces errors, these can be written to this file. |