Version

    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 flows 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 DB2BulkWriter.

    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
    CloverDataWriterCloverDX binary file10-1
    CustomJavaWriter-nn
    DatabaseWriterdatabase10-2
    DB2BulkWriterdatabase0-10-1
    DBFDataWriter.dbf file10
    EmailSenderemails0-10-2
    FlatFileWriterflat file10-1
    HadoopWriterHadoop sequence file10
    InfobrightBulkWriterdatabase10-1
    InformixBulkWriterdatabase0-10-1
    JavaBeanWriterdictionary1-n0
    JavaMapWriterdictionary1-n0
    JMSWriterjms messages10
    JSONWriterJSON file1-n0-1
    KafkaWriterKafka cluster10-2
    LDAPWriterLDAP directory tree10-1
    MongoDBWriterdatabase10-2
    MSSQLBulkWriterdatabase0-10-1
    MySQLBulkWriterdatabase0-10-1
    OracleBulkWriterdatabase0-10-1
    PostgreSQLBulkWriterdatabase0-10
    QuickBaseRecordWriterQuickBase10-1
    QuickBaseImportCSVQuickBase10-2
    SalesforceBulkWriterSalesforce12
    SalesforceWriterSalesforce12
    SalesforceWaveWriterSalesforce12
    SpreadsheetDataWriterXLS(X) file10-1
    StructuredDataWriterstructured flat file1-30-1
    TableauWriter.tde file10
    Trashnone10
    UniversalDataWriterflat file10-1
    XMLWriterXML file1-n0-1