Data Integration: new features - Cloud - 8.0

Talend Release Notes

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud API Services Platform
Talend Cloud Big Data
Talend Cloud Big Data Platform
Talend Cloud Data Fabric
Talend Cloud Data Integration
Talend Cloud Data Management Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Cloud API Designer
Talend Cloud API Tester
Talend Cloud Data Inventory
Talend Cloud Data Preparation
Talend Cloud Data Stewardship
Talend Cloud Management Console
Talend Cloud Pipeline Designer
Talend Data Preparation
Talend Data Stewardship
Talend Studio
Content
Installation and Upgrade
Release Notes

Talend Studio

Feature

Description

Available in

New way of updating Talend Studio Talend introduces a new way of obtaining and installing Talend Studio monthly updates, which allows you to update Talend Studio more easily.

Two update repositories are provided for Talend Studio feature packages and updates respectively. A new Update settings view, which allows you to configure the update repositories by setting the following two URLs, is available in Talend Studio Preferences dialog box.

  • Base URL: the URL of the repository for Talend Studio feature packages.
  • Update URL: the URL of the repository for Talend Studio updates.

After setting up the update repositories for Talend Studio and configuring the update repositories in Talend Studio correctly, Talend Studio automatically detects, obtains, and installs the updates.

For more information about the update repositories, see Setting up update repositories for Talend Studio and Continuous Integration and configure update repositories.

For more information about updating Talend Studio, see Updating Talend Studio.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend products with Talend Studio

The Feature Manager wizard and the Activate/Deactivate features view Talend Studio now ships only some basic Data Integration features by default and it provides
  • a Feature Manager wizard, which guides you to install those features that are not shipped by default. This wizard is accessible from either the Studio top bar or the Help menu.
  • an Activate/Deactivate features view in the Project Settings dialog box, which allows you to activate or deactivate installed features in your project.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend products with Talend Studio

The Third-party Libraries wizard A new Third-party Libraries wizard, which allows you to install all third-party libraries in one go, is now provided in Talend Studio. This wizard can be opened via the Install third-party libraries button in the Modules view or the Go to libraries link in the Feature Manager wizard.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Open Studio for Big Data

Open Studio for Data Integration

Open Studio for Data Quality

Open Studio for ESB

Real-Time Big Data Platform

All Talend products

Migration report Talend Studio now generates a CSV report file to list all items migrated or imported when migrating a project or importing items from a lower version project.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend products with Talend Studio

Project analysis tool Talend Studio now provides a project analysis tool to help you analyze your project. The tool generates a CSV report file to list the items to check and the problems to fix manually.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend products with Talend Studio

Talend CommandLine installation Talend Studio now provides two scripts, commandline_upgrade.bat for Windows and commandline-linux_upgrade.sh for Linux, which allow you to install Talend CommandLine by upgrading either a brand new or an existing Talend Studio.

Available in:

Big Data

Big Data Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend on-premises products

Support of finding Git commits Talend Studio now supports finding Git commits in the Git History view and in the Git History tab of the Job view.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend products with Talend Studio

Support of configuring proxy and timeout settings when importing the license A Network settings link is now provided in the Welcome to Talend Studio dialog box, which allows you to configure proxy and timeout settings when importing the license from a remote host behind a proxy.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend products with Talend Studio

Improvement of Talend Studio top bar A Support drop-down menu is provided on the top bar of Talend Studio to facilitate your access to Talend online support resources and built-in videos.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Open Studio for Big Data

Open Studio for Data Integration

Open Studio for ESB

Real-Time Big Data Platform

All Talend products except Talend Open Studio for Data Quality

Runtime lineage Talend Studio now supports enabling runtime lineage for Standard Jobs, which will be leveraged in future releases by the analysis capability of Talend Data Catalog for the runtime metadata, for example, queries with variables, schemas with dynamic columns, etc.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend products with Talend Studio

Enhancement of defining project references A Use strict references to find joblets in target project check box is now available on the Reference Projects view in the Project Settings dialog box, which allows you to configure where to find a Joblet when building a Job.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend products with Talend Studio

New Studio look and feel Talend Studio 8 has an updated brand identity and a new splash screen.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Open Studio for Big Data

Open Studio for Data Integration

Open Studio for Data Quality

Open Studio for ESB

Real-Time Big Data Platform

All Talend products

New components available

This release provides the following new components.

  • tCosmosDBSQLAPIInput, tCosmosDBSQLAPIOutput, which provide access to a Cosmos database collection through SQL API (delivered in 7.3 R2020-06 monthly release).
  • tCyberarkInput, which retrieves the password of an application from a CyberArk vault at runtime (delivered in 7.3 R2021-10 monthly release).
  • tFileInputORC, tFileOutputORC, which provide access to files in ORC format (delivered in 7.3 R2020-10 monthly release).
  • tFileInputParquet and tFileOutputParquet for Standard data integration Jobs, which provide access to files in Parquet format (delivered in 7.3 R2021-08 monthly release).
  • tNeo4jV4Close, tNeo4jV4Connection, tNeo4jV4Input, tNeo4jV4Output, tNeo4jV4Row, which provide access to Neo4j version 4.x database (delivered in 7.3 R2020-09, 7.3 R2021-05, and 7.3 R2021-06 monthly releases).
  • tNetSuiteV2019Connection, tNetSuiteV2019Input, tNetSuiteV2019Output, which provide access to NetSuite SOAP server using NetSuite v2019 features (delivered in 7.3 R2020-10 and 7.3 R2021-04 monthly releases).
  • tRabbitMQClose, tRabbitMQConnection, tRabbitMQInput, tRabbitMQOutput, which provide access to message queues (delivered in 7.3 R2020-09 and 7.3 R2021-06 monthly releases).
  • tSingleStoreBulkExec, tSingleStoreClose, tSingleStoreCommit, tSingleStoreConnection, tSingleStoreInput, tSingleStoreOutput, tSingleStoreOutputBulk, tSingleStoreOutputBulkExec, tSingleStoreRollback, tSingleStoreRow, tSingleStoreSP, which provide access to the relevant databases (delivered in 7.3 R2020-11 and 7.3 R2021-03 monthly releases).
  • tZendeskInput, tZendeskOutput, which provide access to Zendesk server.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend products except Talend ESB

Azure ADLS Gen2 components: Azure Active Directory authentication supported

The tAzureAdlsGen2Input and tAzureAdlsGen2Output components support Azure Active Directory authentication. This feature is delivered in 7.3 R2020-06 monthly release.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend products except Talend ESB

BigQuery components enhancements

  • The tBigQueryBulkExec, tBigQueryInput, tBigQueryOutput, and tBigQuerySQLRow components provide the OAuth Access Token authentication mode which allows you to authenticate to your project using an OAuth access token. This feature is delivered in 7.3 R2020-12 monthly release.
  • When you use multiple queries, multiple result sets are now returned for the following components: tBigQueryBulkExec, tBigQuerySQLRow, tBigQueryInput, tBigQueryOutput. You can also use the following new variables in the Query field to check the Job execution statistics: JOBID, STATISTICS, STATISTICS_CHILD (only for tBigQuerySQLRow and tBigQueryInput) ERROR_MESSAGE (only for tBigQuerySQLRow and tBigQueryInput). This feature is delivered in 7.3 R2021-07 monthly release.

Available in:

Big Data

Big Data Platform

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

Data Integration

Data Management Platform

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

All subscription-based Talend products with Talend Studio

ELT components enhancements
  • The Use WHERE conditions table option and the Where conditions table field are provided in the Basic settings view. The change improves the productivity. Components involved: tELTGreenplumOutput, tELTMSSqlOutput, tELTMysqlOutput, tELTNetezzaOutput, tELTOracleOutput, tELTOutput, tELTPostgresqlOutput, tELTSybaseOutput, tELTTeradataOutput, tELTVerticaOutput. This feature is delivered in 7.3 R2021-02 monthly release.
  • In the ELT Map Editor of the tELTMap component, you can now enter a multi-line expression for an output column and access proposals including input columns, output columns, and context variables by pressing Ctrl + Space in a new pop-up dialog box. This feature is delivered in 7.3 R2020-08 monthly release.
  • The ELT Map editor of the tELTOracleMap component now provides a new dialog box Property Settings, which contains two options:
    1. Delimited identifiers: With this check box selected, double quotes will be added for all output column names to support delimited identifiers.
    2. Automatic alias: With this check box selected, if a schema column has a different name than its database column, an alias will be automatically created in the SQL query for that column.