tFileInputXML – Docs for ESB 5.x
tFileInputXML tFileInputXML Properties Component family XML or File/Input Function tFileInputXML reads an XML structured file and extracts data row by row. If you have subscribed to one of the Talend solutions with Big Data, you are able to use this component in a Talend Map/Reduce Job to generate Map/Reduce code. For further information, see…
tFileInputProperties – Docs for ESB 5.x
tFileInputProperties tFileInputProperties properties Component family File/Input Function tFileInputProperties reads a text file row by row and extracts the fields. Purpose tFileInputProperties opens a text file and reads it row by row then separates the fields according to the model key = value. Basic settings Schema and Edit Schema A schema is a row description,…
tFileRowCount – Docs for ESB 5.x
tFileRowCount tFileRowCount properties Component Family File/Management Function tFileRowCount counts the number of rows in a file. Purpose tFileRowCount opens a file and reads it row by row in order to determine the number of rows inside. Basic settings File Name Name or path to the file to be processed and/or the variable to be…
tFileProperties – Docs for ESB 5.x
tFileProperties tFileProperties Properties Component family File/Management Function tFileProperties creates a single row flow that displays the properties of the processed file. Purpose tFileProperties obtains information about the main properties of a defined file. Basic settings Schema and Edit schema A schema is a row description, it defines the fields to be processed and passed…
tFlowMeter – Docs for ESB 5.x
tFlowMeter tFlowMeter Properties Component family Logs & Errors Function Counts the number of rows processed in the defined flow. Purpose The number of rows is then meant to be caught by the tFlowMeterCatcher for logging purpose. Basic settings Use input connection name as label Select this check box to reuse the name given to…
tFileInputRegex – Docs for ESB 5.x
tFileInputRegex tFileInputRegex properties Component family File/Input Function Powerful feature which can replace number of other components of the File family. Requires some advanced knowledge on regular expression syntax Purpose Opens a file and reads it row by row to split them up into fields using regular expressions. Then sends fields as defined in the…
tFilterColumns – Docs for ESB 5.x
tFilterColumns tFilterColumns Properties Component family Processing Function Makes specified changes to the schema defined, based on column name mapping. Purpose Helps homogenize schemas either on the columns order or by removing unwanted columns or adding new columns. Basic settings Schema and Edit Schema A schema is a row description, it defines the number of…
tFileUnarchive – Docs for ESB 5.x
tFileUnarchive tFileUnarchive Properties Component family File/Management Function Decompresses the archive file provided as parameter and puts it in the extraction directory. Purpose Decompresses an archive file for further processing. Such formats are supported: *.tar.gz , *.tgz, *.tar, *.gz and *.zip. Basic settings Archive file File path to the archive. Extraction Directory Folder where…
tFirebirdRollback – Docs for ESB 5.x
tFirebirdRollback tFirebirdRollback properties Component family Databases/Firebird Function tFirebirdRollback cancels the transaction committed in the connected database. Purpose This component avoids to commit part of a transaction involuntarily.. Basic settings Component list Select the tFirebirdConnection component in the list if more than one connection are planned for the current Job. Close Connection Clear this…
tFirebirdCommit – Docs for ESB 5.x
tFirebirdCommit tFirebirdCommit Properties Component family Databases/Firebird Function Validates the data processed through the Job into the connected DB. Purpose Using a unique connection, this component commits in one go a global transaction instead of doing that on every row or every batch and thus provides gain in performance. Note that if you need to…