tSAPHanaConnection Establishes a SAP HANA connection to be reused by other SAP HANA components in your Job. tSAPHanaConnection opens a connection to the database for a current transaction. tSAPHanaConnection Standard properties These properties are used to configure tSAPHanaConnection running in the Standard Job framework. The Standard tSAPHanaConnection component belongs to …. Continue Reading »

tMSSqlInput Executes a DB query with a strictly defined order which must correspond to the schema definition. tMSSqlInput reads data and extracts fields based on a query from a Microsoft SQL Server database or a Microsoft Azure SQL database. Then it passes on the field list to the next component …. Continue Reading »

tOracleCommit Validates the data processed through the Job into the connected Oracle database Using a unique connection, this component commits in one go a global transaction instead of doing that on every row or every batch and thus provides gain in performance. tOracleCommit Standard properties These properties are used to …. Continue Reading »

tELTPostgresqlMap Builds the SQL SELECT statement using the table schema(s) provided by one or more tELTPostgresqlInput components. The three ELT Postgresql components are closely related, in terms of their operating conditions. These components should be used to handle Postgresql database table schemas to generate SQL statements, including clauses, which are …. Continue Reading »

tOracleOutput Writes, updates, makes changes or suppresses entries in an Oracle database. tOracleOutput 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. Depending on the Talend product you are using, this component …. Continue Reading »

tSalesforceEinsteinBulkExec Loads data into Salesforce Analytics Cloud from a local file. tSalesforceEinsteinBulkExec Standard properties These properties are used to configure tSalesforceEinsteinBulkExec running in the Standard Job framework. The Standard tSalesforceEinsteinBulkExec component belongs to the Business and the Cloud families. The component in this framework is available in all Talend products. …. Continue Reading »

tTop Sorts data and outputs several rows from the first one of this data. tTop sorts input records based on their schema columns and sends to its following component a given number of first rows of the sorted records. Depending on the Talend product you are using, this component can …. Continue Reading »

tMahoutClustering (deprecated) Groups unlabeled numerical data into clusters that can reveal interesting patterns or helps identifying abnormal data items in the data set. tMahoutClustering groups data together into clusters based on some similarities. The component offers several similarity methods that can be used in different clustering algorithms. tMahoutClustering uses clustering …. Continue Reading »

tSAPInfoObjectInput Retrieves InfoObject data from an SAP BW system. tSAPInfoObjectInput Standard properties These properties are used to configure tSAPInfoObjectInput running in the Standard Job framework. The Standard tSAPInfoObjectInput component belongs to the Business family. The component in this framework is available in all subscription-based Talend products. Basic settings Property Type …. Continue Reading »

tHMapInput Runs a Talend Data Mapper map where input and output structures may differ, as a Spark batch execution, and sends the data for use by a downstream component. tHMapInput transforms data from a single source, in a Spark environment, for use by a downstream component. tHMapInput properties for Apache …. Continue Reading »

tCollectAndCheck Shows and validates the result of a component test. tCollectAndCheck is available only in a test case about a given component and is added automatically to the test case you are using. For further information about test cases, see Talend Studio User Guide. tCollectAndCheck receives output from a component …. Continue Reading »

tEXAConnection Opens a connection to an EXASolution database instance that can then be reused by other EXASolution components. tEXAConnection Standard properties These properties are used to configure tEXAConnection running in the Standard Job framework. The Standard tEXAConnection component belongs to the Databases and the ELT families. The component in this …. Continue Reading »

tSCPGet Copies files from the defined SCP server. tSCPGet transfers defined files via an SCP connection over a fully encrypted channel. tSCPGet Standard properties These properties are used to configure tSCPGet running in the Standard Job framework. The Standard tSCPGet component belongs to the Internet family. The component in this …. Continue Reading »

tEXAInput Retrieves data from an EXASolution database based on a query with a strictly defined order which corresponds to the schema definition, and passes the data to the next component. tEXAInput Standard properties These properties are used to configure tEXAInput running in the Standard Job framework. The Standard tEXAInput component …. Continue Reading »

tCassandraInput Extracts the desired data from a standard or super column family of a Cassandra keyspace so as to apply changes to the data. tCassandraInput allows you to read data from a Cassandra keyspace and send data in the Talend flow. Depending on the Talend product you are using, this …. Continue Reading »

tPatternMasking Masks data that follows a specific pattern and can transform the original data in consistent manner, if needed. If you need to mask heterogeneous data, you can use the tDataMasking component. For more information, see the tDataMasking documentation on Talend Help Center (https://help.talend.com). tPatternMasking replaces pattern-specific and generic data …. Continue Reading »

tPersonator Ensures the quality of a US and Canadian contact database by checking, verifying, moving and appending contact data. This component is the result of Talend collaboration with Melissa Data, one of the world leaders for global address validation. For more information about Melissa Data and its software tools, visit …. Continue Reading »

tEXistDelete Deletes specified resources from a remote eXist database. tEXistDelete Standard properties These properties are used to configure tEXistDelete running in the Standard Job framework. The Standard tEXistDelete component belongs to the Databases family. The component in this framework is available in all Talend products. Basic settings Use an existing …. Continue Reading »

tMDMRouteRecord Helps Event Manager to identify the changes you have made on your data so that correlative actions can be triggered. tMDMRouteRecord submits the primary key of a record stored in your MDM Hub to Event Manager in order for Event Manager to trigger the due process(es) against some specific …. Continue Reading »

tRunJob Manages complex Job systems which need to execute one Job after another. tRunJob executes the Job called in the component’s properties, in the frame of the context defined. Depending on the Talend product you are using, this component can be used in one, some or all of the following …. Continue Reading »

tJDBCLookupInput Reads a database and extracts fields based on a query. It passes on the extracted data to tMap in order to provide the lookup data to the main flow. It must be directly connected to a tMap component and requires this tMap to use Reload at each row or …. Continue Reading »

Encrypting and decrypting back sensitive data This scenarios uses two Jobs. The first Job encrypts last names, postal codes and dates of births. The second Job decrypts back the encrypted sensitive data. Setting up the encryption Job Configuring the input component Configuring the encryption operation Protecting sensitive data with encryption …. Continue Reading »

tFileCompare Compares two files and provides comparison data based on a read-only schema. tFileCompare Standard properties These properties are used to configure tFileCompare running in the Standard Job framework. The Standard tFileCompare component belongs to the File family. The component in this framework is available in all Talend products. Basic …. Continue Reading »

tFileInputDelimited Standard properties These properties are used to configure tFileInputDelimited running in the Standard Job framework. The Standard tFileInputDelimited component belongs to the File family. The component in this framework is available in all Talend products. Basic settings Property type Either Built-In or Repository.   Built-In: No property data stored …. Continue Reading »

tOracleRow Executes the stated SQL query on the specified Oracle database. Depending on the nature of the query and the database, tOracleRow acts on the actual DB structure or on the data (although without handling data). The SQLBuilder tool helps you write easily your SQL statements. tOracleRow is the specific …. Continue Reading »