Talend Cloud Data Catalog and Talend Data Catalog Bridges - 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
Last publication date
2023-12-01

New features and improvements

Issue Description

Available in

Databricks Notebooks: repository filter on folder structure

Implemented File and Folder filtering. Replaced the "Directory Filter" and "File Filter" bridge parameters with "Object Filter". It supports Glob syntax with negation and allows multiple conditions.

  • 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: support for Multi-statement SQL queries

Added support for Multi-statement SQL queries.

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

DML import bridges: ability to hide/show external table location objects in lineage diagrams

Fixed redundant recursive summary links for the CREATE TABLE statements.

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 Power BI: limited lineage for PowerBI reports

Created classifiers to allow limited lineage for PowerBI reports.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Snowflake Database (via JDBC): support for RENAME clause

Added support for the RENAME clause that is used with star (*) in SELECT 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

dbt Core: support for Databricks jobs

Removed database limitation note in the documentation and added description for the Project parameter.

Upgraded supported dbt Core version to 1.5.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

QlikSense Cloud: clarification on streams

Updated the Requirements section of the bridge documentation.

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

Amazon Web Services (AWS) Athena Database (via JDBC): updated length and scale of database types

Changed default length and scale from 1 to 0 for all database 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

SAP Business Warehouse 4 HANA (BW/4HANA): reverted INTLEN to OUTPUTLEN

Reverted to use OUTPUTLEN as the length attribute. Added INTLEN as UDP

  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

dbt Core: removed database limitation to Snowflake from the documentation

Removed the database limitation note.

Updated supported dbt Core version to 1.5.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

IBM Cognos Data Module: support for QuerySubject folder items

Added minimal support for QuerySubject folder items.

Improved support for data types.

Improved profile to show connection objects.

  • 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 PowerDesigner: updated log message

Added a warning to the log that this model refers to an external file for Extended Model Definitions.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

QlikSense: new miscellaneous option

Added miscellaneous option -cluster.log.folder to specify additional log folders.

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

SAP Business Warehouse 4 HANA (BW/4HANA): "java.lang.StackOverflowError"

Fixed stackOverflowError for queries if query references have circular references.

  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Snowflake Database (via JDBC): unusual error message in the log

Changed log level for partition folder messages from Warning to Info.

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

SAP Business Warehouse 4 HANA (BW/4HANA): KeyFigure Length/Scale inconsistent with SAP Business Warehouse System

Fixed the issue.

  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

IBM DB2 Universal Database (UDB) (via JDBC): duplicate columnMappings attributes

Fixed columnMappings duplicates.

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

dbt Cloud: re-harvesting lost all connections

Fixed the issue.

  • 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 Database SQL DML (DI/ETL) Script (Transact-SQL): missing entities

Fixed duplicate relationships regression.

Improved processing lineage for multiple similar scripts.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

dbt Core: lost positions in Stored Procedures

Set LineageOptions for StoredProcedure datasets.

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

Informatica PowerCenter: "Error: The Model is not consistent."

Added a warning if a model is not valid.

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

Idera ER/Studio: unnamed objects are extracted for Foreign Key and Index

Changed display name for Foreign Key and hided Foreign Key non-generated Index.

  • 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 Sybase ASE Database (via JDBC): lineage is not showing between view and table when both have spaces in their names

Added support for square brackets to delimit identifiers.

  • 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 SSIS: expression syntax not recognized and lineage missing

Improved the expression parser:
  • Added support for ADD DEFAULT clause in ALTER TABLE statement
  • Ignored ALTER INDEX statement
  • Improved EXEC statement
  • Added support for SSIS none fully qualified @[$Project::var] variables/parameters
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

IDERA ER/Studio: unnamed objects are extracted for Foreign Key and Index

Fixed the issue.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Oracle Analytics Server (based on OBIEE): "java.lang.NullPointerException: MultiModelIterator.doDepthFirst"

Fixed NullPointerException for invalid models.

  • 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: expression syntax warnings

Added support to enable/disable primary key in ALTER TABLE 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 Netezza Database (via JDBC): "MBCM_F0029:java.lang.NullPointerException"

Fixed NullPointerException.

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

Informatica PowerCenter: "MITI.MIRException
	atMITI.bridges.Informatica.PowerCenter.Import.MIRInformaticaPowerCenterImport.processFolders"

Fixed XMLParser keys lookup.

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): restoring from cache

Added skipping of loading metadata from the cache when restoring a model from a backup.

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 Netezza Database (via JDBC): AbstractMethodError

Fixed driver exception.

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

QlikSense: storeType is always OLAP

Changed storeType from OLAP to REPORT for QlikSense applications.

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

MicroStrategy: "MITI.MIRException: Cannot get Prompt"

Fixed the issue.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Amazon Web Services (AWS) Simple Storage Service (S3) File System: "MBCM_F0029 com.amazonaws.services.s3.model.AmazonS3Exception: The AWS Access Key Id you provided does not exist in our records"

Fixed the problem with authentication into AWS GovCloud.

Added back Region to the bridge import parameters in the UI.

  • 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 Report Server (Repository): an error occurred while copying file

Fixed the issue.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

MongoDB NoSQL Database: missing json_property in json_schema

Adjusted the export bridge according to the changed import bridge structure.

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

Any Database JDBC import: checksum_data.csv file created in backups

The created checksum_data.csv file has been removed from the backup root folder.

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: connection type denodo_jdbc is not supported

Added JDBC connection type for Denodo.

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): classifier map operation is missing for INSERT statement with LOG ERRORS clause

Added operation to classifier map for INSERT, UPDATE and DELETE statements with LOG ERRORS clause.

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

Database SQL DDL Script: one partitioned table's metadata is imported but multiple table metadata is generated

Fixed multiple parsing issues in the SQL parser for PostgreSQL DDL.

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 DDL Script: failed with the MAP option

Added support for the MAP option for CREATE TABLE statements in Teradata DDL.

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

SAP Business Warehouse 4 HANA (BW/4HANA): "Field" created by HANA Studio for ADSO is missing information

Added metadata for field (length, scale, precision). This improvement requires an update to the ABAP script.

With regard to backward compatibility:
  • If the ABAP script version is not the latest, a warning will be printed in the log and the bridge uses the script anyway with limited metadata capability.
  • If the ABAP script version is the latest, the bridge uses the script for maximum metadata capability.
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Any Database JDBC import: loading metadata from a server and then also loading from the cache

Improved the caching algorithm of bridge models to avoid metadata loading when it already presents in the cache.

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

Presto Database (via JDBC) / Erwin DM export: does not bring in Foreign Key Constraint names

Fixed the issue.

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

Security Vulnerability: Xerces - CVE-2018-131

Updated Xerces to version 3.2.4.

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