Skip to main content Skip to complementary content
Close announcements banner

What's new in R2021-12

Data Integration: new features

Feature

Description

Available in

Popups about changes not pushed to Git remote repository Talend Studio now displays popup messages when you switch your project or workspace, or close or restart Talend Studio, while you have changes not pushed to the Git remote repository.

All subscription-based Talend products with Talend Studio

Improvement of error messages for Git operations

Talend Studio now displays more specific error messages for Git operations on a protected branch.

All subscription-based Talend products with Talend Studio

Upsert using the ON CONFLICT clause to enable batch size in tPostgresqlOutput

The tPostgresqlOutput provides the Upsert option in the Action on data drop-down list. This option insert a record or update an existing record using the PostgreSQL INSERT-ON CONFLICT statement. It integrates the insert operation and update in a single statement and provides far better performance comparing with the Insert or update and the Update or insert options. According to a comparison between the Upsert operation and Insert or update operation, the throughput of the Upsert operation with the batch mode can be 10 to 100 times higher (depending on the table size and the number of changes).

All subscription-based Talend products with Talend Studio

Configuration of query timeout in database components

A new option, Set Query Timeout (along with Timeout field), is provided, allowing you to set the timeout period for the query. The Job will be terminated if the query is timed out. This option is available in the following components.
  • tAS400Input, tAS400Output, tAS400Row
  • tJDBCInput, tJDBCOutput, tJDBCRow (shown as Use query timeout)
  • tMSSqlInput, tMSSqlOutput, tMSSqlRow
  • tSybaseInput, tSybaseOutput, tSybaseRow

All subscription-based Talend products with Talend Studio

ADSO data extraction through SAP JCO 3

The tSAPADSOInput component provides the SAP JCO 3 option and the related settings. You can now retrieve ADSO data using the tSAPADSOInput component through SAP JCO 3. This feature also provides the ability of extracting SAP ADSO service metadata.

This feature requires the SAP transport shipped with the patch.

All subscription-based Talend products with Talend Studio

Atlas URI connection and X.509 authentication in MongoDB components

The MongoDB components provide the Use connection string option, allowing you to establish connections using MongoDB Atlas URIs. Parameters not available on the GUI can now be freely configured in the URL. The MongoDB components also provide the X509 option in the Authentication mechanism drop-down list, which authenticates users using X.509 certificates.

All subscription-based Talend products with Talend Studio

Application Integration: new features

Feature

Description

Available in

Enhancement of project analysis report

Project analysis report now warns about missing dependencies for components and duplicate routeId usage.

All subscription-based Talend products with ESB

Enhancement of multipart files support in tRESTRequest

The tRESTRequest component now allows you to set multipart files as optional.

All subscription-based Talend products with ESB

Support of custom configuration in cAWSSNS

The cAWSSNS component now allows you to specify custom configuration in the Advanced settings tab.

All subscription-based Talend products with ESB

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!