Common Properties of Writers

Writers are the final components of a transformation graph. They serve to write data to files located on disk or to send data using some FTP, LDAP or JMS connection, or insert data into database tables. Trash component, which discards all records it receives, is categorized as Writer as it can be set to store records in a debug file.

Each Writer must have at least one input port, through which the data flow to this graph component from some of the others.

Writers can either append data to an existing file, sheet or database table, or replace the existing content by new one. For this purpose, Writers writing to files have the Append attribute. This attribute is set to false, by default. That means "do not append data, replace it". Replacing database table is available in some bulkloaders, e.g. in DB2DataWriter.

You can also write data to one file or one database table by more Writers of the same graph; in such a case you should write data by different Writers in different phases.

Most Writers let you see some part of resulting data. Right-click the Writer and select the View data option. You will be prompted with the same View data dialog as when debugging the edges. For more details, see Viewing Debug Data. This dialog allows you to view the written data. It can only be used after graph has already been run.

Below is a brief overview of links to these options:

Table 56.1. Writers Comparison

ComponentData outputInput portsOutput portsTransformationTransf. requiredJavaCTLAuto-propagated metadata
CloverDataWriterClover binary file10-1
no
no
no
no
no
CustomJavaWriter-nn
yes
no
yes
no
no
DBFDataWriter.dbf file10
no
no
no
no
no
DBOutputTabledatabase10-2
no
no
no
no
no
DB2DataWriterdatabase0-10-1
no
no
no
no
no
EmailSenderemails0-10-2
no
no
no
no
no
FlatFileWriterflat file10-1
no
no
no
no
no
HadoopWriterHadoop sequence file10
no
no
no
no
no
InfobrightDataWriterdatabase10-1
no
no
no
no
no
InformixDataWriterdatabase0-10-1
no
no
no
no
no
JavaBeanWriterdictionary1-n0
no
no
no
no
no
JavaMapWriterdictionary1-n0
no
no
no
no
no
JMSWriterjms messages10
yes
no
yes
no
no
JSONWriterJSON file1-n0-1
no
no
no
no
no
LDAPWriterLDAP directory tree10-1
no
no
no
no
no
LotusWriterLotus Notes10-1
no
no
no
no
no
MongoDBWriterdatabase10-2
yes
yes
no
yes
yes
MSSQLDataWriterdatabase0-10-1
no
no
no
no
no
MySQLDataWriterdatabase0-10-1
no
no
no
no
no
OracleDataWriterdatabase0-10-1
no
no
no
no
no
PostgreSQLDataWriterdatabase0-10
no
no
no
no
no
QuickBaseRecordWriterQuickBase10-1
no
no
no
no
no
QuickBaseImportCSVQuickBase10-2
no
no
no
no
no
SalesforceBulkWriterSalesforce12
yes
no
no
yes
yes
SalesforceWriterSalesforce12
yes
no
no
yes
yes
SalesforceWaveWriterSalesforce12
no
no
no
no
no
SpreadsheetDataWriterXLS(X) file10-1
no
no
no
no
no
StructuredDataWriterstructured flat file1-30-1
no
no
no
no
no
TableauWriter.tde file10
no
no
no
no
no
Trashnone10
no
no
no
no
no
UniversalDataWriterflat file10-1
no
no
no
no
no
XMLWriterXML file1-n0-1
no
no
no
no
no