tStatCatcher – Docs for ESB 5.x
tStatCatcher tStatCatcher Properties Component family Logs & Errors Function Based on the pre-defined schema, tStatCatcher gathers the Job processing metadata at the Job level and at the component level when the tStatCatcher Statistics check box is selected. Purpose Gathers the Job processing metadata at the Job level and at the component level when the…
tSugarCRMInput – Docs for ESB 5.x
tSugarCRMInput tSugarCRMInput Properties Component family Business/Cloud Function Connects to a Sugar CRM database module via the relevant webservice. Purpose Allows you to extract data from a SugarCRM DB based on a query. Basic settings SugarCRM Webservice URL Type in the webservice URL to connect to the SugarCRM DB. Username and Password Type in…
tSplitRow – Docs for ESB 5.x
tSplitRow tSplitRow properties Component family Processing/Fields Function tSplitRow splits one row into several rows. Purpose This component helps splitting one input row into several output rows. Basic settings Schema and Edit Schema A schema is a row description, it defines the number of fields to be processed and passed on to the next component….
tSPSSInput – Docs for ESB 5.x
tSPSSInput tSPSSInput properties Component family Business Intelligence Function tSPSSInput reads data from an SPSS .sav file. Purpose tSPSSInput addresses SPSS .sav data to write it for example in another file. Basic settings Sync schema Click this button to synchronize with the columns of the input SPSS .sav file. Schema and Edit Schema A…
tSparkStore – Docs for ESB 5.x
tSparkStore Warning This component will be available in the Palette of Talend Studio on the condition that you have subscribed to one of the Talend solutions with Big Data. tSparkStore properties Component family Big Data / Spark Function tSparkStore uses the Spark connection created by a given tSparkConnection component and writes the datasets it…
tSqoopMerge – Docs for ESB 5.x
tSqoopMerge Warning This component will be available in the Palette of Talend Studio on the condition that you have subscribed to one of the Talend solutions with Big Data. tSqoopMerge Properties Component family Big Data / Sqoop Function tSqoopMerge reads two datasets in HDFS and combines them both using a merge class that is…
tSybaseConnection – Docs for ESB 5.x
tSybaseConnection tSybaseConnection Properties Component family Databases/Sybase Function tSybaseConnection 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…
tSybaseOutputBulk – Docs for ESB 5.x
tSybaseOutputBulk tSybaseOutputBulk properties The tSybaseOutputBulk and tSybaseBulkExec components are generally used together as parts of a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT operation used to feed a database. These two steps are fused together in the tSybaseOutputBulkExec component,…
tSybaseRollback – Docs for ESB 5.x
tSybaseRollback tSybaseRollback properties Component family Databases/Sybase Function tSybaseRollback cancels the transaction committed in the connected DB. Purpose This component avoids to commit part of a transaction involuntarily. Basic settings Component list Select the tSybaseConnection component in the list if more than one connection are planned for the current job. Close Connection Clear this…
tSugarCRMOutput – Docs for ESB 5.x
tSugarCRMOutput tSugarCRMOutput Properties Component family Business/Cloud Function Writes in a Sugar CRM database module via the relevant webservice. Purpose Allows you to write data into a SugarCRM DB. Basic settings SugarCRM WebService URL Type in the webservice URL to connect to the SugarCRM DB. Username and Password Type in the Webservice user authentication…