tMarketoCampaign Retrieves campaign records, activity and campaign changes related data from Marketo. tMarketoCampaign Standard properties These properties are used to configure tMarketoCampaign running in the Standard Job framework. The Standard tMarketoCampaign component belongs to two families: Business and Cloud. The component in this framework is available in all Talend products. …. Continue Reading »

tELTOracleOutput Performs the action (insert, update, delete, or merge) on data in the specified Oracle table through the SQL statement generated by the tELTOracleMap component. 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 …. Continue Reading »

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

tCassandraOutput Writes data into or deletes data from a column family of a Cassandra keyspace. tCassandraOutput receives data from the preceding component, and writes data into Cassandra. Depending on the Talend product you are using, this component can be used in one, some or all of the following Job frameworks: …. Continue Reading »

tELTSAPInput Provides the SAP table schema that will be used by the tELTSAPMap component to generate the SQL SELECT statement. tELTSAPInput Standard properties These properties are used to configure tELTSAPInput running in the Standard Job framework. The Standard tELTSAPInput component belongs to the ELT family. The component in this framework …. Continue Reading »

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

tCompareColumns Compares two columns to design useful features for generating a classification model. tCompareColumns outputs comparison results to manually added columns. In local mode, Apache Spark 2.0.0 and 2.4.0 are supported. tCompareColumns properties for Apache Spark Batch These properties are used to configure tCompareColumns running in the Spark Batch Job …. Continue Reading »

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

Configuring the input component Double-click the tFileInputDelimited component to open its basic settings. In the File name/Stream field, set the path to the file that contains the data to be decrypted. Click the […] button next to Edit schema and use the [+] button in the dialog box to add …. Continue Reading »

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

tHashOutput Loads data to the cache memory to offer high-speed access, facilitating transactions involving a large amount of data. It should be noted that loading data will consume a lot of memory to store records for each record has an overhead. The number of inputted entries also impacts the usage …. Continue Reading »

tSynonymOutput Creates a Lucene index and feeds it with entries and the related synonyms it receives. tSynonymOutput creates synonym indexes that some components like tStandardizeRow or tSynonymSearch can refer to when processing data. For further information about how to access and manage the words and the reference entries (documents) of …. Continue Reading »

Tagging S3 objects: executing the Job Press Ctrl + S to save the Job. Press F6 to run the Job. Go to the S3 web console, select file1.txt, and click Tags. The tag added to the object appears, as shown in the following figure. Deselect file1.txt and select the other …. Continue Reading »

tBigQueryInput Performs the queries supported by Google BigQuery. This component connects to Google BigQuery and performs queries in it. tBigQueryInput Standard properties These properties are used to configure tBigQueryInput running in the Standard Job framework. The Standard tBigQueryInput component belongs to the Big Data family. The component in this framework …. Continue Reading »

tRecollector Outputs of the parallel execution results, depending on tDepartitioner. Note that Talend Studio also enables the automatic implementation of parallelization across a Job without use of the parallelization components and we recommend using that approach. For further information, see the section describing how to enable parallelization of data flows …. Continue Reading »

tSAPHanaBulkExec Improves performance while carrying out the Insert operations to an SAP HANA database. Prerequisite tSAPHanaBulkExec requires the installation of the Java driver (ngdbc.jar) to connect to SAP HANA. tSAPHanaBulkExec Standard Properties These properties are used to configure tSAPHanaBulkExec running in the Standard Job framework. The Standard tSAPHanaBulkExec component belongs …. Continue Reading »

tPaloClose Closes an active connection to a Palo Server. This component is used to disconnect a connection to a Palo server to release occupied resources. tPaloClose Standard properties These properties are used to configure tPaloClose running in the Standard Job framework. The Standard tPaloClose component belongs to the Business Intelligence …. Continue Reading »

tGPGDecrypt Calls the gpg -d command to decrypt a GnuPG-encrypted file and saves the decrypted file in the specified directory. tGPGDecrypt Standard properties These properties are used to configure tGPGDecrypt running in the Standard Job framework. The Standard tGPGDecrypt component belongs to the File family. The component in this framework …. Continue Reading »

tGSPut Uploads files from a local directory to Google Cloud Storage so that you can manage them with Google Cloud Storage. tGSPut Standard properties These properties are used to configure tGSPut running in the Standard Job framework. The Standard tGSPut component belongs to the Big Data and the Cloud families. …. Continue Reading »

tMaxDBRow Acts on the actual DB structure or on the data (although without handling data), depending on the nature of the query and the database. tMaxDBRow is the specific component for this database query. It executes the SQL query stated onto the specified database. The row suffix means the component …. Continue Reading »

tOracleInvalidRows Checks Oracle database rows against specific Data Quality patterns (regular expression) or Data Quality rules (business rule). tOracleInvalidRows extracts database rows that do not match a given data quality pattern or rule. You can then implement any required correction. tOracleInvalidRows Standard properties These properties are used to configure tOracleInvalidRows …. Continue Reading »

tFlumeOutput Acts as interface to integrate Flume and the Spark Streaming Job developed with the Studio to continuously send data to a given Flume agent. tFlumeOutput receives RDDs from its preceding component, constructs Flume events out of these RDDs and sends them to the source (input point) of a Flume …. Continue Reading »

tFlowToIterate Reads data line by line from the input flow and stores the data entries in iterative global variables. tFlowToIterate Standard properties These properties are used to configure tFlowToIterate running in the Standard Job framework. The Standard tFlowToIterate component belongs to the Orchestration family. The component in this framework is …. Continue Reading »

tSQSQueueDelete Deletes an Amazon SQS (Simple Queue Service) queue. Note: This component supports AWS server-side encryption (SSE) for SQS queues. tSQSQueueDelete Standard properties These properties are used to configure tSQSQueueDelete running in the Standard Job framework. The Standard tSQSQueueDelete component belongs to the Cloud family. The component in this framework …. Continue Reading »

tCosmosDBBulkLoad Imports data files in different formats (CSV, TSV or JSON) into the specified Cosmos database so that the data can be further processed. tCosmosDBBulkLoad Standard properties These properties are used to configure tCosmosDBBulkLoad running in the Standard Job framework. The Standard tCosmosDBBulkLoad component belongs to the Cloud and the …. Continue Reading »