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-03-20

New features and improvements

Feature Description Available in
Amazon Web Services (AWS) Athena Database (via JDBC): new import bridge Amazon Web Services (AWS) Athena Database (via JDBC) import bridge 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: support for hierarchical metadata sample models The hierarchical processor has been used for the XML components including tFileInputXml, tExtractXMLField, tWriteXMLField, tXMLMap and tFileOutputXML. The tFileInputRaw and tFileOutputRaw have been fixed in the profile.

The hierarchical processor has been used for the JSON components including tFileInputJSON, tExtractJSONField, tWriteJSONField and tFileOutputJSON.

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 iSeries (AS/400) Database (via JDBC): improved data profiling and sampling The parser of the query template for data samples has been improved and the code has been refactored to support the query template approach.

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 or Scala): no lineage from Teradata tables to GCP files implementing external Hadoop Hive tables on Google Cloud Platform The support for the Map classes has been added. The support for the DataFrameReader class using the options method has been improved to define the attributes of the data store connectivity.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
Bridge miscellaneous parameter: replaced -c and -cd with -connection.cast, .rename, .merge, .split The connection.cast, .merge, .map, .split and .rename options have 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

Miscellaneous parameter: multiple instances of the same option instead of an option with a list of values The MiscParam helper class has been improved to work with multi key 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

QlikSense: Expression Syntax not recognized The expression parsing has 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

SAP BusinessObjects import bridges: license session issue The error handling for the SAP BusinessObjects Web Intelligence import bridge has been improved. The session cleanup for the SAP BusinessObjects Information Design Tool import bridge has been improved.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
Snowflake Database (via JDBC): missing source object in lineage Improved the lineage for the SQL queries that contain references on semi-structured data such as JSON.

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 Database (HCatalog and Metastore via JDBC) import bridges: support for both string or file of schema subset Improved the Schema parameter to provide a parameter 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: support for the tS3Copy component The support for the tS3Copy component 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: support for the tRedshiftBulkExec component The support for the tRedShiftBulkExec component has been added for S3/EMR source 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

Apache Hadoop Hive Database (HCatalog and Metastore via JDC): new support for the backup of multi models The support for the backup of multi models has been added with the -backup option to 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

Apache Spark (with Python or Scala): new -prescript import option The new -prescript import option has been added to the miscellaneous parameter.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
Database DDL export bridges: new Oracle MySQL Database SQL DDL Script export bridge The Oracle MySQL Database SQL DDL Script export bridge has been added.
  • Talend Data Catalog Data Governance Edition
  • Talend Cloud Data Catalog Data Governance Edition
IBM Infosphere Data Architect (IDA): hierarchies with less than one level association are skipped The hierarchies which do not have at least one hierarchy level association are now skipped when importing the model.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
Sparx Enterprise Architect (UML 2.x XMI): support for primary keys and null values The support for primary keys and null values has been added.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
Bridge Help panel: harmonization and cleanup The content in the Help panel in the bridge import setup has been reorganized and updated.

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

Import of mappings via the Metadata Excel Format: description is not imported A Script.Description property has been added to the profile to import the description of a mapping.

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: added the ability to exclude folders within a project The -folders.exclude option has been added to the miscellaneous parameter documentation.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
Microsoft Azure Blob Storage and Data Lake Storage: added browsing time limitation for third-party tool repository The format validation and path existence of the Root directory parameter have been implemented for the Test and Import actions.

The common code has been implemented to limit the browsing time by 30 seconds.

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 Service (Repository): warnings and null pointer errors The support for ODBC and local data sources has been improved.

The storeType parameter has been set earlier to avoid warnings for DataSet models.

The empty schema has been removed if there are no tables underneath.

  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
Oracle Database (via JDBC): 14K of "MBI_JDBC4_W0243 Trigger Classifier '%' was not found in Schema" log messages The trigger related log messages have been deleted for the single-model and multi-model 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 / tDBRow component: support for COPY query Extra function call has been handled on the context 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 Preparation: error "Lineage can be incorrect" The support for ExtractEmailParts action 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

HDFS, Hive, Navigator bridges: support for Cloudera Data Platform 7.1 The CDP 7.1 is 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

Microsoft SSIS (Repository database): improved the documentation for the User bridge parameter The documentation for the User bridge parameter has been improved to specify the required database permissions.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition

Notable fixes

Issue Description Available in
Microsoft SQL Server (via JDBC): "java.lang.StackOverflowError" error when requesting data sampling for the large number of columns Fixed the handling of large list of objects in the data profiling option.

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: MITI.MIRException: The Model is not consistent Fixed the processing of the Oracle procedure ID.

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 (via JDBC): MITI.MIRException: There already exists a COLUMN with the name <> in the parent TYPE <> Fixed the user-defined types and names of 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

File System bridge: new encoding parameter for Shift_JIS Added the encoding enumeration parameter for Delimited files and Fixed Width files. Added -file.encoding 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

SAS Data Integration: NullPointer issue with SAS SPK packages Fixed the filter with an orphaned column in the cross join function.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
Snowflake Database (via JDBC): fixed expression parser Fixed the columns that are specified as $1.

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: tSAPTableInput connection missing after harvesting Fixed the tSAPTableInput filter.

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

Miscellaneous parameter: added support for -cache.clear option for import bridges Added the support for the -cache.clear option.

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 dashboard: issue when harvesting the database connections Added the backup functionality for Qlikview.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
SAP Business Suite 4 HANA (S/4HANA), ECC: java.lang.NullPointerException: Unable to successfully import Fixed the issue when the D010TAB tables have duplicate records.

Improved the bridge profile by improving the ABAP function module to minimize warnings and by fixing the exception and the double download issue.

You have to apply the updated ABAP function module on the SAP server.

You should configure the bridge and Talend Data Catalog application server with 15 to 20GB of memory.

  • Talend Data Catalog Data Governance Edition
  • Talend Cloud Data Catalog Data Governance Edition
Talend Data Integration: no lineage with Amazon Aurora MySQL database connection Added the support for the LOAD DATA statement in the MySQL 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

Bridge miscellaneous parameter: fixed the -backup option for MySQL databases (via JDBC) Added the creationDate and modificationDate values to the backup option and ordered backing up of schemes.

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

Bridge miscellaneous parameter: fixed the -backup option for JDBC databases Added the isInheritsLineageOptions value to the backup option.

Added the support for multi-model 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

QlikSense Server: not able to parse expressions in visualization extensions Removed the JSON part from the title and added the parsing expressions in the title.

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): views are missing in scan Improved the template query processing to control the structure of the result set.

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 Informix Database (via JDBC): error java.sql.SQLException: Unable to find User Defined Routine with the given ID The bridge behavior has been changed to import even if this error type has occurred.

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 Database (HCatalog and Metastore via JDBC) import bridge: Cloudera Data Platform 7.1 / some columns are not extracted Improved the bridge to support the new behavior of Hive column 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

SQL parsing of Transformation expressions for import bridges: limitations on Oracle database extensions The Oracle extension limitations are the following:
  • The Oracle text literals is supported and is limited to the two single quotation marks mechanism such as 'Jackie''s raincoat'.
  • The Q/q alternative quoting mechanism such as Q<'Jackie's raincoat>' is not 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

Oracle Database (via JDBC): test connection failing with ORA-12505 Added new debug messages and comments and improved the exception handling.

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 SQL DML (DI/ETL) Script (SnowSQL): table to table lineage Fixed the stars in queries with CTE and the aliases. Added the support for function DATEDIFF.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
Oracle and Microsoft SQL Server Database (via JDBC): database null values are inferred as null character values when running the profiling of the database Updated the bridge code to pass to the data profiling library as either an empty string or a java null value.

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 Business Intelligence (OBI) Enterprise Edition (Server): repository subset browse is failing Improved the code related to the detection of duplicate paths.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
Oracle Database (via JDBC): fails with multiple IllegalArgumentExceptions Fixed the Oracle schema query.

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 StackOverflowError Fixed the recursive parameter resolution.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition
Microsoft Power BI Report Server (Repository): cannot stitch if query contains variable/parameter Improved the detection of database types.
  • Talend Cloud Data Catalog Metadata Management Edition
  • Talend Data Catalog Data Governance Edition
  • Talend Data Catalog Metadata Management Edition
  • Talend Cloud Data Catalog Data Governance Edition