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 Pipeline Designer
Talend Data Preparation
Talend Data Stewardship
Talend Management Console
Talend Studio
Content
Installation and Upgrade
Release Notes
Last publication date
2024-03-01

New features and improvements

Issue Description

Available in

Erwin DM: support for BigQuery database/dataset

Added support for BigQuery database/dataset as MIRDatabaseSchema.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Hadoop Hive DML: support for MERGE INTO statement

Support for MERGE INTO statement now available in Hive expression parser.

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 (DI/ETL) Script (Transact-SQL): disabled cache for the -ms option

Disabled the bridge cache when the miscellaneous option -ms is enabled.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

IBM Cognos: added connection refresher

New Pinger to keep the main session alive.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

IBM InfoSphere DataStage: variable values file and parameter sets folder

Updated the "Variable values file" bridge parameter to support multiple files in a directory.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

QlikSense: clarification on insecure URL for Maven dependency

The bridge checks accessibility of the Maven repository before handling the first download.

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

Amazon Web Services (AWS) Glue ETL (via Apache Spark): missing lineage after import

Fixed the issue.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Informatica PowerCenter: source is missing under the mapping connections

Fixed feature lookup for cases when several transformations have the same name.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Amazon Web Services (AWS) Redshift Database (via JDBC): not every column gets linked to the source table

Added support for TOP clause and RECORD alias in Redshift expression parser.

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) Redshift Database (via JDBC): fails with SQL error (Invalid character data was found)

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

Apache Cassandra NoSQL Database: error in lineage for materialized views

Fixed the issue.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Oracle Database (via JDBC): Stitcher warning for Oracle StoredProcedure in a Oracle Package

Fixed the issue.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Data Mapping Script: fails with "Illegal Argument"

Fixed an error when processing aliases in the JOIN clauses.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Snowflake Database (via JDBC): StoredProcedure JavaScript parser errors

Added support for JavaScript function 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

SAP Sybase ASE Database (via JDBC): failing with SQL error when the table name contains two spaces followed by "table"

Table name is enclosed in single quotes in the query.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

QlikView: relative path not resolved correctly

Fixed import of the Store statement with relative file path (files\self_loop.qvd) if -qvd.as.file is specified.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Databricks Notebooks: expression syntax not recognized

Added support for CREATE TEMPORARY VIEW in the Apache Spark expression parser.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Oracle Database (via JDBC): regression in Oracle tests

Fixed default catalog name.

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: the lineage operation shows an error "expression is too complex or refers to itself"

Fixed operation printer for recursive call.

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

QlikView: extra columns in QVD

Fixed the issue.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Google BigQuery Database (via JDBC): excessive external connections created for internal lineage

Fixed external connections for the projects that may contain dot characters (".") in their names.

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 Cassandra NoSQL Database: miscellaneous option -backup does not work

Added support for backup/restore.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Microsoft SQL Server Database SQL DML (DI/ETL) Script (Transact-SQL): imported the same SQL script two times and got different outputs

Fixed discrepancies between imported scripts and the scripts restored from cache.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Oracle Database (via JDBC): failed with "MITI.MIRException: The Model is not consistent"

Fixed the case where an Index contains an attribute that is not associated with foreign key.

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): duplicate tables and views for the scanned schemas

Fixed column duplication.

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 Server: "EXPLIB_D0002 Message: 'syntax error, unexpected '''

Added a warning if the execution log file is generated earlier than the last modified date for the related application.

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 PowerDesigner PDM: Unnamed Objects are extracted for View Reference, Foreign Key and Association

Fixed the issue.

.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

File System (Delimited, Fixed Width, Excel, XML, JSON, Avro, Parquet, ORC, COBOL Copybook): NullPointerException

Added code to check Headers length to avoid java.lang.ArrayIndexOutOfBoundsException.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Amazon Web Services (AWS) Redshift Database (via JDBC): fails with SQL error "ERROR: column c.relispartition does not exist"

Fixed the exception by removing partition check for Redshift.

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

Erwin DM: unnamed objects are extracted for Identity and Subtype Relationship Role

Skipped the parent Role of a Generalization and pointed to the parent Entity.

Removed aggregation link from a Sequence to an Identity and added the cache property.

Added a reference link to the Discriminator Attribute in a Generalization.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

QlikSense Server: "EXPLIB_D0002 Message: 'syntax error, unexpected EOS_TOKEN'"

Added support for User aborted log. Added warning if execution log is aborted by user.

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 Reporting Services (SSRS) (Repository): could not log into Report Server URL

Added SSL support.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

PostgreSQL Database (via JDBC): all the related metadata for the partitioned table is created

Only the metadata for the partitioned table itself is created now.

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: Mapping Assets not getting extracted

The bridge now imports lineage for a "load mapping" statement if that statement reads data from a file.

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 export / IBM InfoSphere DataStage: java.lang.NullPointerException

Improved export of Joblets.

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

Microsoft Azure Cosmos DB NoSQL Database: Test button works incorrectly

Added database check while testing.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Idera ER/Studio: unnamed objects are extracted for View Relationship and Super key Relationship

Created a Sources group under View that contains links to Entity/Table/View.

SuperType Relationship (MIRGeneralization) shows the parent entity name.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Microsoft SSIS Repository: "MVLD_E0023 Consistency: Element 'StoreConnection' has no name"

Fixed the issue.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Apache Spark (with Python or Scala): cannot load module

Improved the FAQ section of the bridge documentation.

  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Advanced Plus Edition