tRESTResponse Returns a specific HTTP status code to the client end as a response to the HTTP and/or HTTP requests. Note: To enable the HTTPS support, you have to generate a keystore and add some HTTPS security configuration properties in the org.ops4j.pax.web.cfg file of your Runtime container. For more information, …. Continue Reading »

Configuring the input component You retrieved the tJapaneseTransliterate_standard_scenario.zip file. Double-click tFixedFlowInput to open its Basic settings view in the Component tab. Click the Edit schema button to define the columns of the source dataset and their data type. Click the [+] button to add the schema columns. In this example, …. Continue Reading »

tKinesisInputAvro Acts as consumer of an Amazon Kinesis stream to pull messages from this Kinesis stream. Using the Kinesis Client Library (KCL) provided by Amazon, tKinesisInputAvro consumes Avro-formatted data from a given Amazon Kinesis stream (an ordered sequence of data records), constructs an RDD out of this data and sends …. Continue Reading »

tElasticSearchConfiguration Enables the reuse of the connection configuration to ElasticSearch in the same Job. tElasticSearchConfiguration provides ElasticSearch connection information for the ElasticSearch components used in the same Spark Job. The Spark cluster to be used reads this configuration to eventually connect to ElasticSearch. Depending on the Talend product you are …. Continue Reading »

tSQLiteInput Executes a DB query with a defined command which must correspond to the schema definition. It passes on rows to the next component via a Main row link. tSQLiteInput reads a database file and extracts fields based on an SQL query. As it embeds the SQLite engine, no need …. Continue Reading »

tSQLTemplateRollback Cancels the transaction committed in the SQLTemplate database. tSQLTemplateRollback Standard properties These properties are used to configure tSQLTemplateRollback running in the Standard Job framework. The Standard tSQLTemplateRollback component belongs to the ELT family. The component in this framework is available in all Talend products. Basic settings Database Type Select …. Continue Reading »

tLDAPOutput Executes an LDAP query based on the given filter and corresponding to the schema definition. Then it passes on the field list to the next component via a Row > Main link. tLDAPOutput Standard properties These properties are used to configure tLDAPOutput running in the Standard Job framework. The …. Continue Reading »

tDropboxGet Downloads a selected file from a Dropbox account to a specified local directory. tDropboxGet Standard properties These properties are used to configure tDropboxGet running in the Standard Job framework. The Standard tDropboxGet component belongs to the Cloud family. The component in this framework is available in all Talend products. …. Continue Reading »

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

tMatchIndexPredict Compares a new data set with a lookup data set stored in ElasticSearch, using tMatchIndex. tMatchIndexPredict outputs unique records and suspect duplicates in separate files. In the potential duplicates output, each record contains the fields from the source records and the fields from the potentially matching lookup records. The …. Continue Reading »

tParAccelConnection Opens a connection to the specified database that can then be reused in the subsequent subjob or subjobs. The tParAccelConnection opens a connection to the database for a current transaction. tParAccelConnection Standard properties These properties are used to configure tParAccelConnection running in the Standard Job framework. The Standard tParAccelConnection …. Continue Reading »

tPetalsInput Passes Petals’ data to a Talend Job. The tPetalsInput transforms a Petal’s data flow into a flow that can be used in a Talend Job. tPetalsInput Standard properties These properties are used to configure tPetalsInput running in the Standard Job framework. The Standard tPetalsInput component belongs to the Internet …. Continue Reading »

tKafkaInput Transmits messages you need to process to the components that follow in the Job you are designing. tKafkaInput is a generic message broker that transmits messages to the Job that runs transformations over these messages. Depending on the Talend product you are using, this component can be used in …. Continue Reading »

tNetsuiteConnection Creates a connection to the NetSuite SOAP server so that other NetSuite components in the Job can reuse the connection. tNetsuiteConnection Standard properties These properties are used to configure tNetsuiteConnection running in the Standard Job framework. The Standard tNetsuiteConnection component belongs to the Business family. The component in this …. Continue Reading »

tELTMap Uses the tables provided as input to feed the parameter in the built SQL statement. The statement can include inner or outer joins to be implemented between tables or between one table and its aliases. The three ELT components are closely related, in terms of their operating conditions. These …. Continue Reading »

tWriteJSONField Transforms the incoming data into JSON fields and transfers them to a file, a database table, etc. 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 tWriteJSONField Standard properties. The component in this …. Continue Reading »

tGoogleDrivePut Uploads data from a data flow or a local file to Google Drive. tGoogleDrivePut Standard properties These properties are used to configure tGoogleDrivePut running in the Standard Job framework. The Standard tGoogleDrivePut component belongs to the Cloud family. The component in this framework is available in all Talend products. …. Continue Reading »

tTachyonConfiguration Defines a connection to Tachyon storage system and enables the reuse of the configuration in the same Job. You define a connection to Tachyon in tTachyonConfiguration and configure the file system related components to reused this connection. At runtime, the Spark cluster to be used reads this configuration to …. Continue Reading »

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

tNeo4jOutputRelationship Receives data from the preceding component and writes relationships into Neo4j. tNeo4jOutputRelationship Standard properties These properties are used to configure tNeo4jOutputRelationship running in the Standard Job framework. The Standard tNeo4jOutputRelationship component belongs to the Big Data and the Databases NoSQL families. The component in this framework is available in …. Continue Reading »

tFileOutputJSON Receives data and rewrites it in a JSON structured data block in an output file. 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 tFileOutputJSON Standard properties. The component in this framework is …. Continue Reading »

tMDMConnection Opens an MDM server connection for convenient reuse in the current Job or transaction. tMDMConnection Standard properties These properties are used to configure tMDMConnection running in the Standard Job framework. The Standard tMDMConnection component belongs to the Talend MDM family. The component in this framework is available in all …. Continue Reading »

tMSSqlOutputBulkExec Gains in performance during Insert operations to a Microsoft SQL Server database. The tMSSqlOutputBulk and tMSSqlBulkExec 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 to feed …. Continue Reading »

tMapRDBClose Closes an MapRDB connection you have established in a same Job. tMapRDBClose Standard properties These properties are used to configure tMapRDBClose running in the Standard Job framework. The Standard tMapRDBClose component belongs to the Big Data and the Databases NoSQL families. The component in this framework is available in …. Continue Reading »

tDenormalize Denormalizes the input flow based on one column. 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 tDenormalize Standard properties. The component in this framework is available in all Talend products. MapReduce: see …. Continue Reading »