tSparkSort – Docs for ESB 5.x
tSparkSort 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. tSparkSort properties Component family Big Data / Spark Function tSparkSort sorts the input datasets based on the selected columns. Purpose tSparkSort puts in order the…
tSQLiteRollback – Docs for ESB 5.x
tSQLiteRollback tSQLiteRollback properties Component family Databases/SQLite Function tSQLiteRollback cancels the transaction committed in the connected DB. Purpose Avoids to commit part of a transaction involuntarily. Basic settings Component list Select the tSQLiteConnection component in the list if more than one connection are planned for the current Job. Close Connection Clear this check box…
tSparkReplicate – Docs for ESB 5.x
tSparkReplicate 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. tSparkReplicate properties Component family Big Data / Spark Function tSparkReplicate duplicates an incoming schema into two identical output flow. Purpose tSparkReplicate allows you to perform…
tSPSSStructure – Docs for ESB 5.x
tSPSSStructure tSPSSStructure properties Component family Business Intelligence Function tSPSSStructure retrieves information about the variables inside .sav files. Purpose tSPSSStructure addresses variables inside .sav files. You can use this component in combination with tFileList to gather information about existing *.sav files to further analyze or check the findings. Basic settings Schema and Edit Schema A…
tSQLiteRow – Docs for ESB 5.x
tSQLiteRow tSQLiteRow Properties Component family Databases Function tSQLiteRow executes the defined query onto the specified database and uses the parameters bound with the column. Purpose A prepared statement uses the input flow to replace the placeholders with the values for each parameters defined. This component can be very useful for updates. Basic settings Property…
tSQLiteClose – Docs for ESB 5.x
tSQLiteClose tSQLiteClose properties Component family Databases/SQLite Function tSQLiteClose closes the transaction committed in the connected DB. Purpose Close a transaction. Basic settings Component list Select the tSQLiteConnection 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…
tSOAP – Docs for ESB 5.x
tSOAP tSOAP properties Component family Internet Function tSOAP sends the defined SOAP message with the given parameters to the invoked Web service and returns the value as defined, based on the given parameters. Purpose This component calls a method via a Web service in order to retrieve the values of the parameters defined in…
tSPSSProperties – Docs for ESB 5.x
tSPSSProperties tSPSSProperties properties Component family Business Intelligence Function tSPSSProperties describes the properties of a defined SPSS .sav file. Purpose tSPSSProperties allows you to obtain information about the main properties of a defined SPSS .sav file. Basic settings Schema and Edit Schema A schema is a row description. It defines the number of fields to…
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…