Writers can write data to local and remote output files, send it through the connected optional output port, write it to a dictionary, send using JMS connection, insert into database table, send by e-mail, insert into LDAP database or write only for debugging purposes.
We can distinguish Writers according to their output data format.
Flat files:
FlatFileWriter (UniversalDataWriter) writes data to flat files (character-delimited or fixed length).
Other files:
CloverDataWriter writes data to files in Clover binary format.
StructuredDataWriter writes data to files with user-defined structure.
TableauWriter writes data to Tableau files.
XMLWriter creates XML files from input data records.
DBFDataWriter writes data to dbase file(s).
HadoopWriter writes data into Hadoop sequence file(s).
Database 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.
MongoDBWriter writes data into the MongoDB NoSQL database.
SalesforceWriter writes data into the Salesforce cloud platform.
SalesforceBulkWriter writes data into the Salesforce cloud platform.
SalesforceWaveWriter writes data into the Salesforce Wave cloud platform.
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.
One component discards data:
Trash discards data or writes data to a debug file.
| Common Properties of Components |
| Specific Attribute Types |
| Common Properties of Writers |