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 Viewing Debug Data. This dialog allows you to view the written data. It can only be used after graph has already been run.
option. You will be prompted with the same View data dialog as when debugging the edges. For more details, seeBelow is a brief overview of links to these options:
Below are examples of the File URL attribute for writing to local and remote files, through proxy, output port and dictionary:
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:
Table 56.1. Writers Comparison
Component | Data output | Input ports | Output ports | Transformation | Transf. required | Java | CTL | Auto-propagated metadata |
---|---|---|---|---|---|---|---|---|
CloverDataWriter | CloverDX binary file | 1 | 0-1 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
CustomJavaWriter | - | n | n | ✓ | ⨯ | ✓ | ⨯ | ⨯ |
DatabaseWriter | database | 1 | 0-2 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
DB2BulkWriter | database | 0-1 | 0-1 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
DBFDataWriter | .dbf file | 1 | 0 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
EmailSender | emails | 0-1 | 0-2 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
FlatFileWriter | flat file | 1 | 0-1 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
HadoopWriter | Hadoop sequence file | 1 | 0 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
InfobrightBulkWriter | database | 1 | 0-1 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
InformixBulkWriter | 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 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
KafkaWriter | Kafka cluster | 1 | 0-2 | ✓ | ⨯ | ⨯ | ✓ | ✓ |
LDAPWriter | LDAP directory tree | 1 | 0-1 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
MongoDBWriter | database | 1 | 0-2 | ✓ | ✓ | ⨯ | ✓ | ✓ |
MSSQLBulkWriter | database | 0-1 | 0-1 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
MySQLBulkWriter | database | 0-1 | 0-1 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
OracleBulkWriter | database | 0-1 | 0-1 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |
PostgreSQLBulkWriter | 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 | ⨯ | ⨯ | ⨯ | ⨯ | ⨯ |