tOracleConfiguration Stores connection information and credentials to be reused by other Oracle components. You configure the connection to a Oracle database in tOracleConfiguration and configure the other Oracle components to reuse this configuration. At runtime, the Spark executors read this configuration in order to connect to Oracle. Depending on the …. Continue Reading »

tGradientBoostedTreeModel Analyzes feature vectors usually prepared and provided by tModelEncoder to generate a classifier model that is used by tPredict to classify given elements. tGradientBoostedTreeModel analyzes incoming datasets using the Decision Tree algorithm. It generates a binary classification model out of this analysis and writes this model either in memory …. Continue Reading »

tImpalaConnection Establishes an Impala connection to be reused by other Impala components in your Job. tImpalaConnection opens a connection to an Impala database. tImpalaConnection Standard properties These properties are used to configure tImpalaConnection running in the Standard Job framework. The Standard tImpalaConnection component belongs to the Big Data family. The …. Continue Reading »

tSybaseSP Calls a Sybase database stored procedure. tSybaseSP Standard properties These properties are used to configure tSybaseSP running in the Standard Job framework. The Standard tSybaseSP component belongs to the Databases family. The component in this framework is available in all Talend products. Note: This component is a specific version …. Continue Reading »

tMysqlLastInsertId Obtains the primary key value of the record that was last inserted in a Mysql table by a user. tMysqlLastInsertId fetches the last inserted ID from a selected MySQL Connection. tMysqlLastInsertId Standard properties These properties are used to configure tMysqlLastInsertId running in the Standard Job framework. The Standard tMysqlLastInsertId …. Continue Reading »

tWarn Triggers a warning often caught by the tLogCatcher component for exhaustive log. Both tDie and tWarn components are closely related to the tLogCatcher component. They generally make sense when used alongside a tLogCatcher in order for the log data collected to be encapsulated and passed on to the output …. Continue Reading »

tJDBCInput MapReduce properties (deprecated) These properties are used to configure tJDBCInput running in the MapReduce Job framework. The MapReduce tJDBCInput component belongs to the MapReduce family. The component in this framework is available in all subscription-based Talend products with Big Data and Talend Data Fabric. The MapReduce framework is deprecated …. Continue Reading »

tParAccelSCD Addresses Slowly Changing Dimension needs, reading regularly a source of data and logging the changes into a dedicated SCD table The tParAccelSCD reflects and tracks changes in a dedicated ParAccel SCD table. tParAccelSCD Standard properties These properties are used to configure tParAccelSCD running in the Standard Job framework. The …. Continue Reading »

tMemSQLRow (deprecated) Acts on the actual database structure or on the data (although without handling data). tMemSQLRow executes the MemSQL query stated in the specified database, depending on the nature of the query and the database. The row suffix means the component implements a flow in the job design although …. Continue Reading »

tEXABulkExec Imports data into an EXASolution database table using the IMPORT command provided by the EXASolution database in a fast way. The import will be cancelled after a configurable number of records fail to import. Erroneous records can be sent to a log table in the same database or to …. Continue Reading »

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

Tokenizing Japanese text This scenario applies only to Talend Data Management Platform, Talend Big Data Platform, Talend Real Time Big Data Platform, Talend Data Services Platform, Talend MDM Platform and Talend Data Fabric. Using the tJapaneseTokenize component, you can split Japanese text into tokens. To replicate the example described below, …. Continue Reading »

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

tDataEncrypt Standard properties These properties are used to configure tDataEncrypt running in the Standard Job framework. The Standard tDataEncrypt component belongs to the Data Quality family. The component in this framework is available in Talend Data Management Platform, Talend Big Data Platform, Talend Real Time Big Data Platform, Talend Data …. Continue Reading »

tPatternUnmasking Standard properties These properties are used to configure tPatternUnmasking running in the Standard Job framework. The Standard tPatternUnmasking component belongs to the Data Quality family. Basic settings Schema and Edit Schema A schema is a row description. It defines the number of fields (columns) to be processed and passed …. Continue Reading »

tAvroStreamInput Listens on a given directory, reads data from Avro files once they are created and sends this data to the component that follows. tAvroStreamInput properties for Apache Spark Streaming These properties are used to configure tAvroStreamInput running in the Spark Streaming Job framework. The Spark Streaming tAvroStreamInput component belongs …. Continue Reading »

tDBInvalidRows Checks database rows against specific Data Quality patterns (regular expression) or Data Quality rules (business rule). This component works with a variety of databases depending on your selection. tDBInvalidRows Standard properties These properties are used to configure tDBInvalidRows running in the Standard Job framework. The Standard tDBInvalidRows component belongs …. Continue Reading »

tInformixClose Closes connection to Informix databases. tInformixClose closes an active connection to a database. tInformixClose Standard properties These properties are used to configure tInformixClose running in the Standard Job framework. The Standard tInformixClose component belongs to the Databases family. The component in this framework is available in all Talend products. …. Continue Reading »

tCacheOut Persists the input RDDs depending on the specific storage level you define in order to offer faster access to these datasets later. tCacheOut writes RDDs (Resilient Distributed Datasets) to the cache for later use in the same Job. Depending on the Talend product you are using, this component can …. Continue Reading »

tEXistPut Uploads specified files from a defined local directory to a remote eXist database. tEXistPut Standard properties These properties are used to configure tEXistPut running in the Standard Job framework. The Standard tEXistPut component belongs to the Databases family. The component in this framework is available in all Talend products. …. Continue Reading »

tELTVerticaOutput Performs the action (insert, update or delete) on data in the specified Vertica table through the SQL statement generated by the tELTVerticaMap component. The three ELT Vertica components are closely related, in terms of their operating conditions. These components should be used to handle Vertica database table schemas to …. Continue Reading »

tPostgresPlusOutputBulkExec Improves performance during Insert operations to a PostgresPlus database. The tPostgresPlusOutputBulkExec executes the Insert action on the data provided. The tPostgresplusOutputBulk and tPostgresplusBulkExec components are generally used together as part of a two step process. In the first step, an output file is generated. In the second step, this …. Continue Reading »

tDie Triggers the tLogCatcher component for exhaustive log before killing the Job. Both tDie and tWarn components are closely related to the tLogCatcher component.They generally make sense when used alongside a tLogCatcher in order for the log data collected to be encapsulated and passed on to the output defined. This …. Continue Reading »

Configuring the unmasking operations Configure one unmasking operation for each part of the input phone numbers. Separators will be left unchanged in the unmasked values. In the Modifications table, the settings must be the same as the ones used for the masking operations performed by the tPatternMasking component. The masked …. Continue Reading »

tVerticaRow Executes a Vertica SQL statement against a database table. tVerticaRow Standard properties These properties are used to configure tVerticaRow running in the Standard Job framework. The Standard tVerticaRow component belongs to the Databases family. The component in this framework is available in all Talend products. Note: This component is …. Continue Reading »