http://wiki.clovergui.net/ 2010-09-05T12:21:38+02:00 http://wiki.clovergui.net/ http://wiki.clovergui.net/lib/images/favicon.ico text/html 2009-09-16T12:27:17+02:00 http://wiki.clovergui.net/doku.php?id=components:bulkloaders:db2_data_writer&rev=1253096837&do=diff This component loads data to DB2 database using db2 load utility. It is faster then DBOutputTable. Load formats data pages directly, while avoiding most of the overhead of individual row processing that inserts incur (for example, logging is virtually eliminated). Also, load can better exploit parallelism on multiprocessor machines. text/html 2010-01-29T11:03:20+02:00 http://wiki.clovergui.net/doku.php?id=components:bulkloaders:infobright_data_writer&rev=1264759400&do=diff since 2.9 version This component loads data to Infobright database. It supports local load, as well as, the remote one. If the hostname is “localhost” or “127.0.0.1” then the load will be done using a local pipe. Otherwise it will use a remote pipe. The external IP address of the server is not recognized as a local server. If loading to a remote server, then you need to start the Infobright remote load agent on the server where Infobright is running. The command to do this is: java -jar infobr… text/html 2009-09-16T12:27:17+02:00 http://wiki.clovergui.net/doku.php?id=components:bulkloaders:informix_data_writer&rev=1253096837&do=diff This component loads data to Informix database using dbload or load2 utility. It is faster then DBOutputTable. Load formats data pages directly, while avoiding most of the overhead of individual row processing that inserts incur. There is created temporary file with dbload command depending on input parameters. Data are read from given input file or from the input port and loaded to database. If load2 utility is used then data transfer can be processed by stdin. When dbload utility is used dat… text/html 2009-09-16T12:27:17+02:00 http://wiki.clovergui.net/doku.php?id=components:bulkloaders:mssql_data_writer&rev=1253096837&do=diff This component loads data to MsSql database using the bcp utility. It is faster then DBOutputTable. Load formats data pages directly, while avoiding most of the overhead of individual row processing that inserts incur. There is created bcp command depending on input parameters. Data are read from given input file or from the input port and loaded to database. text/html 2009-09-16T12:27:17+02:00 http://wiki.clovergui.net/doku.php?id=components:bulkloaders:mysql_data_writer&rev=1253096837&do=diff This component loads data to mysql database using the mysql utility. It is faster then DBOutputTable. Load formats data pages directly, while avoiding most of the overhead of individual row processing that inserts incur. There is created mysql command (LOAD DATA INFILE) depending on input parameters. Data are read from given input file or from the input port and loaded to database. text/html 2009-09-18T14:51:25+02:00 http://wiki.clovergui.net/doku.php?id=components:bulkloaders:oracle_data_writer&rev=1253278285&do=diff OracleDataWriter This component loads data to oracle database using the sqlldr utility (SQL*Loader). It is faster then DBOutputTable. Load formats data pages directly, while avoiding most of the overhead of individual row processing that inserts incur. text/html 2009-09-16T12:27:17+02:00 http://wiki.clovergui.net/doku.php?id=components:bulkloaders:postgresql_data_writer&rev=1253096837&do=diff This component loads data to postgre database using the psql utility. It is faster then DBOutputTable. Load formats data pages directly, while avoiding most of the overhead of individual row processing that inserts incur. There is created psql command (\copy) depending on input parameters. Data are read from given input file or from the input port and loaded to database.