Talend Cloud Data Catalog and Talend Data Catalog Bridges - Cloud - 7.3

Talend Release Notes

Version
Cloud
7.3
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 Pipeline Designer
Talend Data Preparation
Talend Data Stewardship
Talend Management Console
Talend Studio
Content
Installation and Upgrade
Release Notes
Last publication date
2024-02-08

New features and improvements

Feature Description Available in
Talend Data Integration: improved lineage when Jobs use the tHiveLoad component

In the lineage, if a temporary classifier has a * node which is not resolved by the stitching, it will be resolved to its sibling features.

The -connection.map option has been improved in the miscellaneous parameter.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Microsoft Azure Data Lake Storage: new miscellaneous parameter to print all processed files The -detailed.log option has been added to print paths of all processed files into the debug log.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Microsoft ADLS: hide data for Parquet files Data sampler has been updated for Parquet files to start using JSON format.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Microsoft SSIS (Repository Database): new miscellaneous parameters to handle connection names The following options have been added:
  • -connection.fullyqualifiedname allows you to prefix connection names with {$project_name}:{$package_name}: tags and helps to distinguish connections with same name in different packages.
  • -connection.catalogname allows you to control #{$catalog_name} suffix in relation to database connection names.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
Microsoft Power BI: support for connections to Analysis Services Microsoft Power BI import bridge: code has been added to create connection objects in case of live connection to Analysis Services.

Microsoft SQL Server Analysis Services bridge detects the OLE DB provider. Tentative support for the tabular model format that includes "create" and "database" header nodes has been added and initial support has been added for perspectives as OLAP schema.

Initial support for report measures has been added and the profiles have been improved to show them as Table Extension or Report Measure object type.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
Any database (via JDBC) import bridges: improved the miscellaneous parameter classes The classes have been improved.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Microsoft Azure Synapse Analytics (SQL Data Warehouse): external tables harvested as standard tables Support for external tables has been added.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Apache Kafka: new -consumer.group miscellaneous parameter The -consumer.group option has been added in the Kafka API options.

A string that uniquely identifies the group of consumer processes to which this consumer belongs. By setting the same group ID, multiple processes indicate that they are all part of the same consumer group. This value would be passed into the Kafka 'group.id' property.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Tableau: Generic JDBC connection with unsupported Google BigQuery SQL queries The Google BigQuery data sources are now supported.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Sparx Enterprise Architect (EA) / OMG UML XMI: import fails with fatal error The speed of the model validation has been improved when there are many aggregation loops.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
SAP HANA database (via JDBC): new support for CDS views The CDS views are now supported.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Notable fixes

Issue Description Available in
Microsoft SQL Server (via JDBC): test connection is failing Added debug messages to control the connection process more precisely.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Microsoft Azure Data Factory: "Failed read value: Unrecognized field "nextLink"" Added support for "nextLink".
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
Metadata Excel Format: "The model is not consistent" Added an error message when delimited columns of 'Delimited file' type have positions zero or less.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Microsoft ADLS Gen2: parquet snappy file import not showing sample data Added skipping of data processing for binary columns.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Talend Data Integration: "Select into temp table" by tRedshiftRow does not get table information Added support for SELECT INTO TEMP TABLE.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Microsoft SSIS (Repository Database): detected missing schema after import Changed serialization properties and improved debug messages.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
Talend Data Integration: "Select into temp table" by tMySQLRow does not get table information Fixed expression parsing and removed definition values for empty parameters.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Teradata Database SQL DML (DI/ETL) Script (BTEQ): lineage at column level leads to a lineage at table level Fixed the MERGE statement.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
Microsoft Power BI (File): differences in regression test Parsed report measures in consistent order and improved log messages.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
MySQL Database (via JDBC): new support for INTERVAL CAST and TEMPORARY TABLE Added support for INTERVAL CAST and TEMPORARY TABLE.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Talend Data Integration: expression syntax not recognized (or not supported) Added support for JOIN clause in UPDATE statement.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

IBM Cognos Content Manager ReportStudio Added support for function PERCENTAGE.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
Informatica PowerCenter: default source or target schema is extracted instead of actual schema defined in source or target datasetid for Google BigQuery connection Added support for BigQuery application.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
Talend Data Integration: missing expected data impact Changed the lineage through the tBufferInput/Output components.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Teradata Database (via JDBC): import fails with exception "[SQLState HY000] Response Row size or Constant Row size overflow" Updated to support the fact that the query is halved for Teradata 14.x versions.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Talend Data Integration / tRedshiftBulkExec: missing lineage to S3 Fixed the NativeId and lineage through the tRedShiftBulkExec component.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Microsoft SSIS: XML reader is not extracted Added support for SSIS XML reader.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
Microsoft Power BI: DAX expression parsing error for a PowerBI report Added single-line comments in the DAX expression parser.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
Microsoft SQL Server (via JDBC): import fails due to a failure in one of the stored procedures and standard SQL Server syntax is not supported Fixed system tables validation for database versions before SQL Server 2016 (13.x). Folders for external schema are not created.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Talend Data Integration: unexpected connection in a Joblet Handled the case when a connection component is located in the main Job and referenced via dynamic settings.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Microsoft Azure SQL Database: Synonyms and Type objects are not extracted Added support for Azure SQL Database synonyms and user-defined types.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Oracle database (via JDBC): "MITI.MIRException: The Model is not consistent" Fixed the cleanup of undefined types.

Available in:

Cloud Data Catalog Advanced Edition

Cloud Data Catalog Advanced Plus Edition

Cloud Data Catalog Standard Edition

Data Catalog Advanced Edition

Data Catalog Advanced Plus Edition

Data Catalog Standard Edition

All Talend Data Catalog licenses

Microsoft SQL Server Database SQL DML: support for DROP CONSTRAINT 'WITH' Added support to ignore WITH (ONLINE = OFF).
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
Cloudera Navigator: parsing error Fixed the parsing errors and improved the spark operations processing.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
SAS Data Integration: "Illegal Argument: The Classifier...already contains a Feature with this Name" Added a fix to skip duplicate physical columns and Jobs without definition.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition