tOracleSP Calls an Oracle database stored procedure. tOracleSP offers a convenient way to centralize multiple or complex queries in a database and call them easily. tOracleSP Standard properties These properties are used to configure tOracleSP running in the Standard Job framework. The Standard tOracleSP component belongs to the Databases family. …. Continue Reading »

tNetezzaBulkExec Offers gains in performance while carrying out the Insert operations to a Netezza database. tNetezzaBulkExec Standard properties These properties are used to configure tNetezzaBulkExec running in the Standard Job framework. The Standard tNetezzaBulkExec component belongs to the Databases family. The component in this framework is available in all Talend …. Continue Reading »

tFileInputDelimited MapReduce properties (deprecated) These properties are used to configure tFileInputDelimited running in the MapReduce Job framework. The MapReduce tFileInputDelimited 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 »

tMDMTriggerInput Reads the XML message (Document type) sent by MDM and passes the information to the component that follows. Every time when you save a change in your MDM, the corresponding record is generated in XML format. At runtime, this component reads this record and sends the relative information to …. Continue Reading »

tGSConfiguration Provides the connection configuration to Google Cloud Storage for a Spark Job. tGSConfiguration properties for Apache Spark Batch These properties are used to configure tGSConfiguration running in the Spark Batch Job framework. The Spark Batch tGSConfiguration component belongs to the Storage family. The component in this framework is available …. Continue Reading »

tSybaseBulkExec Gains in performance during Insert operations to a Sybase database. The tSybaseOutputBulk and tSybaseBulkExec components are generally used together as parts of 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 used to …. Continue Reading »

tHCatalogOperation Prepares the HCatalog managed database/table/partition to be processed. tHCatalogOperation manages the data stored in HCatalog managed Hive database/table/partition. tHCatalogOperation Standard properties These properties are used to configure tHCatalogOperation running in the Standard Job framework. The Standard tHCatalogOperation component belongs to the Big Data family. The component in this framework …. Continue Reading »

tMarkLogicConnection Opens a connection to a MarkLogic database that can then be reused by other MarkLogic components. tMarkLogicConnection Standard properties These properties are used to configure tMarkLogicConnection running in the Standard Job framework. The Standard tMarkLogicConnection component belongs to the Big Data and the Databases NoSQL families. The component in …. Continue Reading »

tFileOutputExcel Writes an MS Excel file with separated data values according to a defined schema. tFileOutputExcel Standard properties These properties are used to configure tFileOutputExcel running in the Standard Job framework. The Standard tFileOutputExcel component belongs to the File family. The component in this framework is available in all Talend …. Continue Reading »

tHDFSConfiguration Enables the reuse of the connection configuration to HDFS in the same Job. tHDFSConfiguration provides HDFS connection information for the file system related components used in the same Spark Job. The Spark cluster to be used reads this configuration to eventually connect to HDFS. Depending on the Talend product …. Continue Reading »

tAddLocationFromIP Replaces IP addresses with geographical locations. tAddLocationFromIP geolocates visitors through their IP addresses: this component identifies visitors’ geographical locations (country, region, city, latitude, longitude, ZIP code, etc.) using an IP address lookup database file. tAddLocationFromIP Standard properties These properties are used to configure tAddLocationFromIP running in the Standard Job …. Continue Reading »

Filtering a list of names using simple conditions The following scenario shows a Job that uses simple conditions to filter a list of records. This scenario will output two tables: the first will list all male persons with a last name shorter than nine characters and aged between 10 and …. Continue Reading »

tSetKerberosConfiguration Sets the relevant information for Kerberos authentication. tSetKerberosConfiguration is designed to configure Kerberos authentication for enhanced security of network communications. For more information on the Kerberos protocol, go to http://www.kerberos.org. tSetKerberosConfiguration Standard properties These properties are used to configure tSetKerberosConfiguration running in the Standard Job framework. The Standard tSetKerberosConfiguration …. Continue Reading »

tKuduOutput Creates, updates or deletes data in a Cloudera Kudu table. tKuduOutput properties for Apache Spark Batch These properties are used to configure tKuduOutput running in the Spark Batch Job framework. The Spark Batch tKuduOutput component belongs to the Databases family. The component in this framework is available in all …. Continue Reading »

tVerticaInput Retrieves data from a Vertica database table based on a SQL query. tVerticaInput Standard properties These properties are used to configure tVerticaInput running in the Standard Job framework. The Standard tVerticaInput component belongs to the Databases family. The component in this framework is available in all Talend products. Note: …. Continue Reading »

tS3BucketDelete Deletes an empty bucket from Amazon S3. “Bucket” is a term used by AWS for top level folders on S3, which can contain sub folders and store all your data (objects). tS3BucketDelete Standard properties These properties are used to configure tS3BucketDelete running in the Standard Job framework. The Standard …. Continue Reading »

tMysqlSCDELT Reflects and tracks changes in a dedicated MySQL SCD table through SQL queries. tMysqlSCDELT addresses Slowly Changing Dimension needs through SQL queries (server-side processing mode), and logs the changes into a dedicated MySQL SCD table. tMysqlSCDELT Standard properties These properties are used to configure tMysqlSCDELT running in the Standard …. Continue Reading »

tOracleCDC Extracts source system data that has changed since the last extraction and transports it to another/other system(s). tOracleCDC addresses data extraction and transportation needs. It only extracts the changes done to the source operational data and makes them available to the target system(s) using database CDC views. tOracleCDC Standard …. Continue Reading »

tSqlRow Performs SQL queries over input datasets. tSqlRow registers input RDDs (Resilient Distributed Datasets) as tables and applies queries on these tables. Depending on the Talend product you are using, this component can be used in one, some or all of the following Job frameworks: Spark Batch: see tSqlRow properties …. Continue Reading »

tSAPInfoObjectOutput Writes InfoObject data into an SAP BW system. tSAPInfoObjectOutput Standard properties These properties are used to configure tSAPInfoObjectOutput running in the Standard Job framework. The Standard tSAPInfoObjectOutput 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 »

tPostgresqlRow 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. The tPostgresqlRow is the specific component for the database query. It executes the SQL query …. Continue Reading »

tChronometerStop Operates as a chronometer device that stops calculating the processing time of one or more subJobs in the main Job, or that stops calculating the processing time of part of your subJob. tChronometerStop displays the total execution time. Measures the time a subJob takes to be executed. tChronometerStop Standard …. Continue Reading »

tOracleOutputBulk Writes a file with columns based on the defined delimiter and the Oracle standards. The tOracleOutputBulk and tOracleBulkExec components are 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 used …. Continue Reading »

tGreenplumCommit Commits global transaction in one go instead of repeating the operation for every row or every batch and thus provides gain in performance. tGreenplumCommit validates the data processed through the Job into the connected DB. This component uses an unique connection. tGreenplumCommit Standard properties These properties are used to …. Continue Reading »

tUniqRow Ensures data quality of input or output flow in a Job. tUniqRow compares entries and sorts out duplicate entries from the input flow. Depending on the Talend product you are using, this component can be used in one, some or all of the following Job frameworks: Standard: see tUniqRow …. Continue Reading »