tMicrosoftMQInput Retrieves the first message in a given Microsoft message queue (only support String). tMicrosoftMQInput fetches messages one by one based on the ID sequence of these messages from the Microsoft message queue. Each execution retrieves only one message. For further information, see the section about messaging brokers supported by …. Continue Reading »

tNeo4jInput Reads data from Neo4j and sends data in the output Talend flow. tNeo4jInput reads data from Neo4j based on Cypher query allowing any further transformation or processing of the data in the rest of the Job. tNeo4jInput Standard properties These properties are used to configure tNeo4jInput running in the …. Continue Reading »

tFileInputDelimited properties for Apache Spark Streaming These properties are used to configure tFileInputDelimited running in the Spark Streaming Job framework. The Spark Streaming tFileInputDelimited component belongs to the File family. This component is available in Talend Real Time Big Data Platform and Talend Data Fabric. Basic settings Define a storage …. Continue Reading »

tAccessClose Closes an active connection to the Access database so as to release occupied resources. tAccessClose Standard properties These properties are used to configure tAccessClose running in the Standard Job framework. The Standard tAccessClose component belongs to the Databases family. The component in this framework is available in all Talend …. Continue Reading »

tPrejob Triggers a task required for the execution of a Job tPrejob starts the execution of a prejob. tPrejob Standard properties These properties are used to configure tPrejob running in the Standard Job framework. The Standard tPrejob component belongs to the Orchestration family. The component in this framework is available …. Continue Reading »

tS3Get Retrieves a file from Amazon S3. tS3Get Standard properties These properties are used to configure tS3Get running in the Standard Job framework. The Standard tS3Get component belongs to the Cloud family. The component in this framework is available in all Talend products. Basic settings Use existing connection Select this …. Continue Reading »

Configuring the encryption operation Double-click the tDataEncrypt component to open its basic settings. Click Sync columns to retrieve the schema from the previous component. In the Password field, enter the password to be used for encrypting the cryptographic file. In the Cryptographic file path, enter the path to the cryptographic …. Continue Reading »

tFTPRename Renames files in an FTP directory. tFTPRename Standard properties These properties are used to configure tFTPRename running in the Standard Job framework. The Standard tFTPRename component belongs to the Internet family. The component in this framework is available in all Talend products. Basic settings Property Type Select the way …. Continue Reading »

tGSList Retrieves a list of objects from Google Cloud Storage one by one. tGSList iterates on a list of objects which match the specified criteria in Google Cloud Storage. tGSList Standard properties These properties are used to configure tGSList running in the Standard Job framework. The Standard tGSList component belongs …. Continue Reading »

tBoundedStreamInput Provides a data stream for the component to be tested and is suitable for use in a test case only. tBoundedStreamInput loads data put in its Basic settings tab or from a given context variable in order to generates a data stream. tBoundedStreamInput is available only in a test …. Continue Reading »

tSAPDSOOutput Creates or updates DSO data in an SAP BW table. tSAPDSOOutput creates or updates DSO (Data Store Objects) data in an SAP BW table. tSAPDSOOutput Standard properties These properties are used to configure tSAPDSOOutput running in the Standard Job framework. The Standard tSAPDSOOutput component belongs to the Business family. …. Continue Reading »

tNetezzaInput Reads a database and extracts fields from a Netezza database based on a query. tNetezzaInput 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. tNetezzaInput Standard …. Continue Reading »

tJDBCSP Centralizes multiple or complex queries in a database in order to call them easily. tJDBCSP Standard properties These properties are used to configure tJDBCSP running in the Standard Job framework. The Standard tJDBCSP component belongs to the Databases family. The component in this framework is available in all Talend …. Continue Reading »

tAccessOutputBulk Prepares the file which contains the data used to feed the Access database. The tAccessOutputBulk and tAccessBulkExec components are generally used together to output data to a delimited file and then to perform various actions on the file in an Access database, in a two step process. These two …. Continue Reading »

tPredictCluster Predicts the cluster of an element. Based on the clustering model generated by a model training component such as a K-Means component, tPredictCluster predicts which cluster an element belongs to. tPredictCluster uses a given clustering model to analyse datasets incoming from its preceding component in order to group the …. Continue Reading »

tPostgresPlusConnection Opens a connection to the specified database that can then be reused in the subsequent subjob or subjobs. The tPostgresPlusConnection opens a connection to the database for a current transaction. tPostgresPlusConnection Standard properties These properties are used to configure tPostgresPlusConnection running in the Standard Job framework. The Standard tPostgresPlusConnection …. Continue Reading »

tAggregateRow Receives a flow and aggregates it based on one or more columns. For each output line, are provided the aggregation key and the relevant result of set operations (min, max, sum…). tAggregateRow helps to provide a set of metrics based on values or calculations. Depending on the Talend product …. Continue Reading »

tPubSubInput Connects to the Google Cloud PubSub service that transmits messages to the components that run transformations over these messages. tPubSubInput properties for Apache Spark Streaming These properties are used to configure tPubSubInput running in the Spark Streaming Job framework. The Spark Streaming tPubSubInput component belongs to the Messaging family. …. Continue Reading »

tFileExist Checks if a file exists or not. tFileExist Standard properties These properties are used to configure tFileExist running in the Standard Job framework. The Standard tFileExist component belongs to the File family. The component in this framework is available in all Talend products. Basic settings File name/Stream Path to …. Continue Reading »

tFTPFileExist Checks if a file or a directory exists on an FTP server. tFTPFileExist Standard properties These properties are used to configure tFTPFileExist running in the Standard Job framework. The Standard tFTPFileExist component belongs to the Internet family. The component in this framework is available in all Talend products. Basic …. Continue Reading »

Configuring the output component and executing the Job Double-click tLogRow to open its Basic settings view in the Component tab. Click Sync columns to retrieve the schema from the preceding component. Select Table (print values in cells of a table) in the Mode area. Press F6 to run the Job. …. Continue Reading »

tTeradataTPump Inserts, updates, or deletes data in the Teradata database with the TPump loading utility which allows near-real-time data to be achieved in the data warehouse. Use this component particularly for environments where batch windows are shrinking and warehouse maintenance overlaps normal working hours. tTeradataTPump Standard properties These properties are …. Continue Reading »

tGreenplumClose Closes a connection to the Greenplum database. tGreenplumClose Standard properties These properties are used to configure tGreenplumClose running in the Standard Job framework. The Standard tGreenplumClose component belongs to the Databases family. The component in this framework is available in all Talend products. Note: This component is a specific …. Continue Reading »