We assume that you already know what components are. See Chapter 17, Components for brief information.
Only some of the components in a graph are terminal nodes. These are called Writers.
Writers can write data to output files (both local and remote), send it through the connected optional output port, or write it to dictionary. One component only discards data. Since it is also a terminal node, we describe it here.
Components can have different properties. But they also can have something in common. Some properties are common for all of them, others are common for most of the components, or they are common for Writers only. You should learn:
We can distinguish Writers according to what they can write:
One component discards data:
Trash discards data.
Other Writers write data to files.
Flat files:
UniversalDataWriter writes data to flat files (delimited or fixed length).
Other files:
CloverDataWriter writes data to files in Clover binary format.
XLSDataWriter writes data to XLS or XLSX files.
StructuredDataWriter writes data to files with user-defined structure.
XMLWriter creates XML files from input data records.
Other Writers loads data into database.
Databases Writers:
DBOutputTable loads data into database using JDBC driver.
QuickBaseRecordWriter writes data into the QuickBase online database.
QuickBaseImportCSV writes data into the QuickBase online database.
LotusWriter writes data into Lotus Notes and Lotus Domino databases.
High-Speed Database Specific Writers (Bulk Loaders):
DB2DataWriter loads data into DB2 database using DB2 client.
InfobrightDataWriter loads data into Infobright database using Infobright client.
InformixDataWriter loads data into Informix database using Informix client.
MSSQLDataWriter loads data into MSSQL database using MSSQL client.
MySQLDataWriter loads data into MYSQL database using MYSQL client.
OracleDataWriter loads data into Oracle database using Oracle client.
PostgreSQLDataWriter loads data into PostgreSQL database using PostgreSQL client.
Other Writers send e-mails, JMS messages or write directory structure.
E-mails:
EmailSender converts data records into e-mails.
JMS messages:
JMSWriter converts data records into JMS messages.
Directory structure:
LDAPWriter converts data records into a directory structure.