Home | Table of Contents | Writers | CloverETL 4.6.1
--- | --- | ---
Prev | Component Reference | Next

# Chapter 49. Writers

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.

#### Writers Overview

We can distinguish Writers according to their output data format.

##### Writing to File

- 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).

##### Writing to Database

- 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

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.

##### See also

Common Properties of Components
Specific Attribute Types
Common Properties of Writers

Prev | Up | Next
XMLXPathReader | Home | Table of Contents | Common Properties of Writers