• Feature 2299 new component tPivotOutputDelimited fills a schema dynamically created based on input data content.
  • Feature 1675 tFileInputPositionnal component can optionally trim (left an right) all columns by itself, no need of a dedicated tPerlRow for this task.
  • Feature 491 new component tPostgresqlOutputBulkExec (tPOBE) performs fast inserts in a PostgreSQL database. Contrary to tMysqlOutputBulkExec, tPOBE does not write a temporary file before loading it into the database. Feature 2582 adds components tPostgresqlOutputBulk (tPOB) and tPostgresqlBulkExec (tPBE) with the same behaviour as MySQL equivalents : tPOB writes a delimited file prepared to be loaded in a PostgreSQL table, tPBE load a file in a table.
  • Feature 2243 new component tSchemaComplianceCheck can be used anywhere in your data flow. If the row does not match the constraints specified in the schema, the row goes to the reject output.
  • Feature 2274 tFileInputCSV merged into tFileInputDelimited and Feature 1804 tFileOutputCSV merged into tFileOutputDelimited. We have a single tFile*Delimited with extra options related to the more complex CSV format.
  • Feature 2242 new component tReplaceList let the user define a list of search & replace words in an external data source. For example, you can ask the communication team to write the bad words search and replace list in a database.
  • Feature 2378 MySQL specific extended insert mode added to tMysqlOutput, as described in a recent blog post MySQL extended insert mode in Talend Open Studio. Performances are strongly increased.
  • Feature 2300 table actions (create, clear, truncate, etc.) are available in PostgreSQL bulk components, same thing for MySQL with Feature 2499.
  • Feature 2515 new component tSocketInput and Feature 2438 new component tWaitForSocket.
  • Feature 2552 component tSVNLogInput integrated from ecosystem.
  • Feature 509 new component tMysqlUpdateBulkExec described in a recent blog post MySQL bulk update with Talend Open Studio, performance are also increasing. Feature 2567 is the equivalent for PostgreSQL.
  • Feature 2063 in tMysqlOutput, user can select update keys independently from schema. Same for "updatable" and "insertable" columns. This feature was a bit complicated to code and I wait for user feedback before adding it to other database output component.
  • Feature 2539 new component tJoin. tJoin is a simplified tMap, it does only a join (inner or outer) between 2 data sets. In my opinion, the advantages of tJoin compared to tMap are: simpler code (less bugs), graphically more obvious (a tMap can do so many thing you have to open it to remember what's done inside). The drawback of tJoin compared to tMap is mainly to have a standard GUI, no drag & drop and beautiful arrows.
  • Feature 2032 new component tSystemInput can produce a data flow based on a system command output, for example, you can perform a Unix find, filter and write the file listing in a database (to perform a file listing, you'd better use tFileList, it was just an example of Unix well known command producing line by line output).
  • Feature 964 father job doesn't follow the OnError link if child job has already caught the error in its own OnError link. This feature might be very important for users using deep hierarchy job calls.
  • Feature 2110 tFileList can match files and/or directories.