tJDBCInput properties for Apache Spark Batch These properties are used to configure tJDBCInput running in the Spark Batch Job framework. The Spark Batch tJDBCInput component belongs to the Databases family. This component also allows you to connect and read data from a RDS MariaDB, a RDS PostgreSQL or a RDS …. Continue Reading »

tLDAPRenameEntry Renames ones or more entries in a specific LDAP directory. tLDAPRenameEntry Standard properties These properties are used to configure tLDAPRenameEntry running in the Standard Job framework. The Standard tLDAPRenameEntry component belongs to the Databases family. The component in this framework is available in all Talend products. Basic settings Property …. Continue Reading »

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

tIngresClose Closes the transaction committed in the connected Ingres database. tIngresClose Standard properties These properties are used to configure tIngresClose running in the Standard Job framework. The Standard tIngresClose component belongs to the Databases family. The component in this framework is available in all Talend products. Note: This component is …. Continue Reading »

tRedshiftRow Acts on the actual DB structure or on the data (although without handling data), depending on the nature of the query and the database. The SQLBuilder tool helps you write easily your SQL statements. tRedshiftRow is the specific component for this database query. It executes the SQL query stated …. Continue Reading »

Defining data lineage with Cloudera Navigator If you are using Cloudera V5.5+ to run your MapReduce or Apache Spark Batch Jobs, you can make use of Cloudera Navigator to trace the lineage of given data flow to discover how this data flow was generated by a Job. This lineage includes …. 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 »

tHSQLDbRow Acts on the actual DB structure or on the data (although without handling data), depending on the nature of the query and the database. The SQLBuilder tool helps you write easily your SQL statements. tHSQLDbRow is the specific component for this database query. It executes the SQL query stated …. Continue Reading »

tAS400Output Writes, updates, makes changes or suppresses entries in a database. tAS400Output 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. tAS400Output Standard properties These properties are used to configure tAS400Output running …. Continue Reading »

tImpalaClose Closes connection to an Impala database. tImpalaClose closes an active connection to a given Impala database. tImpalaClose Standard properties These properties are used to configure tImpalaClose running in the Standard Job framework. The Standard tImpalaClose component belongs to the Big Data family. The component in this framework is available …. Continue Reading »

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

tSQLDWHRollback Cancels the transaction commit in the connected Azure SQL Data Warehouse database to prevent partial transaction commit if an error occurs. tSQLDWHRollback Standard properties These properties are used to configure tSQLDWHRollback running in the Standard Job framework. The Standard tSQLDWHRollback component belongs to two families: Cloud and Databases. The …. Continue Reading »

tDBRow Executes the stated SQL query onto a database. This component works with a variety of databases depending on your selection. tDBRow Standard properties These properties are used to configure tDBRow running in the Standard Job framework. The Standard tDBRow component belongs to the Databases family. The component in this …. Continue Reading »

tDataUnmasking Unmasks data masked with the tDataMasking component to retrieve the original data. The tDataUnmasking component can only unmask data masked with the tDataMasking component, using the FF1 with AES or FF1 with SHA-2 method combined with a user-defined password. For each column to unmask from the input data, select …. Continue Reading »

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

tGSBucketList Retrieves a list of buckets from all projects or one specific project in Google Cloud Storage. tGSBucketList iterates on all buckets within all projects or one specific project in Google Cloud Storage. tGSBucketList Standard properties These properties are used to configure tGSBucketList running in the Standard Job framework. The …. Continue Reading »

tGroovy tGroovy broadens the functionality if the Talend Job, using the Groovy language which is a simplified Java syntax. tGroovy allows you to enter customized code which you can integrate in the Talend programme. The code is run only once. tGroovy Standard properties These properties are used to configure tGroovy …. Continue Reading »

tVerticaOutputBulkExec Receives data from a preceding component, writes data into a local file, and loads data into a Vertica database from the file using the Vertica COPY SQL statement. For more information about the Vertica COPY SQL statement, see COPY. The tVerticaOutputBulk component and the tVerticaBulkExec component are generally used …. Continue Reading »

tMongoDBGridFSProperties Obtains information about the properties of given files selected based on a query. tMongoDBGridFSProperties iterates on files of a bucket in MongoDB GridFS to extract the attributes of these files. tMongoDBGridFSProperties Standard properties These properties are used to configure tMongoDBGridFSProperties running in the Standard Job framework. The Standard tMongoDBGridFSProperties …. Continue Reading »

tSybaseRollback Cancels the transaction committed in the Sybase database. tSybaseRollback Standard properties These properties are used to configure tSybaseRollback running in the Standard Job framework. The Standard tSybaseRollback component belongs to the Databases family. The component in this framework is available in all Talend products. Note: This component is a …. Continue Reading »

tCassandraRow Acts on the actual DB structure or on the data, depending on the nature of the query and the database. tCassandraRow is the specific component for this database query. It executes the Cassandra Query Language (CQL) query stated in the specified database. The row suffix means the component implements …. Continue Reading »

tAssert Generates the boolean evaluation on the concern for the Job execution status and provides the Job status messages to tAssertCatcher. The status includes: Ok: the Job execution succeeds. Fail: the Job execution fails. The tested Job’s result does not match the expectation or an execution error occurred at runtime. …. Continue Reading »

tMongoDBConnection Creates a connection to a MongoDB database and reuse that connection in other components. tMongoDBConnection opens a connection to a database in order that a transaction may be made. tMongoDBConnection Standard properties These properties are used to configure tMongoDBConnection running in the Standard Job framework. The Standard tMongoDBConnection component …. Continue Reading »

tIngresOutputBulk Prepares the file whose data is inserted in bulk to the Ingres DBMS for performance gain. tIngresOutputBulk and tIngresBulkExec are generally used together in a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT operation …. Continue Reading »