36. Writers
| If you’re interested in learning more about this subject, we offer the Advanced Tips for Using Writer Components course in our CloverDX Academy. |
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 email, 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 a CloverDX binary format.
-
StructuredDataWriter writes data to files with a 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).
-
ParquetWriter writes data into Apache Parquet files.
-
EDIFACTWriter writes data into EDIFACT files.
-
X12Writer writes data into X12 files.
-
Writing to Database
-
Database Writers:
-
DatabaseWriter loads data into database using JDBC driver.
-
QuickBaseRecordWriter writes data into the a QuickBase online database.
-
QuickBaseImportCSV writes data into a QuickBase online database.
-
MongoDBWriter writes data into a MongoDB NoSQL database.
-
SalesforceWriter writes data into the Salesforce cloud platform.
-
SalesforceEinsteinWriter writes data into the Salesforce Einstein (formerly called Salesforce Wave) cloud platform.
-
-
High-Speed Database Specific Writers (Bulk Loaders):
-
DB2BulkWriter loads data into a DB2 database using DB2 client.
-
InformixBulkWriter loads data into an Informix database using the Informix client.
-
MSSQLBulkWriter loads data into an MSSQL database using the MSSQL client.
-
MySQLBulkWriter loads data into an MYSQL database using the MYSQL client.
-
OracleBulkWriter loads data into an Oracle database using the Oracle client.
-
PostgreSQLBulkWriter loads data into a PostgreSQL database using the PostgreSQL client.
-
SalesforceBulkWriter writes data into the Salesforce cloud platform.
-
SnowflakeBulkWriter loads data into Snowflake data warehouse using a Snowflake JDBC connection.
-
Other Writers
-
Emails:
-
EmailSender converts data records into emails.
-
-
JMS messages:
-
JMSWriter converts data records into JMS messages.
-
-
Directory structure:
-
LDAPWriter converts data records into a directory structure.
-
-
Kafka events:
-
KafkaWriter writes events (messages) to a Kafka cluster.
-
-
One component discards data:
-
Trash discards data or writes data to a debug file.
-