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-07

New features and improvements

Issue Description

Available in

Any Database JDBC import: new miscellaneous option -jdbc_string.hide

Added miscellaneous option -jdbc_string.hide for the bridge to skip logging the JDBC string. This option is provided for the case that the customer has specified confidential information in the JDBC string (for example, a secret key), and would like the bridge to skip logging the JDBC string.

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: improved connection management

Improved connection state detection.

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

Snowflake Database (via JDBC): support for resultset

Added support of lineage for Snowflake scripting based stored procedure.

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 and dbt Cloud: new Beta bridges for ELT within Snowflake

Added new dbt bridges.

  • 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 EXECUTE IMMEDIATE

Added support for EXECUTE IMMEDIATE.

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: new miscellaneous option -qvd.as.file

Added miscellaneous option -qvd.as.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

Amazon Web Services (AWS) Simple Storage Service (S3) File System: new option -iam.instance.access

Added option -iam.instance.access to support IAM EC2 instance access mode.

  • 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) Glue ETL (via Apache Spark): support for Apache Hudi

Improved the bridge to support Apache Hudi connection 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

Tableau Prep Builder: new Beta bridge

Added new Beta bridge.

  • 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 Business Warehouse 4 HANA (BW/4HANA): support for DataStoreObject and AdvanceDataStoreObject with their schema information

Updated bridge documentation.

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

Microsoft Azure Data Lake Storage (ADLS) Gen2 File System: support for service principal authentication

Improved bridge tooltip with instructions on how to configure Active Directory authentication.

  • 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: support for tSetGlobalVar component

Added support for the tSetGlobalVar component.

This component may be used several times in the same Job setting up the same variable with different values. In this case, only the first instance of this component will be imported and thus only the first value of the variable will be applied.

In addition, the runtime dynamic scenarios are not supported, for example, the value of the variable comes from the data flow.

Changed TalendData.getCurrentDate function to return static [currentDate] string.

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 Azure Blob Storage File System: "java.nio.file.InvalidPathException: Trailing char < >"

Fixed URI paths handling.

  • 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 Database (via JDBC): import errors

Validator is changed for stored procedure parameter dataset.

"Operation id" UDP value is changed. Schema name and package name are swapped.

Make sure not to create synonym if the referenced object does not exist in the imported schema.

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: restored exception

Restored throwing the exception if the folder to which the backup will be created is not empty.

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 Big Data Management (BDM) Developer Repository: "java.lang.IllegalArgumentException: Illegal Argument: The ConnectionDataSet already has a InputOfDiModel"

Added support for multiple mapplet input/output.

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

Erwin DM: extraction failed with *.erwin_tmpl file type

Allowed *.erwin_tmpl file extension.

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

Hadoop Hive Database (HCatalog and Metastore via JDBC) / Databricks Delta Lake Hadoop Hive Database (HCatalog and Metastore via JDBC): "Regression: java.lang.NoClassDefFoundError: org/apache/log4j/Appender"

Added proper Log4j JAR to classpath.

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) (via JDBC): connection to the database failed

Added the actual full connection string to print.

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 Big Data Management (BDM) Developer Repository: java.lang.NullPointerException

Fixed the NullPointerException. Improved backup.

  • 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 Big Data Management (BDM) Developer Repository: "Consistency: <>: Feature must have a Type"

Set undefined type for features missing types.

  • 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 not recognized

Added support for function TIMESTAMP.

  • 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 Database (via JDBC): LOG ERROR INTO statement produces no operation in the second ClassifierMap in model.xml

Set classifier map operation for MERGE statement with LOG ERROR INTO 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

Looker Server: error occurred when connecting to URL https://hrblock.looker.com:443/api/3.1/users

Increase timeout to 5 minutes.

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

Data Mapping Script: expression syntax not recognized and some lineage metadata is not available.

Fixed error caused by the file connections that point to the same root directory.

  • 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: "MITI.MIRException: java.lang.NumberFormatException: For input string: "E" in Hierarchy()"

Fixed parsing LOAD statement with Hierarchy.

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) / Metadata Excel Format: stitching does not work

Changed Athena caseType to case insensitive.

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

Hadoop Hive: "java.sql.SQLException: Can't set some connection properties. Error: Method not supported"

Removed code not supported by Hadoop Hive JDBC driver.

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

Hadoop Hive: Log4j warnings

Added Log4j Appender for Hadoop Hive bridges to process Log4j warnings correctly via the bridge logging infrastructure. Added log4j-core to classpath.

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 DB2 Universal Database (UDB) (via JDBC): does not generate view lineage for some view entities

Added support for CURRENT USER in DB2 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

Talend Data Integration: upper case tables cannot be stitched

Added support for the advanced option Convert columns and table to lowercase that is set on the component in Talend Data Integration.
  • If this option is not set, the bridge will decorate table name with additional double quotation marks for case sensitive stitching.

  • If this option is set, columns and table will be in lowercase.

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 DDL Script: expression syntax not recognized

Fixed the NullPointerException for SQL Server.

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: "javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake"

Improved query pagination algorithm when a single result is expected.

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

QlikView: lineage between applications is missing

Added Partitioned Folder Dataset entity to the Meta Integration ETL Summary Data Store profiles:
  • conf\MIRProfiles\ids\Meta Integration ETL Summary\Data Store.xml
  • conf\MIRProfiles\profiles\Meta Integration ETL Summary\Data Store.xml
  • conf\literals\en\profile\profile_190.yaml
Added Partitioned Folder Dataset entity to QlikView profiles:
  • conf\MIRProfiles\ids\Qlikview\Connection.xml
  • conf\MIRProfiles\profiles\Qlikview\Connection.xml
  • conf\literals\en\profile\profile_297.yaml
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

PostgreSQL Database (via JDBC): stored procedures display as functions

Fixed stored procedure type.

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

OpenAPI Specification (OAS): there are differences in the checksum for 2 models

Fixed the checksum differences.

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

Salesforce (SFDC) Database: failed to access API endpoint with access token retrieved from Salesforce token API

Added error message of wrong HTTP ResponseCode.

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