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
Microsoft SSIS: new support for nested task variables Support has been added for nested tasks.
  • 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 SSAS: data flow lineage Profiles have been improved by renaming 'Tabular Model' with 'Measures' and adding group for Perspective.

The handling of ambiguous features has been improved for the SQL 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 SSIS: new support for environment variables Support for environment variables has been added.
  • 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 / SQL Override: new multi-statement support Multi-statement support 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

Microsoft SSIS: new support for components Support for versioned components has been added.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition
Google BigQuery Database: JDBC driver based new version of the bridge Support for function arguments 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

Talend Data Integration: UPDATE with JOIN using WHERE clause by tMysqlRow does not get table information Support for multiple-table UPDATE 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

QlikSense: improved documentation on the required application access privileges to API engine The tooltip of QlikSense bridge has been updated for the required application access privileges to API engine.

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 Server: improved documentation on the required Tableau user permissions The tooltip of Tableau bridge has been updated for the required user permissions.

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 Analysis Services (SSAS): new import bridge The new Microsoft Azure Analysis Services (SSAS) import bridge is based on the existing Microsoft SSAS bridge. It allows you to use the User/Password options for Windows desktop and Azure 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
AWS Athena Database (via JDBC) - Technical Preview: new native bridge to support views and more Amazon Web Services (AWS) Athena Database (via JDBC) - Technical Preview has been added as a new import bridge.

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 MySQL database (via JDBC): parser error on CHARSET Support for CHARSET 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

Talend Data Integration: new -talenddatapreparation.backup miscellaneous parameter to improve the integration with Talend Data Preparation The -talenddatapreparation.backup option allows you to embed preparations from a backup created with Talend Data Preparation bridge.

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 import bridges: improved the import of large models when a bridge has less than 4GB of memory The process for data type creation has been improved when a bridge is dealing with a very large model and has very limited memory. This improvement has been implemented for all database import bridges.

A new custom factorization logic of data type is used to create only unique data types and reuse them as much as possible. It improves the speed of data type creation and limits the memory usage. For example, you can now create 2M features with their data types in three minutes instead of two hours.

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 Server: authentication with personal access token You can now authenticate with a personal access token when the username/password authentication method returns HTTP 401 (Unauthorized) response.

When authenticating with a personal access token, you cannot open the report in Tableau directly from Talend Data Catalog as the workbook name cannot be captured.

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 Spark (with Python) / Databricks PySpark: miscellaneous parameter -environment.variable unsupported The input parameters expressed via dbutils.widgets have been improved.
  • Talend Data Catalog Advanced Edition
  • Talend Data Catalog Advanced Plus Edition
  • Talend Cloud Data Catalog Advanced Edition
  • Talend Cloud Data Catalog Advanced Plus Edition

Notable fixes

Issue Description Available in
Amazon Athena: Table filter does not work properly Added the View filter. Due to the nature of the engine filters, the syntax differs for tables and views.

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 Athena: custom Athena SQL expression parser Added support for Athena 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 Athena database (via JDBC): support for schema browsing Added support for Athena schema browser.

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

Mongo DB / JSON import: FATAL:java.lang.NullPointerException when importing from a specific JSON file Fixed the processing of JSON arrays and the nativeType property on the array parent attribute.

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: "Drop table if exists" by tMysqlRow does not get table information and connection Fixed the MySQL expression parser to get table information.

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 Preparation: "Index of bounds" runtime data flow overview problem Fixed the lineage cleanup after merging stitched objects.

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: SQL parser errors Improved parameters and variables resolution.

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

Google Cloud Storage: "java.lang.NoSuchMethodError" Fixed the description of the Root directory 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

Talend Data Integration: unexpected undefined variable for tImpalaConnection Changed the connection properties for the tImpalaConnection component. Removed extra schema parameter and used Database instead.

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

Metadata Excel Format / Data Mapping: "MITI.MIRException: org.xml.sax.SAXParseException" Fixed validation errors.

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 MDM: relationships metadata and keys are labelled as 'No name' Added names for associations, association roles, foreign keys and generalizations objects.

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: default source or target schema is extracted instead of actual schema defined in source or target datasetid for Google BigQuery connection in case of parameterization Improved BigQuery reader detection for parameterized connection. Added support for 'SQL Override'.
  • 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: does not import "STORE QVD" step from QVW file Added support when a BI model writes data to another BI model in an export 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
Erwin DM export / IDERA ER/Studio import: does not bring any objects Fixed building of ID for ExtendedNote.

Renamed target databases from "ODBC/Generic 2.0" to "ODBC 2.0" and from "ODBC/Generic 3.0" to "ODBC 3.0".

Fixed printing of the property 'Generate_As_Constraint' for 'Key_Group'.

  • 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: tMysqlRow does not produce connection when using "Create Index" Updated the CREATE INDEX statement in the expression analyzer.

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

Google BigQuery: data profiling and sampling do not work for the table Fixed data profiling and sampling for individual table request.

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: "Create table" by tRedshiftRow does not produce lineage Added support for table attributes DISTSTYLE and DISTKEY.

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: "Create index" by tMysqlRow does not get table information Added support for CREATE INDEX.

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

Google BigQuery: issue with expression parser for backtick Resolved backtick 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

Amazon Redshift (via JDBC): function arguments are not extracted Added support for function arguments.

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 SSAS (File) / .bim format: "java.lang.ClassCastException: class org.json.simple.JSONArray cannot be cast to class java.lang.String" Fixed parsing multi-line descriptions and improved DAX expression parsing and measures referenced without table context.

Replaced two consecutive double quotes (used as escape characters when embedding dax into powerquery statement) refactoring to allow parsing DAX expression embedded in PowerQuery expression.

Changed PowerQuery parser to be more explicit about the language type such as MDX.

Added initial support for CalculationGroup and CalculationItem.

Improved lineage detection using sourceColumn property, even when mashup is involved.

Added initial support for SharedExpressions (Table, Parameter, Function) and function GoogleBigQuery.Database().

Fixed non-standard UDP usage property for Microsoft SSAS (XMLA) import 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
Microsoft Power BI (File): NullPointerException Improved lineage of report fields pointing to Hierarchy.Level.Attribute and improved bridge tooltip for Microsoft Power BI File import bridge.

Added initial support of function Salesforce.Reports() for Microsoft SSAS import 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
Microsoft SSIS: no connection schemas available for the database catalog Made the comparison of schemas and connection packages case sensitive.
  • 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: "Create table" by tRedshiftRow does not get table information Added support for ENCODE and DISTKEY.

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

SAS Library: "Illegal Argument: The Classifier...already contains a Feature with this Name" The bridge now detects and skips duplicate columns.
  • 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: "Drop table if exists" by tRedshiftRow does not get table information Added support for "DROP TABLE IF EXISTS".

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