Java
Perl
Business / CentricCRM
tCentricCRMInput
Inputs from a CentricCRM database
Since 2.1.0
tCentricCRMOutput
Outputs to a CentricCRM database
Since 2.1.0
Business / Microsoft AX
tMSAXInput
Reads a Microsoft AX server based on an SQL query
Since 2.3.0
tMSAXOutput
Writes data to a Microsoft AX server
Since 2.3.0
Business / Salesforce
tSalesforceInput
Inputs from the Salesforce
Since 2.1.0
tSalesforceOutput
Outputs to the Salesforce
Since 2.1.0
Business / SAP
tSAPInput
Extracts data from an SAP system
Since 3.0.0
tSAPOutput
Outputs to an SAP system
Since 3.0.0
Business / SugarCRM
tSugarCRMInput
Inputs from the SugarCRM
Since 2.1.0
tSugarCRMOutput
Outputs to the SugarCRM
Since 2.1.0
Business / VtigerCRM
tVtigerCRMInput
Inputs from the VtigerCRM
Since 2.2.0
tVtigerCRMOutput
Outputs to the VtigerCRM
Since 2.2.0
Business Intelligence / Charts
tLineChart
Generates line charts as a PNG image
Since 2.3.0
Business Intelligence / DB SCD
tDB2SCD
Slowly Changing Dimension algorithm for DB2
Since 2.2.0
tDB2SCDELT
Slowly Changing Dimension algorithm for DB2, ELT Mode
Since 2.4.0
Since 3.0.0
tGreenplumSCD
Slowly Changing Dimension algorithm for Greenplum
Since 3.0.0
tIngresSCD
Slowly Changing Dimension algorithm for Ingres
Since 2.2.0
tMSSqlSCD
Slowly Changing Dimension algorithm for MS SQL
Since 2.2.0
tMysqlSCD
Slowly Changing Dimension algorithm for MySQL
Since 2.1.0
Since 2.2.0
tMysqlSCDELT
Slowly Changing Dimension algorithm for MySQL, ELT Mode
Since 2.4.0
Since 2.4.0
tOracleSCD
Slowly Changing Dimension algorithm for Oracle
Since 2.1.0
Since 2.2.0
tOracleSCDELT
Slowly Changing Dimension algorithm for Oracle, ELT Mode
Since 2.4.0
Since 2.4.0
tParAccelSCD
Slowly Changing Dimension algorithm for ParAccel
Since 3.0.0
tPostgresPlusSCD
Slowly Changing Dimension algorithm for PostgrePlus
Since 2.4.0
tPostgresPlusSCDELT
Slowly Changing Dimension algorithm for PostgresPlus, ELT Mode
Since 2.4.0
Since 3.0.0
tPostgresqlSCD
Slowly Changing Dimension algorithm for Postgresql
Since 2.3.0
tPostgresqlSCDELT
Slowly Changing Dimension algorithm for PostgreSQL, ELT Mode
Since 2.4.0
Since 3.0.0
tSybaseSCD
Slowly Changing Dimension algorithm for Sybase
Since 2.2.0
tSybaseSCDELT
Slowly Changing Dimension algorithm for Sybase, ELT Mode
Since 2.4.0
Since 3.0.0
Business Intelligence / Jasper
tJasperOutput
Outputs a report
Since 2.2.0
tJasperOutputExec
Outputs a report
Since 2.2.0
Business Intelligence / OLAP Cube
tMondrianInput
Executes an MDX query on Mondrian and retrieves flattened data
Since 2.2.0
tPaloOutput
Writes data to Jedox Palo
Since 2.3.0
Custom Code
tGroovy
Fills manually a groovy script of a component
Since 2.3.0
tGroovyFile
Executes a Groovy script file
Since 2.2.0
tJava
Allows to enter manually the start Java-code part of a component
Since 2.0.0
tJavaFlex
Allows to enter manually the start, main, and end Java-code parts of a component
Since 2.0.0
tJavaRow
Allows to enter manually the main Java-code part of a component
Since 2.0.0
tLibraryLoad
Loads libraries
Since 2.3.0
Since 2.3.0
tSetGlobalVar
Sets a list of global variables
Since 2.3.0
Since 2.3.0
Data Quality
tAddCRCRow
Adds a CRC column for all rows of a flow
Since 2.0.0
Since 2.1.0
tFuzzyMatch
Compares a column from the main flow with a reference column from the lookup flow for any inconsistencies
Since 2.1.0
Since 2.1.0
tIntervalMatch
Returns a value based on a Join relation, corresponding to a min and max values
Since 2.1.0
Since 2.1.0
tParseAddress
Manipulates geographical addresses
Since 2.4.0
tParseName
Manipulates a person's name
Since 2.4.0
tReplaceList
Replaces strings with a dynamic replacement list
Since 2.3.0
Since 2.3.0
tSchemaComplianceCheck
Checks columns from a schema
Since 2.3.0
Since 2.2.0
tUniqRow
Makes a data flow unique based on the key set on the schema
Since 1.1.0
Since 2.0.0
Databases
tCreateTable
Creates a table defined with columns in a schema
Since 2.4.0
Since 2.1.0
tParseRecordSet
Parses a set of records
Since 2.3.0
Databases / Access
tAccessInput
Reads an Access table and extracts fields based on an SQL query
Since 2.1.0
tAccessOutput
Inserts or updates lines into an Access table
Since 2.1.0
tAccessRow
Executes an SQL query at each of Talend flow's iterations
Since 2.1.0
Databases / AS400
tAS400Commit
Commits all transactions not already commited in the selected AS400 connection
Since 2.3.0
tAS400Connection
Creates a connection to an AS400 database
Since 2.3.0
tAS400Input
Reads a table and extracts fields based on an SQL query
Since 2.2.0
tAS400Output
Inserts or updates lines into a table
Since 2.2.0
tAS400Rollback
Rollbacks all transactions not already commited in the selected AS400 Connection
Since 2.3.0
tAS400Row
Executes an SQL query at each of Talend flow's iterations
Since 2.2.0
Databases / DB Generic
tDBInput
Reads a DB and extracts fields based on an SQL query
Since 1.0.0
Since 2.0.0
tDBOutput
Inserts or updates lines into a DB table
Since 1.0.0
Since 2.0.0
tDBSQLRow
Executes an SQL query at each of Talend flow's iterations
Since 1.0.0
Since 2.0.0
Databases / DB JDBC
tJDBCColumnList
Iterates on all column names in a specified table from a defined DB connection
Since 3.0.0
tJDBCCommit
Commits all transactions not already commited in a selected JDBC connection
Since 2.4.0
tJDBCConnection
Creates a connection to a JDBC database
Since 2.4.0
tJDBCInput
Reads a DB table and extracts fields based on an SQL query
Since 2.2.0
tJDBCOutput
Inserts or updates lines into a DB table
Since 2.2.0
tJDBCRollback
Rollbacks all transactions not already commited in a selected JDBC connection
Since 2.4.0
tJDBCRow
Executes an SQL query at each of Talend flow's iterations
Since 2.2.0
tJDBCSP
Calls a DB stored procedure
Since 2.2.0
tJDBCTableList
Iterates on a set of table names from a defined DB connection
Since 3.0.0
Databases / DB2
tDB2Commit
Commits all transactions not already commited in a selected DB2 connection
Since 2.4.0
Since 2.4.0
tDB2Connection
Creates a connection to a DB2 database
Since 2.4.0
Since 2.4.0
tDB2Input
Reads a DB2 table and extracts fields based on an SQL query
Since 2.0.0
Since 2.0.0
tDB2Output
Inserts or updates lines into a DB2 table
Since 2.0.0
Since 2.0.0
tDB2Rollback
Rollbacks all transactions not already commited in a selected DB2 connection
Since 2.4.0
Since 2.4.0
tDB2Row
Executes an SQL query at each of Talend flow's iterations
Since 2.0.0
Since 2.0.0
tDB2SCD
Slowly Changing Dimension algorithm for DB2
Since 2.2.0
tDB2SCDELT
Slowly Changing Dimension algorithm for DB2, ELT Mode
Since 2.4.0
Since 3.0.0
tDB2SP
Calls a DB2 stored procedure
Since 2.2.0
Databases / FireBird
tFirebirdCommit
Commits all transactions not already commited in a selected Firebird connection
Since 2.4.0
Since 3.0.0
tFirebirdConnection
Creates a connection to a Firebird DB
Since 2.4.0
Since 3.0.0
tFirebirdInput
Reads a FireBird table and extracts fields based on an SQL query
Since 2.4.0
Since 2.1.0
tFirebirdOutput
Inserts or updates lines into a Firebird table
Since 2.4.0
Since 2.1.0
tFirebirdRollback
Rollbacks all transactions not already commited in a selected Firebird connection
Since 2.4.0
Since 3.0.0
tFirebirdRow
Executes an SQL query at each of Talend flow's iterations
Since 2.4.0
Since 2.1.0
Databases / Greenplum
tGreenplumBulkExec
Loads data efficiently from a file
Since 3.0.0
tGreenplumCommit
Commits all transactions not already commited in a selected Greenplum connection
Since 3.0.0
tGreenplumConnection
Creates a connection to a Greenplum DB
Since 3.0.0
tGreenplumInput
Reads a Greenplum table and extracts fields based on an SQL query
Since 3.0.0
tGreenplumOutput
Inserts or updates lines in a Greenplum table
Since 3.0.0
tGreenplumOutputBulk
Writes a temporary file to feed the Greenplum DB
Since 3.0.0
tGreenplumOutputBulkExec
Efficiently loads data from a flow
Since 3.0.0
tGreenplumRollback
Rollbacks all transactions not already commited in a selected Greenplum connection
Since 3.0.0
tGreenplumRow
Executes an SQL query at each of Talend flow's iterations
Since 3.0.0
tGreenplumSCD
Slowly Changing Dimension algorithm for Greenplum
Since 3.0.0
Databases / HSQLDb
tHSQLDbInput
Reads an HSQLDb table and extracts fields based on an SQL query
Since 2.1.0
tHSQLDbOutput
Inserts or updates lines into an HSQLDb table
Since 2.1.0
tHSQLDbRow
Executes an SQL query at each of Talend flow's iterations
Since 2.1.0
Databases / Informix
tInformixInput
Reads an Informix table and extracts fields based on an SQL query
Since 2.1.0
tInformixOutput
Inserts or updates lines into an Informix table
Since 2.1.0
tInformixRow
Executes an SQL query at each of Talend flow's iterations
Since 2.1.0
Databases / Ingres
tIngresCommit
Commits all transactions not already commited in a selected Ingres connection
Since 3.0.0
tIngresConnection
Reads an Ingres table and extracts fields based on an SQL query
Since 3.0.0
tIngresInput
Reads an Ingres table and extracts fields based on an SQL query
Since 2.1.0
tIngresOutput
Inserts or updates lines into an Ingres table
Since 2.1.0
tIngresRow
Executes an SQL query at each of Talend flow's iterations
Since 2.1.0
tIngresSCD
Slowly Changing Dimension algorithm for Ingres
Since 2.2.0
Databases / Interbase
tInterbaseCommit
Commits all transactions not already commited in a selected Interbase connection
Since 2.4.0
Since 2.4.0
tInterbaseConnection
Creates a connection to an Interbase DB
Since 2.4.0
tInterbaseInput
Reads an Interbase table and extracts fields based on an SQL query
Since 2.4.0
Since 2.1.0
tInterbaseOutput
Inserts or updates lines into an Interbase table
Since 2.4.0
Since 2.1.0
tInterbaseRollback
Rollbacks all transactions not already commited in a selected Interbase connection
Since 2.4.0
Since 2.4.0
tInterbaseRow
Executes an SQL query at each of Talend flow's iterations
Since 2.4.0
Since 2.1.0
Databases / JavaDB
tJavaDBInput
Reads a JavaDB table and extracts fields based on an SQL query
Since 2.1.0
tJavaDBOutput
Inserts or updates lines into a JavaDB table
Since 2.1.0
tJavaDBRow
Executes an SQL query at each of Talend flow's iterations
Since 2.1.0
Databases / LDAP
tLDAPInput
Reads entries form an LDAP server
Since 2.2.0
tLDAPOutput
Writes a message to an LDAP server
Since 2.2.0
Databases / MaxDB
tMaxDBInput
Reads a table and extracts fields based on an SQL query
Since 2.4.0
tMaxDBOutput
Inserts or updates lines into a table
Since 2.4.0
tMaxDBRow
Executes an SQL query at each of Talend flow's iterations
Since 2.4.0
Databases / MS SQL Server
tMSSqlBulkExec
Loads efficiently data from a file
Since 2.1.0
tMSSqlColumnList
Iterates on all column names in a specified table from a defined DB connection
Since 3.0.0
tMSSqlCommit
Commits all transactions not already commited in a selected MSSQL connection
Since 2.3.0
tMSSqlConnection
Creates a connection to an MSSQL database
Since 2.3.0
tMSSqlInput
Reads an MSSQL table and extracts fields based on an SQL query
Since 2.0.0
Since 2.0.0
tMSSqlLastInsertId
Fetches the last_insert_id from a selected MSSQL connection
Since 3.0.0
tMSSqlOutput
Inserts or updates lines into an MSSQL table
Since 2.0.0
Since 2.0.0
tMSSqlOutputBulk
Writes a prepared file for MS-SQL bulk load
Since 2.1.0
tMSSqlOutputBulkExec
Builds the MSSql format bulk file and asks the database defined to upload the bulk file
Since 2.1.0
tMSSqlRollback
Rollbacks all transactions not already commited in a selected MSSQL connection
Since 2.3.0
tMSSqlRow
Executes an SQL query at each of Talend flow's iterations
Since 2.0.0
Since 2.0.0
tMSSqlSCD
Slowly Changing Dimension algorithm for MS SQL
Since 2.2.0
tMSSqlSP
Calls an MS SQL server stored procedure
Since 2.2.0
tMSSqlTableList
Iterates on a set of table names from a defined DB connection
Since 3.0.0
Databases / MySQL
tMysqlBulkExec
Asks a MySQL database to upload a bulk file into the database defined
Since 2.0.0
Since 2.0.0
tMysqlColumnList
Iterates on all column names in a specified table from a defined DB connection
Since 3.0.0
tMysqlCommit
Commits all transactions not already commited in a selected MySQL connection
Since 2.1.0
Since 2.1.0
tMysqlConnection
Creates a connection to a MySQL database
Since 2.1.0
Since 2.1.0
tMysqlInput
Reads a MySQL table and extracts fields based on an SQL query
Since 2.0.0
Since 2.0.0
tMysqlLastInsertId
Fetchs the last_insert_id from a selected MySQL connection
Since 2.4.0
Since 2.4.0
tMysqlOutput
Inserts or updates lines into a MySQL table
Since 2.0.0
Since 2.0.0
tMysqlOutputBulk
Builds a MySQL format bulk file
Since 1.1.0
Since 2.0.0
tMysqlOutputBulkExec
Builds a MySQL format bulk file and asks the database defined to upload the bulk file
Since 1.1.0
Since 2.0.0
tMysqlOutputUpdateBulkExec
Loads in bulk a temporary table from data flow and performs a single update query using an SQL join
Since 2.3.0
tMysqlRollback
Rollbacks all transactions not already commited in a selected MySQL Connection
Since 2.1.0
Since 2.1.0
tMysqlRow
Executes an SQL query at each of Talend flow's iterations
Since 2.0.0
Since 2.0.0
tMysqlSCD
Slowly Changing Dimension algorithm for MySQL
Since 2.1.0
Since 2.2.0
tMysqlSCDELT
Slowly Changing Dimension algorithm for MySQL, ELT Mode
Since 2.4.0
Since 2.4.0
tMysqlSP
Calls a MySQL stored procedure
Since 2.4.0
Since 2.2.0
tMysqlTableList
Iterates on a set of table names from a defined DB connection
Since 3.0.0
tMysqlUpdateBulkExec
Loads in bulk a temporary table from a file and performs a single update query using an SQL join
Since 2.3.0
Databases / Netezza
tNetezzaInput
Reads a Netezza table and extracts fields based on an SQL query
Since 3.0.0
tNetezzaOutput
Inserts or updates lines in a Netezza table
Since 3.0.0
Databases / Oracle
tOracleBulkExec
Loads efficiently data from a file