Talend Components

Reference Guide

5.6.3

Adapted for v5.6.3. Supersedes previous
releases.

February 2, 2016

Copyright © 2007-2016 Talend Inc. All rights reserved.

Notices

All brands, product names, company names, trademarks and service marks are the
properties of their respective owners.

End User License Agreement

The software described in this documentation is provided under Talend‘s End User License Agreement (EULA) for commercial
products. By using the software, you are considered to have fully understood and
unconditionally accepted all the terms and conditions of the EULA.

To read the EULA now, visit http://www.talend.com/legal-terms/us-eula.

1. Big Data components

tBigQueryBulkExec

tBigQueryBulkExec Properties
Related Scenario

tBigQueryInput

tBigQueryInput Properties
Scenario: Performing a query in BigQuery

tBigQueryOutput

tBigQueryOutput Properties
Scenario: Writing data in BigQuery

tBigQueryOutputBulk

tBigQueryOutputBulk Properties
Related Scenario

tCassandraBulkExec

tCassandraBulkExec properties
Related Scenario

tCassandraClose

tCassandraClose properties
Related Scenario

tCassandraConnection

tCassandraConnection properties
Related scenario

tCassandraInput

tCassandraInput properties
Mapping table between Cassandra type and Talend data type
Scenario: Handling data with Cassandra

tCassandraOutput

tCassandraOutput properties
Related Scenario

tCassandraOutputBulk

tCassandraOutputBulk properties
Related scenario

tCassandraOutputBulkExec

tCassandraOutputBulkExec properties
Related Scenario

tCassandraRow

tCassandraRow properties
Related scenario

tCouchbaseClose

tCouchbaseClose properties
Related scenario

tCouchbaseConnection

tCouchbaseConnection properties
Related scenario

tCouchbaseInput

tCouchbaseInput Properties
Scenario 1: Querying JSON documents in the Couchbase database by unique document IDs
Scenario 2: Querying JSON documents in the Couchbase database through view queries

tCouchbaseOutput

tCouchbaseOutput Properties
Scenario: Inserting documents to a data bucket in the Couchbase database

tCouchDBClose

tCouchDBClose properties
Related Scenario

tCouchDBConnection

tCouchDBConnection properties
Related scenario

tCouchDBInput

tCouchDBInput properties
Related Scenario

tCouchDBOutput

tCouchDBOutput properties
Scenario: Replicating data from the source database to the target database

tGSBucketCreate

tGSBucketCreate properties
Related scenario

tGSBucketDelete

tGSBucketDelete properties
Related scenario

tGSBucketExist

tGSBucketExist properties
Related scenario

tGSBucketList

tGSBucketList properties
Related scenario

tGSClose properties
Related scenario

tGSConnection

tGSConnection properties
Related scenario

tGSCopy properties
Related scenario

tGSDelete properties
Related scenario

tGSGet properties
Related scenario

tGSList properties
Related scenario

tGSPut properties
Scenario: Managing files with Google Cloud Storage

tHBaseClose

tHBaseClose properties
Related scenario

tHBaseConnection

tHBaseConnection properties
Related scenario

tHBaseInput

tHBaseInput properties
HBase filters
Scenario: Exchanging customer data with HBase

tHBaseOutput

tHBaseOutput properties
tHBaseOutput in Talend Map/Reduce Jobs
Related scenario

tHCatalogInput

tHCatalogInput Properties
Related scenario

tHCatalogLoad

tHCatalogLoad Properties
Related scenario

tHCatalogOperation

tHCatalogOperation Properties
Scenario: HCatalog table management on Hortonworks Data Platform

tHCatalogOutput

tHCatalogOutput Properties
Related scenario

tHDFSCompare

tHDFSCompare properties
Related scenario

tHDFSConnection

tHDFSConnection properties
Related scenario

tHDFSCopy properties
Related scenario

tHDFSDelete

tHDFSDelete properties
Related scenario

tHDFSExist properties
Scenario: Checking the existence of a file in HDFS

tHDFSGet properties
Scenario: Computing data with Hadoop distributed file system

tHDFSInput properties
tHDFSInput in Talend Map/Reduce Jobs
Related scenario

tHDFSList properties
Scenario: Iterating on a HDFS directory

tHDFSOutput

tHDFSOutput properties
tHDFSOutput in Talend Map/Reduce Jobs
Related scenario

tHDFSProperties

tHDFSProperties properties
Related scenario

tHDFSPut properties
Related scenario

tHDFSRename

tHDFSRename Properties
Related scenario

tHDFSRowCount

tHDFSRowCount properties
Related scenario

tHiveClose properties
Related scenario

tHiveConnection

tHiveConnection properties
Connecting to a custom Hadoop distribution
Scenario: creating a partitioned Hive table

tHiveCreateTable

tHiveCreateTable properties
Related scenario

tHiveInput properties
Related scenarios

tHiveLoad properties
Related scenario

tHiveRow properties
Related scenarios

tImpalaClose

tImpalaClose properties
Related scenario

tImpalaConnection

tImpalaConnection properties
Related scenario

tImpalaCreateTable

tImpalaCreateTable properties
Related scenario

tImpalaInput

tImpalaInput properties
Related scenarios

tImpalaLoad

tImpalaLoad properties
Related scenario

tImpalaOutput

tImpalaOutput properties
Related scenarios

tImpalaRow properties
Related scenarios

tMemSQLConnection

tMemSQLConnection Properties
Related scenario

tMemSQLClose

tMemSQLClose properties
Related scenario

tMemSQLInput

tMemSQLInput properties
Scenario: Writing data to and reading data from a MemSQL database table

tMemSQLOutput

tMemSQLOutput properties
Related scenario

tMemSQLRow properties
Related scenario

tMongoDBBulkLoad

tMongoDBBulkLoad properties
Scenario: Importing data into MongoDB database

tMongoDBClose

tMongoDBClose properties
Related scenario

tMongoDBConnection

tMongoDBConnection properties
Related scenario

tMongoDBInput

tMongoDBInput Properties
Scenario: Retrieving data from a collection by advanced queries
Related scenarios

tMongoDBOutput

tMongoDBOutput Properties
Scenario 1: Creating a collection and writing data to it
Scenario 2: Upserting records in a collection

tMongoDBRow

tMongoDBRow Properties
Scenario: Using MongoDB functions to create a collection and write data to it

tNeo4jClose

tNeo4jClose properties
Related scenarios

tNeo4jConnection

tNeo4jConnection properties
Related scenarios

tNeo4jInput

tNeo4jInput properties
Related scenarios

tNeo4jOutput

tNeo4jOutput properties
Scenario 1: Writing data to a Neo4j database and reading specific data from it
Scenario 2: Writing family information to Neo4j and creating relationships

tNeo4jOutputRelationship

tNeo4jOutputRelationship properties
Scenario: Writing information of actors and movies to Neo4j with hierarchical relationship

tNeo4jRow properties
Scenario 1: Creating nodes with a label using a Cypher query
Scenario 2: Importing data from a CSV file to Neo4j using a Cypher query
Scenario 3: Importing data from a CSV file to Neo4j and creating relationships using a single Cypher query

tPigAggregate

tPigAggregate Properties
Related scenario

tPigCode Properties
Scenario: Selecting a column of data from an input file and store it into a local file

tPigCoGroup

tPigCoGroup Properties
Scenario: aggregating data from two relations using COGROUP

tPigCross Properties
Related scenario

tPigDistinct

tPigDistinct Properties
Related scenario

tPigFilterColumns

tPigFilterColumns Properties
Related Scenario

tPigFilterRow

tPigFilterRow Properties
Scenario: Filtering rows of data based on a condition and saving the result to a local file

tPigJoin Properties
Scenario: Joining two files based on an exact match and saving the result to a local file

tPigLoad Properties
Scenario: Loading an HBase table

tPigMap properties
Optional map settings
Scenario: Joining data about road conditions in a Pig process

tPigReplicate

tPigReplicate Properties
Scenario: Replicating a flow and sorting two identical flows respectively

tPigSort Properties
Scenario: Sorting data in ascending order

tPigStoreResult

tPigStoreResult Properties
Related Scenario

tRiakBucketList

tRiakBucketList properties
Related scenario

tRiakClose properties
Related Scenario

tRiakConnection

tRiakConnection properties
Related scenario

tRiakInput properties
Scenario: Exporting data from a Riak bucket to a local file

tRiakKeyList

tRiakKeyList properties
Related scenario

tRiakOutput

tRiakOutput properties
Related Scenario

tSparkAggregate

tSparkAggregate properties
Related scenario

tSparkALSModel

tSparkALSModel properties
Scenario: creating an user-movie recommender model

tSparkConnection

tSparkConnection properties
Related scenario

tSparkFilterColumns

tSparkFilterColumns properties
Related scenario

tSparkFilterRow

tSparkFilterRow properties
Related scenario

tSparkJoin properties
Related scenario

tSparkLoad properties
Scenario: streaming Twitter feed of a given Twitter account

tSparkLog properties
Related scenario

tSparkNormalize

tSparkNormalize properties
Related scenario

tSparkRecommend

tSparkRecommend properties
Scenario: recommending movies to users

tSparkReplicate

tSparkReplicate properties
Related scenario

tSparkSample

tSparkSample properties
Related scenario

tSparkSort properties
Related scenario

tSparkStore

tSparkStore properties
Related scenario

tSparkUnion

tSparkUnion properties
Related scenario

tSparkUniq properties
Related scenario

tSqoopExport

tSqoopExport Properties
Additional arguments
Related scenario

tSqoopImport

tSqoopImport Properties
Scenario: Importing a MySQL table to HDFS

tSqoopImportAllTables

tSqoopImportAllTables Properties
Related scenario

tSqoopMerge

tSqoopMerge Properties
Scenario: Merging two datasets in HDFS

2. Business components

tAlfrescoOutput

tAlfrescoOutput Properties
Scenario: Creating documents on an Alfresco server

tBonitaDeploy

tBonitaDeploy Properties
Related Scenario

tBonitaInstantiateProcess

tBonitaInstantiateProcess Properties
Scenario 1: Executing a Bonita process via a Talend Job
Scenario 2: Outputting the process instance UUID over the Row > Main link

tCentricCRMInput

tCentricCRMInput Properties
Related Scenario

tCentricCRMOutput

tCentricCRMOutput Properties
Related Scenario

tHL7Input Properties
Scenario: Retrieving information about patients and events from an HL7 file

tHL7Output Properties
Scenario: Generating an HL7 Acknowledgment message
Related scenario

tMarketoInput

tMarketoInput Properties
Related Scenario

tMarketoListOperation

tMarketoListOperation Properties
Scenario: Adding a lead record to a list in the Marketo DB

tMarketoOutput

tMarketoOutput Properties
Scenario: Data transmission between Marketo DB and an external system

tMicrosoftCrmInput

tMicrosoftCrmInput Properties
Scenario: Writing data in a Microsoft CRM database and putting conditions on columns to extract specified rows

tMicrosoftCrmOutput

tMicrosoftCrmOutput Properties
Related Scenario

tMSAXInput properties
Related scenarios

tMSAXOutput

tMSAXOutput properties
Scenario 1: Inserting data in a defined table in a MicrosoftAX server
Scenario 2: Deleting data from a defined table in a MicrosoftAX server

tNetsuiteInput

tNetsuiteInput properties
Related Scenario

tNetsuiteOutput

tNetsuiteOutput properties
Related Scenario

tOpenbravoERPInput

tOpenbravoERPInput properties
Related Scenario

tOpenbravoERPOutput

tOpenbravoERPOutput properties
Related scenario

tSageX3Input

tSageX3Input Properties
Scenario: Using query key to extract data from a given Sage X3 system

tSageX3Output

tSageX3Output Properties
Scenario: Using a Sage X3 Web service to insert data into a given Sage X3 system

tSalesforceBulkExec

tSalesforceBulkExec Properties
Related Scenario:

tSalesforceConnection

tSalesforceConnection properties
Scenario: Using OAuth2 to log in to Salesforce.com

tSalesforceGetDeleted

tSalesforceGetDeleted properties
Scenario: Recovering deleted data from the Salesforce server

tSalesforceGetServerTimestamp

tSalesforceGetServerTimestamp properties
Related scenarios

tSalesforceGetUpdated

tSalesforceGetUpdated properties
Related scenarios

tSalesforceInput

tSalesforceInput Properties
Scenario: Using queries to extract data from a Salesforce database

tSalesforceOutput

tSalesforceOutput Properties
Scenario 1: Deleting data from the Account object
Scenario 2: Gathering erroneous data while inserting data to a module at Salesforce.com
Scenario 3: Inserting AccountIDs from an Excel File to the Contact Module
Scenario 4: Upserting the Contact module based on mapping relationships with the external IDs in the Account module

tSalesforceOutputBulk

tSalesforceOutputBulk Properties
Scenario: Inserting transformed bulk data into your Salesforce.com

tSalesforceOutputBulkExec

tSalesforceOutputBulkExec Properties
Scenario: Inserting bulk data into your Salesforce.com

tSalesforceWaveBulkExec

tSalesforceWaveBulkExec properties
Related scenario

tSalesforceWaveOutputBulkExec

tSalesforceWaveOutputBulkExec properties
Related scenario

tSAPBWInput

tSAPBWInput Properties
Scenario: Reading data from SAP BW database

tSAPBapi Properties
Scenario 1: Retrieving data from an SAP system by calling a BAPI function using multiple input/output parameters
Scenario 2: Retrieving data from an SAP system by calling a BAPI function using document type parameters

tSAPCommit Properties
Related scenario

tSAPConnection

tSAPConnection properties
Related scenarios

tSAPIDocInput

tSAPIDocInput Properties
Scenario: Connecting to a given SAP R/3 system for listening the creation of IDoc files

tSAPIDocOutput

tSAPIDocOutput Properties
Related scenarios

tSAPIDocReceiver

tSAPIDocReceiver Properties
Scenario: Consuming IDocs for processing by tHMap

tSAPInput Properties
Scenario 1: Retrieving metadata from the SAP system
Scenario 2: Reading data in the different schemas of the RFC_READ_TABLE function
Scenario 3: Retrieving data from an SAP system

tSAPOutput Properties
Related scenario

tSAPRollback

tSAPRollback properties
Related scenarios

tSAPTableInput

tSAPTableInput Properties
Scenario: Retrieving data from a specified SAP table

tSugarCRMInput

tSugarCRMInput Properties
Scenario: Extracting account data from SugarCRM

tSugarCRMOutput

tSugarCRMOutput Properties
Related Scenario

tVtigerCRMInput

tVtigerCRMInput Properties
Related Scenario

tVtigerCRMOutput

tVtigerCRMOutput Properties
Related Scenario

3. Business Intelligence components

tBarChart properties
Scenario: Creating a bar chart from the input data

tDB2SCD properties
Related scenarios

tDB2SCDELT Properties
Related Scenario

tGreenplumSCD

tGreenplumSCD Properties
Related scenario

tInformixSCD

tInformixSCD properties
Related scenario

tIngresSCD Properties
Related scenario

tJasperOutput

tJasperOutput Properties
Scenario: Generating a report against a .jrxml template

tJasperOutputExec

tJasperOutputExec Properties
Related Scenario

tLineChart properties
Scenario: Creating a line chart to ease trend analysis

tMondrianInput

tMondrianInput Properties
Scenario: Cross-join tables

tMSSqlSCD Properties
Related scenario

tMysqlSCD Properties
Scenario: Tracking changes using Slowly Changing Dimensions (type 0 through type 3)

tMysqlSCDELT

tMysqlSCDELT Properties
Related Scenario

tNetezzaSCD

tNetezzaSCD Properties
Related scenario

tOracleSCD Properties
Related scenario

tOracleSCDELT

tOracleSCDELT Properties
Related Scenario

tPaloCheckElements

tPaloCheckElements Properties
Related scenario

tPaloClose Properties
Related scenario

tPaloConnection

tPaloConnection Properties
Related scenario

tPaloCube Properties
Scenario: Creating a cube in an existing database

tPaloCubeList

tPaloCubeList Properties
Discovering the read-only output schema of tPaloCubeList
Scenario: Retrieving detailed cube information from a given database

tPaloDatabase

tPaloDatabase Properties
Scenario: Creating a database

tPaloDatabaseList

tPaloDatabaseList Properties
Discovering the read-only output schema of tPaloDatabaseList
Scenario: Retrieving detailed database information from a given Palo server

tPaloDimension

tPaloDimension Properties
Scenario: Creating a dimension with elements

tPaloDimensionList

tPaloDimensionList Properties
Discovering the read-only output schema of tPaloDimensionList
Scenario: Retrieving detailed dimension information from a given database

tPaloInputMulti

tPaloInputMulti Properties
Scenario: Retrieving dimension elements from a given cube

tPaloOutput

tPaloOutput Properties
Related scenario

tPaloOutputMulti

tPaloOutputMulti Properties
Scenario 1: Writing data into a given cube
Scenario 2: Rejecting inflow data when the elements to be written do not exist in a given cube

tPaloRule Properties
Scenario: Creating a rule in a given cube

tPaloRuleList

tPaloRuleList Properties
Discovering the read-only output schema of tPaloRuleList
Scenario: Retrieving detailed rule information from a given cube

tParAccelSCD

tParAccelSCD Properties
Related scenario

tPostgresPlusSCD

tPostgresPlusSCD Properties
Related scenario

tPostgresPlusSCDELT

tPostgresPlusSCDELT Properties
Related Scenario

tPostgresqlSCD

tPostgresqlSCD Properties
Related scenario

tPostgresqlSCDELT

tPostgresqlSCDELT Properties
Related Scenario

tSPSSInput properties
Scenario: Displaying the content of an SPSS .sav file

tSPSSOutput

tSPSSOutput properties
Scenario: Writing data in an .sav file

tSPSSProperties

tSPSSProperties properties
Related scenarios

tSPSSStructure

tSPSSStructure properties
Related scenarios

tSybaseSCD properties
Related scenarios

tSybaseSCDELT

tSybaseSCDELT Properties
Related Scenario

tVerticaSCD

tVerticaSCD Properties
Tips and Techniques
Related scenarios

4. Cloud components

tAmazonAuroraClose

tAmazonAuroraClose properties
Related scenario

tAmazonAuroraCommit

tAmazonAuroraCommit Properties
Related scenario

tAmazonAuroraConnection

tAmazonAuroraConnection Properties
Related scenario

tAmazonAuroraInput

tAmazonAuroraInput properties
Related scenarios

tAmazonAuroraOutput

tAmazonAuroraOutput properties
Related scenario

tAmazonAuroraRollback

tAmazonAuroraRollback properties
Related scenario

tAmazonMysqlClose

tAmazonMysqlClose properties
Related scenario

tAmazonMysqlCommit

tAmazonMysqlCommit Properties
Related scenario

tAmazonMysqlConnection

tAmazonMysqlConnection Properties
Scenario: Inserting data in mother/daughter tables

tAmazonMysqlInput

tAmazonMysqlInput properties
Scenario 1: Writing columns from a MySQL database to an output file
Scenario 2: Writing dynamic columns from a MySQL database to an output file

tAmazonMysqlOutput

tAmazonMysqlOutput properties
Scenario 1: Adding a new column and altering data in a DB table
Scenario 2: Updating data in a database table
Scenario 3: Retrieve data in error with a Reject link
Scenario 4: Writing dynamic columns from a source file to a MySQL database

tAmazonMysqlRollback

tAmazonMysqlRollback properties
Scenario: Rollback from inserting data in mother/daughter tables

tAmazonMysqlRow

tAmazonMysqlRow properties
Scenario 1: Removing and regenerating a MySQL table index
Scenario 2: Using PreparedStatement objects to query data
Related scenarios

tAmazonOracleClose

tAmazonOracleClose properties
Related scenario

tAmazonOracleCommit

tAmazonOracleCommit Properties
Related scenario

tAmazonOracleConnection

tAmazonOracleConnection Properties
Related scenario

tAmazonOracleInput

tAmazonOracleInput properties
Related scenarios

tAmazonOracleOutput

tAmazonOracleOutput properties
Related scenarios

tAmazonOracleRollback

tAmazonOracleRollback properties
Related scenario

tAmazonOracleRow

tAmazonOracleRow properties
Related scenarios

tAzureStorageConnection

tAzureStorageConnection properties
Related scenario

tAzureStorageContainerCreate

tAzureStorageContainerCreate properties
Scenario: Creating a container in Azure Storage

tAzureStorageContainerDelete

tAzureStorageContainerDelete properties
Related scenario

tAzureStorageContainerExist

tAzureStorageContainerExist properties
Related scenario

tAzureStorageDelete

tAzureStorageDelete properties
Related scenario

tAzureStorageGet

tAzureStorageGet properties
Scenario: Retrieving files from a Azure Storage container

tAzureStorageList

tAzureStorageList properties
Related scenario

tAzureStoragePut

tAzureStoragePut properties
Related scenario

tBoxConnection

tBoxConnection properties
Related scenario

tBoxCopy properties
Related scenario

tBoxDelete properties
Related scenario

tBoxGet properties
Related scenario

tBoxList properties
Related scenario

tBoxPut properties
Scenario: Uploading and downloading files from Box

tCloudStart

tCloudStart Properties
Related scenario

tCloudStop Properties
Related scenario

tDropboxConnection

tDropboxConnection properties
Related scenario

tDropboxDelete

tDropboxDelete properties
Related scenario

tDropboxGet

tDropboxGet properties
Related scenario

tDropboxList

tDropboxList properties
Related scenario

tDropboxPut

tDropboxPut properties
Scenario: Uploading files to Dropbox

tGoogleDriveConnection

tGoogleDriveConnection properties
Obtaining an access token for Google Drive
Related scenario

tGoogleDriveCopy

tGoogleDriveCopy properties
Related scenario

tGoogleDriveCreate

tGoogleDriveCreate properties
Related scenario

tGoogleDriveDelete

tGoogleDriveDelete properties
Related scenario

tGoogleDriveGet

tGoogleDriveGet properties
Related scenario

tGoogleDriveList

tGoogleDriveList properties
Related scenario

tGoogleDrivePut

tGoogleDrivePut properties
Managing files with Google Drive

tS3BucketCreate

tS3BucketCreate properties
Related scenario

tS3BucketDelete

tS3BucketDelete properties
Related scenario

tS3BucketExist

tS3BucketExist properties
Scenario: Verifing the absence of a bucket, creating it and listing all the S3 buckets

tS3BucketList

tS3BucketList properties
Related scenario

tS3Close properties
Related scenario

tS3Connection

tS3Connection properties
Related scenario

tS3Delete properties
Related scenario

tS3Get properties
Related scenario

tS3List properties
Scenario: Listing files with the same prefix from a bucket

tS3Put properties
Scenario: File exchanges with Amazon S3

5. Custom Code components

tGroovy properties
Related Scenarios

tGroovyFile

tGroovyFile properties
Scenario: Calling a file which contains Groovy code

tJava properties
Scenario: Printing out a variable content

tJavaFlex properties
Scenario 1: Generating data flow
Scenario 2: Processing rows of data with tJavaFlex
Scenario 3: Using tJavaFlex to display file content based on a dynamic schema

tJavaMR properties
Scenario: Counting words using custom map and reduce code

tJavaRow properties
Scenario 1: Transforming data line by line using tJavaRow
Scenario 2: Using tJavaRow to handle file content based on a dynamic schema

tJavaStorm properties
Related scenario

tLibraryLoad

tLibraryLoad properties
Scenario: Checking the format of an e-mail addressl

tSetDynamicSchema

tSetDynamicSchema properties
Related scenario

tSetGlobalVar

tSetGlobalVar properties
Scenario: Printing out the content of a global variable

6. Data Quality components

tAddCRCRow properties
Scenario: Adding a surrogate key to a file

tAddressRowCloud

tAddressRowCloud properties
Address verification levels in tAddressRowCloud
Scenario: Parsing addresses against reference data in the Cloud

tBatchAddressRowCloud

tBatchAddressRowCloud properties

tBlockedFuzzyJoin

tBlockedFuzzyJoin properties
Scenario: Doing a fuzzy match on two columns and outputting the match, possible match and non match values

tDqReportRun

tDqReportRun properties
Scenario: Launching a profiling report from Talend Administration Center Web application

tDuplicateRow

tDuplicateRow properties
Scenario: Generating duplicate data from an input flow

tFindRegexlibExpressions

tFindRegexlibExpressions
Scenario: Connecting to a web service and returning a list of regular expressions

tFirstnameMatch

tFirstnameMatch properties
About the reference index embedded in tFirstnameMatch
Scenario: Matching first names with a reference index

tFuzzyJoin properties
Scenario: Doing a fuzzy match on two columns and outputting the main and rejected data

tFuzzyMatch

tFuzzyMatch properties
Scenario 1: Levenshtein distance of 0 in first names
Scenario 2: Levenshtein distance of 1 or 2 in first names
Scenario 3: Metaphonic distance in first name

tFuzzyUniqRow

tFuzzyUniqRow properties
Scenario: Comparing four columns using different matching methods and collecting encountered duplicates

tGenKey properties
Scenario 1: Generating functional keys in the output flow
Scenario 2: Comparing columns and grouping in the output flow duplicate records that have the same functional key

tGenKeyHadoop

tGenKeyHadoop properties
Related scenario

tGoogleAddressRow

tGoogleAddressRow properties
Scenario: Obtaining detailed geographic information using address information

tGoogleGeocoder

tGoogleGeocoder properties
Scenario: Obtaining geographic coordinates using address information

tGoogleMapLookup

tGoogleMapLookup properties
Scenario: Obtaining detailed geographic information using address and geographic coordinates

tIntervalMatch

tIntervalMatch properties
Scenario: Identifying server locations based on their IP addresses

tLastRegexlibExpressions

tLastRegexlibExpressions properties
Related scenarios

tLaunchDQReports

tLaunchDQReports properties
Scenario: Remotely launching a report from a given Talend Administration Center Web application

tLoqateAddressRow

tLoqateAddressRow properties
Address fields in tLoqateAddressRow
GeoAccuracy Code
Address verification codes in tLoqateAddressRow
Process status in tLoqateAddressRow
Scenario: Parsing addresses against Loqate data

tMatchGroup

tMatchGroup properties
Configuration wizard
Configuration wizard in Map/Reduce Jobs
Scenario 1: Grouping output data in separate flows according to the minimal distance computed in each record
Scenario 2: Matching customer data through multiple passes
Scenario 3: Matching data through multiple passes using Map/Reduce components

tMatchGroupHadoop

tMatchGroupHadoop properties
Scenario: Running customer matching through multiple passes

tMelissaDataAddress

tMelissaDataAddress properties
Scenario: Editing addresses against a MelissaData data file

tMultiPatternCheck

tMultiPatternCheck properties
Scenario: Checking the data in multiple columns against patterns

tMySQLInvalidRows

tMySQLInvalidRows properties
Scenario: Reading email addresses from a DB table and retrieving specific data including invalid rows
Scenario 2: Checking customer table against a given DQ rule to select customer records

tMySQLValidRows

tMySQLValidRows properties
Related scenarios

tOracleInvalidRows

tOracleInvalidRows properties
Related scenarios

tOracleValidRows

tOracleValidRows properties
Related scenarios

tPatternCheck

tPatternCheck properties
Related scenarios

tPatternExtract

tPatternExtract properties
Scenario: Extracting only the data that corresponds to a defined pattern from a delimited file

tPostgresqlInvalidRows

tPostgresqlInvalidRows properties
Related scenarios

tPostgresqlValidRows

tPostgresqlValidRows properties
Related scenarios

tQASAddressIncomplete

tQASAddressIncomplete properties
Related scenarios

tQASAddressRow

tQASAddressRow properties
QuickAccess verification levels (verification status)
Scenario: Editing addresses and giving the verification status

tQASAddressUnknown

tQASAddressUnknown properties
Related scenarios

tQASAddressVerified

tQASAddressVerified properties
Related scenarios

tQASBatchAddressRow

tQASBatchAddressRow properties
Setting configuration parameters in the QAS files
Scenario: Editing addresses against QAS files and giving the verification status

tRecordMatching

tRecordMatching properties
Scenario 1: Matching entries using the Q-grams and Levenshtein algorithms
Scenario 2: Using a custom matching algorithm to match entries

tReplaceList

tReplaceList Properties
Scenario: Replacement from a reference file

tReservoirSampling

tReservoirSampling properties
Scenario: Extracting sample data from an input data set

tRuleSurvivorship

tRuleSurvivorship Properties
Scenario 1: Selecting the best-of-breed data from a group of duplicates to create a survivor
Scenario 2: Modifying the rule file manually to code the conditions you want to use to create a survivor

tSchemaComplianceCheck

tSchemaComplianceCheck Properties
Scenario: Validating data against schema

tStandardizePhoneNumber

tStandardizePhoneNumber properties
Scenario: Standardizing French phone numbers

tStandardizeRow

tStandardizeRow properties
Scenario 1: Normalizing data using rules of basic types
Scenario 2: Standardizing addresses from unstructured data
Scenario 3: Extracting exact match by using Index rules
Scenario 4: Using two parsing levels to extract information from unstructured data

tStem properties
Scenario 1: Generating stems for a list of English words
Scenario 2: Extracting the stems of English words from a specific DB column

tSurviveFields

tSurviveFields Properties
Scenario: Merge the content of several rows using different columns as rank values

tSynonymOutput

tSynonymOutput Properties
Scenario 1: Creating a synonym index for city names
Scenario 2: Creating a synonym index for people names using tMap

tSynonymSearch

tSynonymSearch Properties
Scenario 1: Searching a given index for matched reference entries
Scenario 2: Searching for matched reference entries for two input columns

tThresholdViolationAlert

tThresholdViolationAlert properties
Related scenarios

tUniqRow Properties
Scenario 1: Deduplicating entries
Scenario 2: Deduplicating entries using Map/Reduce components
Scenario 3: Deduplicating entries based on dynamic schema

tUniservBTGeneric

tUniservBTGeneric properties
Scenario: Execution of a Job in the Data Quality Service Hub Studio

tUniservRTConvertName

tUniservRTConvertName properties
Scenario: Analysis of a name line and assignment of the salutation

tUniservRTMailBulk

tUniservRTMailBulk properties
Scenario: Creating an index pool

tUniservRTMailOutput

tUniservRTMailOutput properties
Related scenarios

tUniservRTMailSearch

tUniservRTMailSearch properties
Scenario: Adding contacts to the mailRetrieval index pool

tUniservRTPost

tUniservRTPost properties
Scenario 1: Checking and correcting the postal code, city and street
Scenario 2: Checking and correcting the postal code, city and street, as well as rejecting the unfeasible

tVerifyEmail

tVerifyEmail properties

7. Databases – traditional components

tAccessBulkExec

tAccessBulkExec properties
Related scenarios

tAccessClose

tAccessClose properties
Related scenario

tAccessCommit

tAccessCommit Properties
Related scenario

tAccessConnection

tAccessConnection Properties
Scenario: Inserting data in parent/child tables

tAccessInput

tAccessInput properties
Related scenarios

tAccessOutput

tAccessOutput properties
Related scenarios

tAccessOutputBulk

tAccessOutputBulk properties
Related scenarios

tAccessOutputBulkExec

tAccessOutputBulkExec properties
Related scenarios

tAccessRollback

tAccessRollback properties
Related scenarios

tAccessRow properties
Related scenarios

tAS400CDC properties
Related scenario

tAS400Close

tAS400Close properties
Related scenario

tAS400Commit

tAS400Commit Properties
Related scenario

tAS400Connection

tAS400Connection Properties
Related scenario

tAS400Input

tAS400Input properties
Related scenarios

tAS400LastInsertId

tAS400LastInsertId properties
Related scenario

tAS400Output

tAS400Output properties
Related scenarios

tAS400Rollback

tAS400Rollback properties
Related scenarios

tAS400Row properties
Related scenarios

tDB2BulkExec

tDB2BulkExec properties
Related scenarios

tDB2CDC properties
Related scenario

tDB2Close properties
Related scenario

tDB2Commit Properties
Related scenario

tDB2Connection

tDB2Connection properties
Related scenarios

tDB2Input properties
Related scenarios

tDB2Output properties
Related scenarios

tDB2Rollback

tDB2Rollback properties
Related scenarios

tDB2Row properties
Related scenarios

tDB2SP properties
Related scenarios

tInformixBulkExec

tInformixBulkExec Properties
Related scenario

tInformixCDC

tInformixCDC properties
Related scenario

tInformixClose

tInformixClose properties
Related scenario

tInformixCommit

tInformixCommit properties
Related Scenario

tInformixConnection

tInformixConnection properties
Related scenario

tInformixInput

tInformixInput properties
Related scenarios

tInformixOutput

tInformixOutput properties
Related scenarios

tInformixOutputBulk

tInformixOutputBulk properties
Related scenario

tInformixOutputBulkExec

tInformixOutputBulkExec properties
Related scenario

tInformixRollback

tInformixRollback properties
Related Scenario

tInformixRow

tInformixRow properties
Related scenarios

tInformixSP

tInformixSP properties
Related scenarios

tMSSqlBulkExec

tMSSqlBulkExec properties
Related scenarios

tMSSqlCDC properties
Related scenario

tMSSqlColumnList

tMSSqlColumnList Properties
Related scenario

tMSSqlClose

tMSSqlClose properties
Related scenario

tMSSqlCommit

tMSSqlCommit properties
Related scenarios

tMSSqlConnection

tMSSqlConnection properties
Scenario: Inserting data into a database table and extracting useful information from it

tMSSqlInput

tMSSqlInput properties
Related scenarios

tMSSqlLastInsertId

tMSSqlLastInsertId properties
Related scenario

tMSSqlOutput

tMSSqlOutput properties
Related scenarios

tMSSqlOutputBulk

tMSSqlOutputBulk properties
Related scenarios

tMSSqlOutputBulkExec

tMSSqlOutputBulkExec properties
Related scenarios

tMSSqlRollback

tMSSqlRollback properties
Related scenario

tMSSqlRow properties
Related scenarios

tMSSqlSP Properties
Scenario: Retrieving personal information using a stored procedure
Related scenarios

tMSSqlTableList

tMSSqlTableList Properties
Related scenario

tMysqlBulkExec

tMysqlBulkExec properties
Related scenarios

tMysqlCDC properties
Scenario 1: Populating a data warehouse
Scenario 2: Retrieving modified data using CDC

tMysqlClose

tMysqlClose properties
Related scenario

tMysqlColumnList

tMysqlColumnList Properties
Scenario: Iterating on a DB table and listing its column names

tMysqlCommit

tMysqlCommit Properties
Related scenario

tMysqlConnection

tMysqlConnection Properties
Scenario 1: Inserting data in mother/daughter tables
Scenario 2: Sharing a database connection between a parent Job and child Job

tMysqlInput

tMysqlInput properties
Scenario 1: Writing columns from a MySQL database to an output file
Scenario 2: Using context parameters when reading a table from a MySQL database
Scenario 3: Reading data from MySQL databases through context-based dynamic connections
Scenario 4: Writing dynamic columns from a MySQL database to an output file

tMysqlLastInsertId

tMysqlLastInsertId properties
Scenario: Get the ID for the last inserted record

tMysqlOutput

tMysqlOutput properties
Scenario 1: Adding a new column and altering data in a DB table
Scenario 2: Updating data in a database table
Scenario 3: Retrieve data in error with a Reject link
Scenario 4: Writing dynamic columns from a source file to a MySQL database

tMysqlOutputBulk

tMysqlOutputBulk properties
Scenario: Inserting transformed data in MySQL database

tMysqlOutputBulkExec

tMysqlOutputBulkExec properties
Scenario: Inserting data in MySQL database

tMysqlRollback

tMysqlRollback properties
Scenario: Rollback from inserting data in mother/daughter tables

tMysqlRow properties
Scenario 1: Removing and regenerating a MySQL table index
Scenario 2: Using PreparedStatement objects to query data
Scenario 3: Combining two flows for selective output

tMysqlSP Properties
Scenario: Finding a State Label using a stored procedure
Related scenarios

tMysqlTableList

tMysqlTableList Properties
Scenario: Iterating on DB tables and deleting their content using a user-defined SQL template
Related scenario

tOleDbInput

tOleDbInput properties
Related scenario

tOleDbOutput

tOleDbOutput properties
Related scenario

tOleDbRow properties
Related scenario

tOracleBulkExec

tOracleBulkExec properties
Scenario: Truncating and inserting file data into an Oracle database

tOracleCDC properties
Scenario 1: Populating a data warehouse
Scenario 2: Retrieving modified data using Oracle CDC Redo log mode

tOracleCDCOutput

tOracleCDCOutput properties
Scenario: Extracting and synchronizing data changes using XStream mode

tOracleClose

tOracleClose properties
Related scenario

tOracleCommit

tOracleCommit Properties
Related scenario

tOracleConnection

tOracleConnection Properties
Related scenario

tOracleInput

tOracleInput properties
Scenario 1: Using context parameters when reading a table from an Oracle database
Related scenarios

tOracleOutput

tOracleOutput properties
Related scenarios

tOracleOutputBulk

tOracleOutputBulk properties
Related scenarios

tOracleOutputBulkExec

tOracleOutputBulkExec properties
Related scenarios

tOracleRollback

tOracleRollback properties
Related scenario

tOracleRow properties
Related scenarios

tOracleSP Properties
Scenario: Checking number format using a stored procedure
Related scenarios

tOracleTableList

tOracleTableList properties
Related scenarios

tPostgresqlBulkExec

tPostgresqlBulkExec properties
Related scenarios

tPostgresqlCDC

tPostgresqlCDC properties
Related scenario

tPostgresqlCommit

tPostgresqlCommit Properties
Related scenario

tPostgresqlClose

tPostgresqlClose properties
Related scenario

tPostgresqlConnection

tPostgresqlConnection Properties
Related scenario

tPostgresqlInput

tPostgresqlInput properties
Related scenarios

tPostgresqlOutput

tPostgresqlOutput properties
Related scenarios

tPostgresqlOutputBulk

tPostgresqlOutputBulk properties
Related scenarios

tPostgresqlOutputBulkExec

tPostgresqlOutputBulkExec properties
Related scenarios

tPostgresqlRollback

tPostgresqlRollback properties
Related scenario

tPostgresqlRow

tPostgresqlRow properties
Related scenarios

tSybaseBulkExec

tSybaseBulkExec Properties
Related scenarios

tSybaseCDC properties
Related scenario

tSybaseClose

tSybaseClose properties
Related scenario

tSybaseCommit

tSybaseCommit Properties
Related scenario

tSybaseConnection

tSybaseConnection Properties
Related scenarios

tSybaseInput

tSybaseInput Properties
Related scenarios

tSybaseIQBulkExec

tSybaseIQBulkExec Properties
Related scenarios

tSybaseIQOutputBulkExec

tSybaseIQOutputBulkExec properties
Scenario: Bulk-loading data to a Sybase IQ 12 database
Related scenarios

tSybaseOutput

tSybaseOutput Properties
Related scenarios

tSybaseOutputBulk

tSybaseOutputBulk properties
Related scenarios

tSybaseOutputBulkExec

tSybaseOutputBulkExec properties
Related scenarios

tSybaseRollback

tSybaseRollback properties
Related scenarios

tSybaseRow Properties
Related scenarios

tSybaseSP properties
Related scenarios

8. Databases – appliance/datawarehouse components

tGreenplumBulkExec

tGreenplumBulkExec Properties
Related scenarios

tGreenplumClose

tGreenplumClose properties
Related scenario

tGreenplumCommit

tGreenplumCommit Properties
Related scenarios

tGreenplumConnection

tGreenplumConnection properties
Related scenarios

tGreenplumGPLoad

tGreenplumGPLoad properties
Related scenario

tGreenplumInput

tGreenplumInput properties
Related scenarios

tGreenplumOutput

tGreenplumOutput Properties
Related scenarios

tGreenplumOutputBulk

tGreenplumOutputBulk properties
Related scenarios

tGreenplumOutputBulkExec

tGreenplumOutputBulkExec properties
Related scenarios

tGreenplumRollback

tGreenplumRollback properties
Related scenarios

tGreenplumRow

tGreenplumRow Properties
Related scenarios

tIngresBulkExec

tIngresBulkExec properties
Related scenarios

tIngresCDC properties
Related scenario

tIngresClose

tIngresClose properties
Related scenario

tIngresCommit

tIngresCommit Properties
Related scenario

tIngresConnection

tIngresConnection Properties
Related scenarios

tIngresInput

tIngresInput properties
Related scenarios

tIngresOutput

tIngresOutput properties
Related scenarios

tIngresOutputBulk

tIngresOutputBulk properties
Related scenarios

tIngresOutputBulkExec

tIngresOutputBulkExec properties
Scenario: Loading data to a table in the Ingres DBMS
Related scenarios

tIngresRollback

tIngresRollback properties
Related scenarios

tIngresRow properties
Related scenarios

tNetezzaBulkExec

tNetezzaBulkExec properties
Related scenarios

tNetezzaClose

tNetezzaClose properties
Related scenario

tNetezzaCommit

tNetezzaCommit Properties
Related scenario

tNetezzaConnection

tNetezzaConnection Properties
Related scenarios

tNetezzaInput

tNetezzaInput properties
Related scenarios

tNetezzaNzLoad

tNetezzaNzLoad properties
Related scenario

tNetezzaOutput

tNetezzaOutput properties
Related scenarios

tNetezzaRollback

tNetezzaRollback properties
Related scenarios

tNetezzaRow

tNetezzaRow properties
Related scenarios

tParAccelBulkExec

tParAccelBulkExec Properties
Related scenarios

tParAccelClose

tParAccelClose properties
Related scenario

tParAccelCommit

tParAccelCommit Properties
Related scenario

tParAccelConnection

tParAccelConnection Properties
Related scenario

tParAccelInput

tParAccelInput properties
Related scenarios

tParAccelOutput

tParAccelOutput Properties
Related scenarios

tParAccelOutputBulk

tParAccelOutputBulk properties
Related scenarios

tParAccelOutputBulkExec

tParAccelOutputBulkExec Properties
Related scenarios

tParAccelRollback

tParAccelRollback properties
Related scenario

tParAccelRow

tParAccelRow Properties
Related scenarios

tRedshiftBulkExec

tRedshiftBulkExec properties
Loading/unloading data from/to Amazon S3

tRedshiftClose

tRedshiftClose properties
Related scenario

tRedshiftCommit

tRedshiftCommit properties
Related scenario

tRedshiftConnection

tRedshiftConnection properties
Related scenario

tRedshiftInput

tRedshiftInput properties
Scenario: Handling data with Redshift

tRedshiftOutput

tRedshiftOutput properties
Related scenarios

tRedshiftOutputBulk

tRedshiftOutputBulk properties
Related scenario

tRedshiftOutputBulkExec

tRedshiftOutputBulkExec properties
Related scenario

tRedshiftRollback

tRedshiftRollback properties
Related scenario

tRedshiftRow

tRedshiftRow properties
Related scenarios

tRedshiftUnload

tRedshiftUnload properties
Related Scenario

tTeradataClose

tTeradataClose properties
Related scenario

tTeradataCommit

tTeradataCommit Properties
Related scenario

tTeradataConnection

tTeradataConnection Properties
Related scenario

tTeradataFastExport

tTeradataFastExport Properties
Related scenario

tTeradataFastLoad

tTeradataFastLoad Properties
Related scenario

tTeradataFastLoadUtility

tTeradataFastLoadUtility Properties
Related scenario

tTeradataInput

tTeradataInput Properties
Related scenarios

tTeradataMultiLoad

tTeradataMultiLoad Properties
Related scenario

tTeradataOutput

tTeradataOutput Properties
Related scenarios

tTeradataRollback

tTeradataRollback Properties
Related scenario

tTeradataRow

tTeradataRow Properties
Related scenarios

tTeradataTPTExec

tTeradataTPTExec Properties
Scenario: Loading data into a Teradata database

tTeradataTPTUtility

tTeradataTPTUtility Properties
Related scenario

tTeradataTPump

tTeradataTPump Properties
Scenario: Inserting data into a Teradata database table

tVectorWiseCommit

tVectorWiseCommit Properties
Related scenario

tVectorWiseConnection

tVectorWiseConnection Properties
Related scenario

tVectorWiseInput

tVectorWiseInput Properties
Related scenario

tVectorWiseOutput

tVectorWiseOutput Properties
Related scenario

tVectorWiseRollback

tVectorWiseRollback Properties
Related scenario

tVectorWiseRow

tVectorWiseRow Properties
Related scenario

tVerticaBulkExec

tVerticaBulkExec Properties
Tips and Techniques
Related scenarios

tVerticaClose

tVerticaClose properties
Tips and Techniques
Related scenario

tVerticaCommit

tVerticaCommit Properties
Tips and Techniques
Related scenario

tVerticaConnection

tVerticaConnection Properties
Tips and Techniques
Related scenario

tVerticaInput

tVerticaInput Properties
Tips and Techniques
Related scenarios

tVerticaOutput

tVerticaOutput Properties
Tips and Techniques
Related scenarios

tVerticaOutputBulk

tVerticaOutputBulk Properties
Tips and Techniques
Related scenarios

tVerticaOutputBulkExec

tVerticaOutputBulkExec Properties
Tips and Techniques
Related scenarios

tVerticaRollback

tVerticaRollback Properties
Tips and Techniques
Related scenario

tVerticaRow

tVerticaRow Properties
Tips and Techniques
Related scenario

9. Databases – other components

tCreateTable

tCreateTable Properties
Scenario: Creating new table in a Mysql Database

tDBInput properties
Scenario 1: Displaying selected data from DB table
Scenario 2: Using StoreSQLQuery variable

tDBOutput properties
Scenario: Writing a row to a table in the MySQL database via an ODBC connection

tDBSQLRow properties
Scenario: Resetting a DB auto-increment

tEXAInput properties
Related scenarios

tEXAOutput properties
Related scenario

tEXARow properties
Related scenarios

tEXistConnection

tEXistConnection properties
Related scenarios

tEXistDelete

tEXistDelete properties
Related scenario

tEXistGet properties
Scenario: Retrieve resources from a remote eXist DB server

tEXistList properties
Related scenario

tEXistPut properties
Related scenario

tEXistXQuery

tEXistXQuery properties
Related scenario

tEXistXUpdate

tEXistXUpdate properties
Related scenario

tFirebirdClose

tFirebirdClose properties
Related scenario

tFirebirdCommit

tFirebirdCommit Properties
Related scenario

tFirebirdConnection

tFirebirdConnection properties
Related scenarios

tFirebirdInput

tFirebirdInput properties
Related scenarios

tFirebirdOutput

tFirebirdOutput properties
Related scenarios

tFirebirdRollback

tFirebirdRollback properties
Related scenario

tFirebirdRow

tFirebirdRow properties
Related scenarios

tHSQLDbInput

tHSQLDbInput properties
Related scenarios

tHSQLDbOutput

tHSQLDbOutput properties
Related scenarios

tHSQLDbRow properties
Related scenarios

tInterbaseClose

tInterbaseClose properties
Related scenario

tInterbaseCommit

tInterbaseCommit Properties
Related scenario

tInterbaseConnection

tInterbaseConnection properties
Related scenarios

tInterbaseInput

tInterbaseInput properties
Related scenarios

tInterbaseOutput

tInterbaseOutput properties
Related scenarios

tInterbaseRollback

tInterbaseRollback properties
Related scenarios

tInterbaseRow

tInterbaseRow properties
Related scenarios

tJavaDBInput

tJavaDBInput properties
Related scenarios

tJavaDBOutput

tJavaDBOutput properties
Related scenarios

tJavaDBRow properties
Related scenarios

tJDBCColumnList

tJDBCColumnList Properties
Related scenario

tJDBCClose properties
Related scenario

tJDBCCommit

tJDBCCommit Properties
Related scenario

tJDBCConnection

tJDBCConnection Properties
Related scenario

tJDBCInput properties
tJDBCInput in Talend Map/Reduce Jobs
Related scenarios

tJDBCOutput

tJDBCOutput properties
tJDBCOutput in Talend Map/Reduce Jobs
tJDBCOutput in Talend Storm Jobs
Related scenarios

tJDBCRollback

tJDBCRollback properties
Related scenario

tJDBCRow properties
Related scenarios

tJDBCSP Properties
Related scenario

tJDBCTableList

tJDBCTableList Properties
Related scenario

tLDAPAttributesInput

tLDAPAttributesInput Properties
Related scenario

tLDAPClose properties
Related scenario

tLDAPConnection

tLDAPConnection Properties
Related scenarios

tLDAPInput Properties
Scenario: Displaying LDAP directory’s filtered content

tLDAPOutput

tLDAPOutput Properties
Scenario: Editing data in a LDAP directory

tLDAPRenameEntry

tLDAPRenameEntry properties
Related scenarios

tMaxDBInput

tMaxDBInput properties
Related scenario

tMaxDBOutput

tMaxDBOutput properties
Related scenario

tMaxDBRow properties
Related scenario

tParseRecordSet

tParseRecordSet properties
Related Scenario

tPostgresPlusBulkExec

tPostgresPlusBulkExec properties
Related scenarios

tPostgresPlusClose

tPostgresPlusClose properties
Related scenario

tPostgresPlusCommit

tPostgresPlusCommit Properties
Related scenario

tPostgresPlusConnection

tPostgresPlusConnection Properties
Related scenario

tPostgresPlusInput

tPostgresPlusInput properties
Related scenarios

tPostgresPlusOutput

tPostgresPlusOutput properties
Related scenarios

tPostgresPlusOutputBulk

tPostgresPlusOutputBulk properties
Related scenarios

tPostgresPlusOutputBulkExec

tPostgresPlusOutputBulkExec properties
Related scenarios

tPostgresPlusRollback

tPostgresPlusRollback properties
Related scenarios

tPostgresPlusRow

tPostgresPlusRow properties
Related scenarios

tSAPHanaClose

tSAPHanaClose properties
Related scenario

tSAPHanaCommit

tSAPHanaCommit Properties
Related scenario

tSAPHanaConnection

tSAPHanaConnection properties
Related scenario

tSAPHanaInput

tSAPHanaInput Properties
Related scenario

tSAPHanaOutput

tSAPHanaOutput Properties
Related scenario

tSAPHanaRollback

tSAPHanaRollback properties
Related scenario

tSAPHanaRow

tSAPHanaRow Properties
Related scenario

tSasInput properties
Related scenarios

tSasOutput properties
Related scenarios

tSQLiteClose

tSQLiteClose properties
Related scenario

tSQLiteCommit

tSQLiteCommit Properties
Related scenario

tSQLiteConnection

SQLiteConnection properties
Related scenarios

tSQLiteInput

tSQLiteInput Properties
Scenario: Filtering SQlite data

tSQLiteOutput

tSQLiteOutput Properties
Related Scenario

tSQLiteRollback

tSQLiteRollback properties
Related scenarios

tSQLiteRow Properties
Scenario: Updating SQLite rows
Related scenarios

10. DotNET components

tDotNETInstantiate

tDotNETInstantiate properties
Related scenario

tDotNETRow properties
Scenario: Utilizing .NET in Talend

11. ELT components

tCombinedSQLAggregate

tCombinedSQLAggregate properties
Scenario: Filtering and aggregating table columns directly on the DBMS

tCombinedSQLFilter

tCombinedSQLFilter Properties
Related Scenario

tCombinedSQLInput

tCombinedSQLInput properties
Related scenario

tCombinedSQLOutput

tCombinedSQLOutput properties
Related scenario

tELTGreenplumInput

tELTGreenplumInput properties
Related scenarios

tELTGreenplumMap

tELTGreenplumMap properties
Scenario: Mapping data using a simple implicit join
Related scenarios

tELTGreenplumOutput

tELTGreenplumOutput properties
Related scenarios

tELTHiveInput

tELTHiveInput properties
Related scenario

tELTHiveMap

tELTHiveMap properties
Scenario: Joining table columns and writing them into Hive
Related scenario

tELTHiveOutput

tELTHiveOutput properties
Related scenario

tELTJDBCInput

tELTJDBCInput properties
Related scenarios

tELTJDBCMap

tELTJDBCMap properties
Related scenarios

tELTJDBCOutput

tELTJDBCOutput properties
Related scenarios

tELTMSSqlInput

tELTMSSqlInput properties
Related scenarios

tELTMSSqlMap

tELTMSSqlMap properties
Related scenarios

tELTMSSqlOutput

tELTMSSqlOutput properties
Related scenarios

tELTMysqlInput

tELTMysqlInput properties
Related scenarios

tELTMysqlMap

tELTMysqlMap properties
Scenario 1: Aggregating table columns and filtering
Scenario 2: ELT using an Alias table
Related scenario

tELTMysqlOutput

tELTMysqlOutput properties
Related scenarios

tELTNetezzaInput

tELTNetezzaInput properties
Related scenarios

tELTNetezzaMap

tELTNetezzaMap properties
Related scenarios

tELTNetezzaOutput

tELTNetezzaOutput properties
Related scenarios

tELTOracleInput

tELTOracleInput properties
Related scenarios

tELTOracleMap

tELTOracleMap properties
Scenario: Updating Oracle DB entries
Related scenario

tELTOracleOutput

tELTOracleOutput properties
Scenario: Using the Oracle MERGE function to update and add data simultaneously

tELTPostgresqlInput

tELTPostgresqlInput properties
Related scenarios

tELTPostgresqlMap

tELTPostgresqlMap properties
Related scenarios

tELTPostgresqlOutput

tELTPostgresqlOutput properties
Related scenarios

tELTSybaseInput

tELTSybaseInput properties
Related scenarios

tELTSybaseMap

tELTSybaseMap properties
Related scenarios

tELTSybaseOutput

tELTSybaseOutput properties
Related scenarios

tELTTeradataInput

tELTTeradataInput properties
Related scenarios

tELTTeradataMap

tELTTeradataMap properties
Scenario: Mapping data using a subquery
Related scenarios

tELTTeradataOutput

tELTTeradataOutput properties
Related scenarios

tSQLTemplate

tSQLTemplate properties
Related scenarios

tSQLTemplateAggregate

tSQLTemplateAggregate properties
Scenario: Filtering and aggregating table columns directly on the DBMS

tSQLTemplateCommit

tSQLTemplateCommit properties
Related scenario

tSQLTemplateFilterColumns

tSQLTemplateFilterColumns Properties
Related Scenario

tSQLTemplateFilterRows

tSQLTemplateFilterRows Properties
Related Scenario

tSQLTemplateMerge

tSQLTemplateMerge properties
Scenario: Merging data directly on the DBMS

tSQLTemplateRollback

tSQLTemplateRollback properties
Related scenarios

12. ESB components

tESBConsumer

tESBConsumer properties
Scenario 1: Using tESBConsumer
Scenario 2: Using tESBConsumer with custom SOAP Headers

tESBProviderFault

tESBProviderFault properties
Scenario: Requesting airport names based on country codes

tESBProviderRequest

tESBProviderRequest properties
Scenario: Service sending a message without expecting a response

tESBProviderResponse

tESBProviderResponse properties
Scenario: Returning Hello world response

tRESTClient

tRESTClient properties
Scenario 1: Getting user information by interacting with a RESTful service
Scenario 2: Updating user information by interacting with a RESTful service

tRESTRequest

tRESTRequest properties
Scenario 1: REST service accepting HTTP GET requests and sending responses
Scenario 2: Using URI Query parameters to explore the data of a database
Scenario 3: REST service accepting HTTP POST requests

tRESTResponse

tRESTResponse properties
Related scenario

tRouteFault

tRouteFault properties
Scenario: Getting messages from tRouteFault

tRouteInput

tRouteInput properties
Scenario: Getting messages from a Route

tRouteOutput

tRouteOutput properties
Scenario: Getting messages from tRouteOutput

13. File components

tApacheLogInput

tApacheLogInput properties
Scenario: Reading an Apache access-log file

tCreateTemporaryFile

tCreateTemporaryFile properties
Scenario: Creating a temporary file and writing data in it

tChangeFileEncoding

tChangeFileEncoding Properties
Scenario: Transforming the character encoding of a file

tFileArchive

tFileArchive properties
Scenario: Zip files using a tFileArchive

tFileCompare

tFileCompare properties
Scenario: Comparing unzipped files

tFileCopy Properties
Scenario: Restoring files from bin

tFileDelete

tFileDelete Properties
Scenario: Deleting files

tFileExist Properties
Scenario: Checking for the presence of a file and creating it if it does not exist

tFileInputARFF

tFileInputARFF properties
Scenario: Display the content of a ARFF file

tFileInputDelimited

tFileInputDelimited properties
tFileInputDelimited in Talend Map/Reduce Jobs
Scenario: Delimited file content display
Scenario 2: Reading data from a remote file in streaming mode

tFileInputEBCDIC

tFileInputEBCDIC properties
Scenario: Extracting data from an EBCDIC file

tFileInputExcel

tFileInputExcel properties
Related scenarios

tFileInputFullRow

tFileInputFull Row properties
tFileInputFullRow in Talend Map/Reduce Jobs
Scenario: Reading full rows in a delimited file

tFileInputJSON

tFileInputJSON properties
tFileInputJSON in Talend Map/Reduce Jobs
Scenario 1: Extracting JSON data from a file
Scenario 2: Extracting JSON data from a file using XPath
Scenario 3: Extracting JSON data from a URL

tFileInputLDIF

tFileInputLDIF Properties
Related scenario

tFileInputMail

tFileInputMail properties
Scenario: Extracting key fields from an email

tFileInputMSDelimited

tFileInputMSDelimited properties
Scenario: Reading a multi structure delimited file

tFileInputMSPositional

tFileInputMSPositional properties
Scenario: Reading data from a positional file

tFileInputMSXML

tFileInputMSXML Properties
Scenario: Reading a multi-structure XML file

tFileInputPositional

tFileInputPositional properties
tFileInputPositional in Talend Map/Reduce Jobs
Scenario 1: From Positional to XML file
Scenario 2: Handling a positional file based on a dynamic schema

tFileInputProperties

tFileInputProperties properties
Scenario: Reading and matching the keys and the values of different .properties files and outputting the results in a glossary

tFileInputRaw

tFileInputRaw properties
Related Scenario

tFileInputRegex

tFileInputRegex properties
Scenario: Regex to Positional file

tFileList properties
Scenario 1: Iterating on a file directory
Scenario 2: Finding duplicate files between two folders

tFileOutputARFF

tFileOutputARFF properties
Related scenario

tFileOutputDelimited

tFileOutputDelimited properties
tFileOutputDelimited in Talend Map/Reduce Jobs
Scenario 1: Writing data in a delimited file
Scenario 2: Utilizing Output Stream to save filtered data to a local file

tFileOutputEBCDIC

tFileOutputEBCDIC properties
Scenario: Creating an EBCDIC file using two delimited files

tFileOutputExcel

tFileOutputExcel Properties
Related scenario

tFileOutputJSON

tFileOutputJSON properties
tFileOutputJSON in Talend Map/Reduce Jobs
Scenario: Writing a JSON structured file

tFileOutputLDIF

tFileOutputLDIF Properties
Scenario: Writing DB data into an LDIF-type file

tFileOutputMSDelimited

tFileOutputMSDelimited properties
Related scenarios

tFileOutputMSPositional

tFileOutputMSPositional properties
Related scenario

tFileOutputMSXML

tFileOutputMSXML Properties
Related scenario

tFileOutputPositional

tFileOutputPositional Properties
tFileOutputPositional in Talend Map/Reduce Jobs
Related scenario

tFileOutputProperties

tFileOutputProperties properties
Related scenarios

tFileOutputRaw

tFileOutputRaw properties
Related Scenario

tFileProperties

tFileProperties Properties
Scenario: Displaying the properties of a processed file

tFileRowCount

tFileRowCount properties
Scenario: Writing a file to MySQL if the number of its records matches a reference value

tFileTouch properties
Related scenario

tFileUnarchive

tFileUnarchive Properties
Related scenario

tGPGDecrypt

tGPGDecrypt Properties
Scenario: Decrypt a GnuPG-encrypted file and display its content

tNamedPipeClose

tNamedPipeClose properties
Related scenario

tNamedPipeOpen

tNamedPipeOpen properties
Related scenario

tNamedPipeOutput

tNamedPipeOutput properties
Scenario: Writing and loading data through a named-pipe

tPivotToColumnsDelimited

tPivotToColumnsDelimited Properties
Scenario: Using a pivot column to aggregate data

14. FileScale components

tFSAggregate

tFSAggregate properties
Scenario: Aggregating data from a large file

tFSCheck Properties
Related Scenarios

tFSCode Properties
Related Scenarios

tFSFilterColumns

tFSFilterColumns Properties
Scenario: Combining filtering and sorting processes in a large scale file

tFSFilterRows

tFSFilterRows Properties
Related Scenarios

tFSJoin properties
Scenario: Combining data from two columns and outputting the joined and rejected data

tFSPartitionFile

tFSPartitionFile Properties
Scenario: Partitioning mass data based on the hash method before writing it to an output file

tFSSort Properties
Scenario: Sorting entries in a large scale file

tFSTransform

tFSTransform Properties
Related Scenarios

tFSUnique Properties
Related Scenarios

15. Internet components

tFileFetch properties
Scenario 1: Fetching data through HTTP
Scenario 2: Reusing stored cookie to fetch files through HTTP
Related scenario

tFTPConnection

tFTPConnection properties
Related scenarios

tFTPDelete properties
Related scenario

tFTPFileExist

tFTPFileExist properties
Related scenario

tFTPFileList

tFTPFileList properties
Scenario: Iterating on a remote directory

tFTPFileProperties

tFTPFileProperties Properties
Related scenario

tFTPGet properties
Related scenario

tFTPPut properties
Scenario: Putting files on a remote FTP server

tFTPRename Properties
Scenario: Renaming a file located on the FTP server
Related scenario

tFTPTruncate

tFTPTruncate properties
Related scenario

tHttpRequest

tHttpRequest properties
Scenario 1: Sending a HTTP request to the server and saving the response information to a local file
Scenario 2: Sending a POST request from a local JSON file

tJBossESBInput

tJBossESBInput Properties
Related scenario

tJBossESBOutput

tJBossESBOutput Properties
Related scenario

tJMSInput properties
Related scenarios

tJMSOutput properties
Scenario: Enqueuing/dequeuing a message on the ActiveMQ server

tMicrosoftMQInput

tMicrosoftMQInput Properties
Scenario: Writing and fetching queuing messages from Microsoft message queue

tMicrosoftMQOutput

tMicrosoftMQOutput Properties
Related scenario

tMomCommit Properties
Related scenario

tMomConnection

tMomConnection Properties
Related scenario

tMomInput Properties
Scenario 1: Asynchronous communication via a MOM server
Scenario 2: Transmitting XML files via a MOM server

tMomMessageIdList

tMomMessageIdList Properties
Related scenario

tMomOutput Properties
Related scenario

tMomRollback

tMomRollback properties
Related scenario

tPetalsInput

tPetalsInput Properties
Related cenarios

tPetalsOutput

tPetalsOutput Properties
Related scenario

tPOP properties
Scenario: Retrieving a selection of email messages from an email server

tREST properties
Scenario: Creating and retrieving data by invoking REST Web service

tRSSInput Properties
Scenario: Fetching frequently updated blog entries.

tRSSOutput Properties
Scenario 1: Creating an RSS flow and storing files on an FTP server
Scenario 2: Creating an RSS flow that contains metadata
Scenario 3: Creating an ATOM feed XML file

tSCPClose Properties
Related scenario

tSCPConnection

tSCPConnection properties
Related scenarios

tSCPDelete properties
Related scenario

tSCPFileExists

tSCPFileExists properties
Handling a file using SCP

tSCPFileList

tSCPFileList properties
Related scenario

tSCPGet properties
Related scenario

tSCPPut properties
Related scenario

tSCPRename properties
Related scenario

tSCPTruncate

tSCPTruncate properties
Related scenario

tSendMail Properties
Scenario: Email on error

tSetKerberosConfiguration

tSetKerberosConfiguration properties
Related scenarios

tSetKeystore

tSetKeystore properties
Scenario: Extracting customer information from a private WSDL file

tSetProxy properties
Related scenarios

tSocketInput

tSocketInput properties
Scenario: Passing on data to the listening port

tSocketOutput

tSocketOutput properties
Related Scenario

tSOAP properties
Scenario 1: Fetching the country name information using a Web service
Scenario 2: Using a SOAP message from an XML file to get country name information and saving the information to an XML file

tSVNLogInput

tSVNLogInput properties
Scenario: Retrieving a log message from an SVN repository

tWebService

tWebService properties
Scenario: Getting country names through a Web service

tWebServiceInput

tWebServiceInput Properties
Scenario: Getting country names through a Web service

tXMLRPCInput

tXMLRPCInput Properties
Scenario: Guessing the State name from an XMLRPC

16. Logs & Errors components

tAssert Properties
Scenario 1: Viewing product orders status (on a daily basis) against a benchmark number
Scenario 2: Setting up the assertive condition for a Job execution

tAssertCatcher

tAssertCatcher Properties
Related scenarios

tChronometerStart

tChronometerStart Properties
Related scenario

tChronometerStop

tChronometerStop Properties
Scenario: Measuring the processing time of a subjob and part of a subjob

tDie properties
Related scenarios

tFlowMeter Properties
Related scenario

tFlowMeterCatcher

tFlowMeterCatcher Properties
Scenario: Catching flow metrics from a Job

tLogCatcher

tLogCatcher properties
Scenario 1: warning & log on entries
Scenario 2: Log & kill a Job

tLogRow properties
Related scenarios

tStatCatcher

tStatCatcher Properties
Scenario: Displaying the statistics log of Job execution

tWarn Properties
Related scenarios

17. MapReduce components

tAvroInput properties
Scenario: Filtering Avro format employee data

tAvroOutput

tAvroOutput properties
Related scenario

tFileInputParquet

tFileInputParquet properties
Related scenario

tFileOutputParquet

tFileOutputParquet properties
Related scenario

tGlobalVarLoad

tGlobalVarLoad properties
Scenario: selecting the salary records above the average using a Map/Reduce Job

tMahoutClustering

tMahoutClustering properties
Scenario: Grouping customer numerical data into clusters on HDFS

tS3Input properties
Related scenario

tS3Output properties
Related scenario

18. Misc group components

tAddLocationFromIP

tAddLocationFromIP Properties
Scenario: Identifying a real-world geographic location of an IP

tBufferInput

tBufferInput properties
Scenario: Retrieving bufferized data

tBufferOutput

tBufferOutput properties
Scenario 1: Buffering data
Scenario 2: Buffering output data on the webapp server
Scenario 3: Calling a Job with context variables from a browser
Scenario 4: Calling a Job exported as Webservice in another Job

tContextDump

tContextDump properties
Related Scenario

tContextLoad

tContextLoad properties
Scenario: Reading data from different MySQL databases using dynamically loaded connection parameters

tFixedFlowInput

tFixedFlowInput properties
Related scenarios

tMemorizeRows

tMemorizeRows properties
Scenario: Counting the occurrences of different ages

tMsgBox properties
Scenario: ‘Hello world!’ type test

tRowGenerator

tRowGenerator properties
Scenario: Generating random java data

tServerAlive

tServerAlive Properties
Scenario: Validating the status of the connection to a remote host

19. Orchestration components

tCollector Properties
Related scenario

tDepartitioner

tDepartitioner Properties
Related scenario

tFlowToIterate

tFlowToIterate Properties
Scenario: Transforming data flow to a list

tForeach Properties
Scenario: Iterating on a list and retrieving the values

tInfiniteLoop

tInfiniteLoop Properties
Related scenario

tIterateToFlow

tIterateToFlow Properties
Scenario: Transforming a list of files as data flow

tLoop Properties
Scenario: Job execution in a loop

tParallelize

tParallelize Properties
Scenario: Parallelize/synchronize subjobs execution

tPartitioner

tPartitioner Properties
Scenario: sorting the customer data of large size in parallel

tPostjob Properties
Related scenarios

tPrejob properties
Scenario: Handling files before and after the execution of a data Job

tRecollector

tRecollector Properties
Related scenario

tReplicate Properties
Scenario: Replicating a flow and sorting two identical flows respectively

tSleep Properties
Related scenarios

tUnite Properties
Scenario: Iterate on files and merge the content

tWaitForFile

tWaitForFile properties
Scenario 1: Waiting for a file to be created and stopping the iteration loop after a message is triggered
Scenario 2: Waiting for a file to be created and continuing the iteration loop after a message is triggered

tWaitForSocket

tWaitForSocket properties
Related scenario

tWaitForSqlData

tWaitForSqlData properties
Scenario: Waiting for insertion of rows in a table

20. Processing components

tAggregateRow

tAggregateRow properties
Scenario 1: Aggregating values and sorting data
Scenario 2: Aggregating values based on dynamic schema

tAggregateSortedRow

tAggregateSortedRow properties
Related scenario

tBRMS properties
Scenario: Applying business rules to an input flow to filter relevant data

tConvertType

tConvertType properties
Scenario 1: Converting java types
Scenario 2: Converting java types using Map/Reduce components

tDenormalize

tDenormalize Properties
Scenario 1: Denormalizing on one column
Scenario 2: Denormalizing on multiple columns

tDenormalizeSortedRow

tDenormalizeSortedRow properties
Scenario: Regrouping sorted rows

tExternalSortRow

tExternalSortRow properties
Related scenario

tExtractDelimitedFields

tExtractDelimitedFields properties
tExtractDelimitedFields in Talend Map/Reduce Jobs
Scenario: Extracting fields from a comma-delimited file

tExtractDynamicFields

tExtractDynamicFields properties
Related scenarios

tExtractEBCDICFields

tExtractEBCDICFields properties
Related scenario

tExtractEDIField

tExtractEDIField properties
Scenario: Extracting data from an EDIFACT message

tExtractJSONFields

tExtractJSONFields properties
Scenario 1: Retrieving error messages while extracting data from JSON fields
Scenario 2: Collecting data from your favorite online social network

tExtractPositionalFields

tExtractPositionalFields properties
Related scenario

tExtractRegexFields

tExtractRegexFields properties
Scenario: Extracting name, domain and TLD from e-mail addresses

tFilterColumns

tFilterColumns Properties
Related Scenario

tFilterRow Properties
Scenario 1: Filtering a list of names using simple conditions
Scenario 2: Filtering a list of names through different logical operations

tHMap properties
Scenario 1: Using Talend Data Mapper metadata
Scenario 2: Using Talend Data Integration metadata
Scenario 3: Transforming from a Data Integration schema to a complex content schema
Scenario 4: Handling errors

tJoin properties
Scenario 1: Doing an exact match on two columns and outputting the main and rejected data
Scenario 2: Matching input data against a reference file based on a dynamic column

tMap properties
Scenario 1: Mapping data using a filter and a simple explicit join
Scenario 2: Mapping data using inner join rejections
Scenario 3: Cascading join mapping
Scenario 4: Advanced mapping using filters, explicit joins and rejections
Scenario 5: Advanced mapping with filters and different rejections
Scenario 6: Advanced mapping with lookup reload at each row
Scenario 7: Mapping with join output tables

tNormalize Properties
Scenario 1: Normalizing data
Scenario 2: Normalizing data using Map/Reduce components

tReplace Properties
Scenario 1: Multiple replacements and column filtering
Scenario 2: Replacing values and filtering columns using Map/Reduce components

tRules properties
Scenario 1: Extracting client data according to business rules stored in an external file
Scenario 2: Extracting zip codes using DRL rules you create from the Studio

tSampleRow properties
Scenario: Filtering rows and groups of rows

tSortRow properties
Scenario 1: Sorting entries
Scenario 2: Sorting entries based on dynamic schema

tSplitRow properties
Scenario 1: Splitting one row into two rows

tWriteDynamicFields

tWriteDynamicFields properties
Scenario 1: Create a dynamic column and extract its content
Scenario 2: Extracting the contents of a dynamic column via tJavaRow

tWriteJSONField

tWriteJSONField properties
Scenario: Writing flat data into JSON fields
Related Scenarios

tXMLMap properties
Scenario 1: Mapping and transforming XML data
Scenario 2: Launching a lookup in a second XML flow to join complementary data
Scenario 3: Mapping data using a filter
Scenario 4: Catching the data rejected by lookup and filter
Scenario 5: Mapping data using a group element
Scenario 6: Classing the output data with aggregate element
Scenario 7: Restructuring products data using multiple loop elements

21. Storm components

tKafkaInput

tKafkaInput properties
Scenario: analyzing people’s activities using a Storm topology

22. System components

tRunJob Properties
Scenario 1: Executing a child Job
Scenario 2: Running a list of child Jobs dynamically
Scenario 3: Propagating the buffered output data from the child Job to the parent Job

tSetEnv Properties
Scenario: Modifying a variable during a Job execution

tSSH Properties
Scenario: Remote system information display via SSH

tSystem Properties
Scenario: Echo ‘Hello World!’

23. Talend MDM components

tMDMBulkLoad

tMDMBulkLoad properties
Scenario: Loading records into a business entity

tMDMClose properties
Related scenario

tMDMCommit properties
Related scenario

tMDMConnection

tMDMConnection properties
Related scenario

tMDMDelete properties
Scenario: Deleting master data from an MDM Hub

tMDMInput properties
Scenario: Reading master data in an MDM hub

tMDMOutput properties
Scenario: Writing master data in an MDM hub

tMDMReceive

tMDMReceive properties
Scenario: Extracting information from an MDM record in XML

tMDMRollback

tMDMRollback properties
Related scenario

tMDMRouteRecord

tMDMRouteRecord properties
Scenario: Routing a record to Event Manager

tMDMSP Properties
Scenario: Executing a stored procedure in the MDM Hub

tMDMTriggerInput

tMDMTriggerInput properties
Scenario: Exchanging the event information about an MDM record

tMDMTriggerOutput

tMDMTriggerOutput properties
Related scenario

tMDMViewSearch

tMDMViewSearch properties
Scenario: Retrieving records from an MDM hub via an existing view

tStewardshipTaskDelete

tStewardshipTaskDelete properties
Scenario: Deleting tasks from the Data Stewardship Console

tStewardshipTaskInput

tStewardshipTaskInput properties
Scenario: Reading data in the stewardship console database

tStewardshipTaskOutput

tStewardshipTaskOutput properties
Scenario: Writing data records in the stewardship console database

24. Technical components

tHashInput Properties
Scenario 1: Reading data from the cache memory for high-speed data access
Scenario 2: Clearing the memory before loading data to it in case an iterator exists in the same subjob

tHashOutput

tHashOutput Properties
Related scenarios

25. XML components

tAdvancedFileOutputXML

tAdvancedFileOutputXML properties
Scenario: Creating an XML file using a loop

tDTDValidator

tDTDValidator Properties
Scenario: Validating XML files

tEDIFACTtoXML

tEDIFACTtoXML Properties
Scenario: From EDIFACT to XML

tExtractXMLField

tExtractXMLField properties
Scenario 1: Extracting XML data from a field in a database table
Scenario 2: Extracting correct and erroneous data from an XML field in a delimited file

tFileInputXML

tFileInputXML Properties
tFileInputXML in Talend Map/Reduce Jobs
Scenario 1: Reading and extracting data from an XML structure
Scenario 2: Extracting erroneous XML data via a reject flow

tFileOutputXML

tFileOutputXML properties
tFileOutputXML in Talend Map/Reduce Jobs
Related scenarios

tWriteXMLField

tWriteXMLField properties
Scenario: Extracting the structure of an XML file and inserting it into the fields of a database table

tXSDValidator

tXSDValidator Properties
Scenario: Validating data flows against an XSD file

tXSLT Properties
Scenario: Transforming XML to html using an XSL stylesheet

Document get from Talend https://help.talend.com

Thank you for watching.

Docs 5.x

Document Document ESB Version 5.6.3 ESB Document 5.x Talend Document Talend Document Version ESB 5.6.3 Talend Help Talend Help ESB Talend Open Studio for ESB

Subscribe

0 Comments

Inline Feedbacks

View all comments

0

Would love your thoughts, please comment.x

()