tJobLog Collects and shows exception data during the execution of the Job in Talend Studio or the task in Talend Cloud Management Console. This component is used in Jobs to debug their execution and decide what type of log information to send to the Studio or Talend Cloud user. To …. Continue Reading »

tGoogleDataprocManage Creates or deletes a Dataproc cluster in the Global region on Google Cloud Platform. tGoogleDataprocManage Standard properties These properties are used to configure tGoogleDataprocManage running in the Standard Job framework. The Standard tGoogleDataprocManage component belongs to the Cloud family. The component in this framework is available in all Talend …. Continue Reading »

tDataUnmasking properties for Apache Spark Batch These properties are used to configure tDataUnmasking running in the Spark Batch Job framework. The Spark Batch tDataUnmasking 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) …. Continue Reading »

tHashInput Reads from the cache memory data loaded by tHashOutput to offer high-speed data feed, facilitating transactions involving a large amount of data. The components of the Technical family are normally hidden from the Palette by default. For more information about how to show them on the Palette, see Talend …. Continue Reading »

tMomOutput Adds a message to a Message-Oriented Middleware system queue in order for it to be fetched asynchronously. tMomOutput makes it possible to set up asynchronous communications via a MOM server. For further information, see the section about messaging brokers supported by Talend messaging components in Talend Data Fabric Studio …. Continue Reading »

tMysqlColumnList Iterates on all columns of a given Mysql table and lists column names. tMysqlColumnList Standard properties These properties are used to configure tMysqlColumnList running in the Standard Job framework. The Standard tMysqlColumnList component belongs to the Databases family. The component in this framework is available in all Talend products. …. Continue Reading »

tParAccelClose Closes a transaction. The tParAccelClose closes the transaction committed in the connected DB. tParAccelClose Standard properties These properties are used to configure tParAccelClose running in the Standard Job framework. The Standard tParAccelClose component belongs to the Databases family. The component in this framework is available in all Talend products. …. Continue Reading »

tELTMysqlOutput tELTMysqlOutput executes the SQL Insert, Update and Delete statement to the Mysql database The three ELT Mysql components are closely related, in terms of their operating conditions. These components should be used to handle Mysql DB schemas to generate Insert statements, including clauses, which are to be executed in …. Continue Reading »

tRiakKeyList Retrieves a list of keys and iterates on it within a Riak bucket for analysis or development purposes. tRiakKeyList Standard properties These properties are used to configure tRiakKeyList running in the Standard Job framework. The Standard tRiakKeyList component belongs to the Big Data and the Databases NoSQL families. The …. Continue Reading »

tPostgresqlOutputBulk Prepares the file to be used as parameters in the INSERT query to feed the Postgresql database. The tPostgresqlOutputBulk writes a file with columns based on the defined delimiter and the Postgresql standards. The tPostgresqlOutputBulk and tPostgresqlBulkExec components are generally used together as part of a two step process. …. Continue Reading »

tGenKey Generates a functional key from the input columns, by applying different types of algorithms on each column and grouping the computed results in one key, then outputs this key with the input columns. tGenKey enables you to apply several kinds of algorithms on each input column and use the …. Continue Reading »

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

tFirstnameMatch Matches first names against a reference index in order to standardize data. Warning: This component is available in 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. tFirstnameMatch compares the first name column …. Continue Reading »

tELTPostgresqlInput Provides the Postgresql table schema that will be used by the tELTPostgresqlMap component to generate the SQL SELECT statement. 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 …. Continue Reading »

tSetGlobalVar Facilitates the process of defining global variables. tSetGlobalVar allows you to define and set global variables in GUI. tSetGlobalVar Standard properties These properties are used to configure tSetGlobalVar running in the Standard Job framework. The Standard tSetGlobalVar component belongs to the Custom Code family. The component in this framework …. Continue Reading »

tHiveCreateTable Creates Hive tables that fit a wide range of Hive data formats. A proper Hive data format such as RC or ORC allows you to obtain a better performance in processing data with Hive. tHiveCreateTable connects to the Hive database to be used and creates a Hive table that …. Continue Reading »

tGlobalVarLoad Sets variables using the incoming data so that the data can be dynamically reused by other subJobs. tGlobalVarLoad MapReduce properties (deprecated) These properties are used to configure tGlobalVarLoad running in the MapReduce Job framework. The MapReduce tGlobalVarLoad component belongs to the MapReduce family. The information in this section is …. Continue Reading »

tCombinedSQLInput Extracts fields from a database table based on its schema definition. Then it passes on the field list to the next component via a Combine row link. The schema of tCombinedSQLInput can be different from that of the source database table but must correspond to it in terms of …. Continue Reading »

tMSSqlClose Closes a transaction in the MSSql databases. tMSSqlClose Standard properties These properties are used to configure tMSSqlClose running in the Standard Job framework. The Standard tMSSqlClose 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 »

tELTVerticaMap Builds the SQL SELECT statement using the table schema(s) provided by one or more tELTVerticaInput components. 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 generate SQL statements, including clauses, which are …. Continue Reading »

tMondrianInput Executes a multi-dimensional expression (MDX) query corresponding to the dataset structure and schema definition. tMondrianInput reads data from relational databases and produces multidimensional data sets based on an MDX query. Then it passes on the multidimensional dataset to the next component via a Main row link. tMondrianInput Standard properties …. Continue Reading »

tDataprepRun Applies a preparation made using Talend Data Preparation in a standard Data Integration Job. tDataprepRun fetches a preparation made using Talend Data Preparation and applies it to a set of data. Depending on the Talend product you are using, this component can be used in one, some or all …. Continue Reading »

tMatchGroup Creates groups of similar data records in any source data including large volumes of data by using one or several match rules. tMatchGroup compares columns in both standard input data flows and in M/R input data flows by using matching methods and groups similar encountered duplicates together. Several tMatchGroup …. Continue Reading »

tKMeansModel Analyzes incoming datasets based on applying the K-Means algorithm. This component analyzes feature vectors usually pre-processed by tModelEncoder to generate a clustering model that is used by tPredict to cluster given elements. It generates a clustering model out of this analysis and writes this model either in memory or …. Continue Reading »

tAmazonMysqlRollback Cancels the transaction commit in the connected database and avoids to commit part of a transaction involuntarily. tAmazonMysqlRollback Standard properties These properties are used to configure tAmazonMysqlRollback running in the Standard Job framework. The Standard tAmazonMysqlRollback component belongs to the Cloud and the Databases families. The component in this …. Continue Reading »