tEXAOutput – Docs for ESB 5.x
tEXAOutput tEXAOutput properties Component family Databases/EXA Function tEXAOutput writes, updates, modifies or deletes data from databases. Purpose tEXAOutput executes the action defined on the table and/or on the table data, depending on the function of the input flow, from the preceding component. Basic settings Property type Either Built-in or Repository. Since version 5.6, both…
tExtractJSONFields – Docs for ESB 5.x
tExtractJSONFields tExtractJSONFields properties Component family Processing/Fields Function tExtractJSONFields extracts the desired data from incoming JSON fields based on the XPath or JSONPath query. Purpose tExtractJSONFields extracts the data from JSON fields stored in a file, a database table, etc., based on the XPath or JSONPath query. Basic settings Property type Either Built-in or Repository….
tExternalSortRow – Docs for ESB 5.x
tExternalSortRow tExternalSortRow properties Component family Processing Function Uses an external sort application to sort input data based on one or several columns, by sort type and order Purpose Helps create metrics and classification table. Basic settings Schema and Edit Schema A schema is a row description, it defines the number of fields to be…
tEXistConnection – Docs for ESB 5.x
tEXistConnection tEXistConnection properties Component family Databases/eXist Function tEXistConnection opens a connection to an eXist database in order that a transaction may be carried out. Purpose Opens a connection to an eXist database in order that a transaction may be carried out. Basic settings URI URI of the database you want to connect to. …
tExtractEDIField – Docs for ESB 5.x
tExtractEDIField tExtractEDIField properties Component family Processing / EDIFACT Function tExtractEDIField reads an input United Nations/Electronic Data Interchange For Administration, Commerce and Transport (UN/EDIFACT) message file, generates an XML according to the EDIFACT family and the EDIFACT type, and extracts data by parsing the generated XML using the XPath queries manually defined or coming from…
tExtractEBCDICFields – Docs for ESB 5.x
tExtractEBCDICFields tExtractEBCDICFields properties Component family Processing/Fields Note that this component is deprecated. The EBCDIC handling capabilities are now fully supported by Talend Data Mapper that comes with any Talend Platform solutions. For more information about Talend Data Mapper, see Talend Data Mapper User Guide. Function tExtractEBCDICFields generates multiple columns from a given column according to…
tExtractDelimitedFields – Docs for ESB 5.x
tExtractDelimitedFields tExtractDelimitedFields properties Component family Processing/Fields Function tExtractDelimitedFields generates multiple columns from a given column in a delimited file. 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 tExtractDelimitedFields in…
tEXistPut – Docs for ESB 5.x
tEXistPut tEXistPut properties Component family Databases/eXist Function This component uploads resources to a DB server. Purpose tEXistPut uploads specified files from a defined local directory to a remote DB server. Basic settings Use an existing connection/Component List Select this check box and in the Component List click the relevant connection component to reuse the…
tEXistDelete – Docs for ESB 5.x
tEXistDelete tEXistDelete properties Component family Databases/eXist Function This component deletes resources from an eXist database. Purpose tEXistDelete deletes specified resources from remote eXist databases. Basic settings Use an existing connection/Component List Select this check box and in the Component List click the relevant connection component to reuse the connection details you already defined. Note…
tExtractXMLField – Docs for ESB 5.x
tExtractXMLField tExtractXMLField properties Component family XML Function tExtractXMLField reads an input XML field of a file or a database table and extracts desired data. Purpose tExtractXMLField opens an input XML field, reads the XML structured data directly without having first to write it out to a temporary file, and finally sends data as defined…