tFlowToIterate – Docs for ESB 5.x
tFlowToIterate tFlowToIterate Properties Component family Orchestration Function tFlowToIterate iterates on the input data and generates global variables. Purpose This component is used to read data line by line from the input flow and store the data entries in iterative global variables. Basic settings Use the default (key, value) in global variables When selected, the…
tFirebirdClose – Docs for ESB 5.x
tFirebirdClose tFirebirdClose properties Component family Databases/Firebird Function tFirebirdClose closes the transaction committed in the connected DB. Purpose Close a transaction. Basic settings Component list Select the tFirebirdConnection component in the list if more than one connection are planned for the current Job. Advanced settings tStatCatcher Statistics Select this check box to collect log data…
tFindRegexlibExpressions – Docs for ESB 5.x
tFindRegexlibExpressions Warning This component will be available in the Palette of Talend Studio on the condition that you have subscribed to one of the Talend Platform products. tFindRegexlibExpressions Component family Data Quality Function tFindRegexlibExpressions connects to a web service at http://regexlib.com to get a list of regular expressions for all languages, even those that…
tFirstnameMatch – Docs for ESB 5.x
tFirstnameMatch Warning This component will be available in the Palette of Talend Studio on the condition that you have subscribed to one of the Talend Platform products. tFirstnameMatch properties Component family Data Quality Function tFirstnameMatch compares the first name column from the input flow with first names in an embedded reference index and outputs…
tFirebirdRow – Docs for ESB 5.x
tFirebirdRow tFirebirdRow properties Component family Databases/FireBird Function tFirebirdRow is the specific component for this database query. It executes the SQL query stated onto the specified database. The row suffix means the component implements a flow in the job design although it doesn’t provide output. Purpose Depending on the nature of the query and the…
tFirebirdOutput – Docs for ESB 5.x
tFirebirdOutput tFirebirdOutput properties Component family Databases/FireBird Function tFirebirdOutput writes, updates, makes changes or suppresses entries in a database. Purpose tFirebirdOutput executes the action defined on the table and/or on the data contained in the table, based on the flow incoming from the preceding component in the Job. Basic settings Property type Either Built-in or…
tFirebirdInput – Docs for ESB 5.x
tFirebirdInput tFirebirdInput properties Component family Databases/FireBird Function tFirebirdInput reads a database and extracts fields based on a query. Purpose tFirebirdInput executes a DB query with a strictly defined order which must correspond to the schema definition. Then it passes on the field list to the next component via a Main row link. Basic settings…
tFirebirdConnection – Docs for ESB 5.x
tFirebirdConnection tFirebirdConnection properties Component family Databases/Firebird Function tFirebirdConnection opens a connection to the database for a current transaction. Purpose This component is used to open a connection to the specified database that can then be reused in the subsequent subjob or subjobs. Basic settings Property type Either Built-in or Repository. Since version 5.6, both…
tFileOutputLDIF – Docs for ESB 5.x
tFileOutputLDIF tFileOutputLDIF Properties Component family File/Output Function tFileOutputLDIF outputs data to an LDIF type of file which can then be loaded into a LDAP directory. Purpose tFileOutputLDIF writes or modifies a LDIF file with data separated in respective entries based on the schema defined,.or else deletes content from an LDIF file. Basic settings File…
tFileOutputRaw – Docs for ESB 5.x
tFileOutputRaw tFileOutputRaw properties Component family File/Output Function tFileOutputRaw handles the output data in a Job that provides a single column of output data. Purpose This component takes data which is provided by another component in the form of a single column. Basic settings Schema and Edit Schema A schema is a row description, it…