Home | Table of Contents | Common Properties of Writers | CloverETL 4.6.1
--- | --- | ---
Prev | Writers | Next

## 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 of the records it receives, is counted into Writers 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. The Append 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:

- Some examples of the File URL attribute for writing to local and remote files, through proxy, output port and dictionary.

  Supported File URL Formats for Writers

- Viewing Data on Writers

- Output Port Writing

- Appending or Overwriting

- Creating Directories

- Excluding Fields

- Selecting Output Records

- Partitioning Output into Different Output Files

- As it has been shown in Defining Transformations, some Writers allow you to define a transformation. For information about transformation interfaces that must be implemented in transformations written in Java see:

  Java Interfaces for Writers

Table 49.1. Writers Comparison

Component | Data output | Input ports | Output ports | Transformation | Transf. required | Java | CTL | Auto-propagated metadata
--- | --- | --- | --- | --- | --- | --- | --- | ---
CloverDataWriter | Clover binary file | 1 | 0-1 |  |  |  |  |
CustomJavaWriter | - | n | n |  |  |  |  |
DBFDataWriter | .dbf file | 1 | 0 |  |  |  |  |
DBOutputTable | database | 1 | 0-2 |  |  |  |  |
DB2DataWriter | database | 0-1 | 0-1 |  |  |  |  |
EmailSender | e-mails | 0-1 | 0-2 |  |  |  |  |
FlatFileWriter | flat file | 1 | 0-1 |  |  |  |  |
HadoopWriter | Hadoop sequence file | 1 | 0 |  |  |  |  |
InfobrightDataWriter | database | 1 | 0-1 |  |  |  |  |
InformixDataWriter | database | 0-1 | 0-1 |  |  |  |  |
JavaBeanWriter | dictionary | 1-n | 0 |  |  |  |  |
JavaMapWriter | dictionary | 1-n | 0 |  |  |  |  |
JMSWriter | jms messages | 1 | 0 |  |  |  |  |
JSONWriter | JSON file | 1-n | 0-1 |  |  |  |  |
LDAPWriter | LDAP directory tree | 1 | 0-1 |  |  |  |  |
LotusWriter | Lotus Notes | 1 | 0-1 |  |  |  |  |
MongoDBWriter | database | 1 | 0-2 |  |  |  |  |
MSSQLDataWriter | database | 0-1 | 0-1 |  |  |  |  |
MySQLDataWriter | database | 0-1 | 0-1 |  |  |  |  |
OracleDataWriter | database | 0-1 | 0-1 |  |  |  |  |
PostgreSQLDataWriter | database | 0-1 | 0 |  |  |  |  |
QuickBaseRecordWriter | QuickBase | 1 | 0-1 |  |  |  |  |
QuickBaseImportCSV | QuickBase | 1 | 0-2 |  |  |  |  |
SalesforceBulkWriter | Salesforce | 1 | 2 |  |  |  |  |
SalesforceWriter | Salesforce | 1 | 2 |  |  |  |  |
SalesforceWaveWriter | Salesforce | 1 | 2 |  |  |  |  |
SpreadsheetDataWriter | XLS(X) file | 1 | 0-1 |  |  |  |  |
StructuredDataWriter | structured flat file | 1-3 | 0-1 |  |  |  |  |
TableauWriter | .tde file | 1 | 0 |  |  |  |  |
Trash | none | 1 | 0 |  |  |  |  |
UniversalDataWriter | flat file | 1 | 0-1 |  |  |  |  |
XMLWriter | XML file | 1-n | 0-1 |  |  |  |  |

Prev | Up | Next
Writers | Home | Table of Contents | Supported File URL Formats for Writers