Common Properties of Readers

Overview of Readers

Table 53.1. Readers Comparison

Component Data source Input ports Output ports Each to all outputs [1] Different to different outputs [2] Transformation Transf. req. Java CTL Auto-propagated metadata
CloverDataReaderclover binary file01-n
yes
no
no
no
no
no
no
ComplexDataReaderflat file11-n
no
yes
yes
yes
yes
yes
no
DataGeneratornone01-n
no
yes
yes
yes
yes
yes
no
DBFDataReaderdBase file0-11-n
yes
no
no
no
no
no
no
DBInputTabledatabase01-n
yes
no
no
no
no
no
no
EmailReaderemail messages01--
yes
no
yes
no
no
FlatFileReaderflat file0-11-2
no
no
no
no
no
no
no
HadoopReaderHadoop sequence file01
no
no
no
no
no
no
no
JavaBeanReaderdictionary01-n
no
yes
no
no
no
no
 
JMSReaderjms messages01--
yes
no
yes
no
no
JSONExtractJSON file0-11-n
no
yes
no
no
no
no
no
JSONReaderJSON file0-11-n
no
yes
no
no
no
no
no
LDAPReaderLDAP directory tree01-n
no
no
no
no
no
no
no
LotusReaderLotus Notes01
no
no
no
no
no
no
no
MongoDBReaderdatabase0-11-2
no
no
yes
yes
no
yes
yes
MultiLevelReaderflat file11-n
no
yes
yes
yes
yes
no
no
ParallelReaderflat file01
no
no
no
no
no
no
yes
QuickBaseRecordReaderQuickBase0-11-2
no
no
no
no
no
no
no
QuickBaseQueryReaderQuickBase01
no
no
no
no
no
no
no
SalesforceBulkReaderSalesforce01
no
no
yes
no
no
yes
no
SalesforceReaderSalesforce01
no
no
yes
no
no
yes
no
SpreadsheetDataReaderXLS(X) file0-11-2
no
no
no
no
no
no
no
UniversalDataReaderflat file0-11-2
no
no
no
no
no
no
no
XMLExtractXML file0-11-n
no
yes
no
no
no
no
no
XMLReaderXML file0-11-n
no
yes
no
no
no
no
no
XMLXPathReaderXML file0-11-n
no
yes
no
no
no
no
no

[1] Component sends each data record to all of the connected output ports.

[2] Component sends different data records to different output ports using return values of the transformation (DataGenerator and MultiLevelReader). See Return Values of Transformations for more information. XMLExtract, XMLReader and XMLXPathReader send data to ports as defined in their Mapping or Mapping URL attribute.