Talend Cloud Data Catalog and Talend Data Catalog Bridges

Erwin DM: support for BigQuery database/dataset

Added support for BigQuery database/dataset as MIRDatabaseSchema.

Hadoop Hive DML: support for MERGE INTO statement

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

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.

IBM Cognos: added connection refresher

New Pinger to keep the main session alive.

IBM InfoSphere DataStage: variable values file and parameter sets folder

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

QlikSense: clarification on insecure URL for Maven dependency

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

All Talend Data Catalog licenses

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

Fixed the issue.

Informatica PowerCenter: source is missing under the mapping connections

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

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.

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.

All Talend Data Catalog licenses

Apache Cassandra NoSQL Database: error in lineage for materialized views

Fixed the issue.

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

Fixed the issue.

Data Mapping Script: fails with "Illegal Argument"

Fixed an error when processing aliases in the JOIN clauses.

Snowflake Database (via JDBC): StoredProcedure JavaScript parser errors

Added support for JavaScript function parameters.

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.

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.

Databricks Notebooks: expression syntax not recognized

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

Oracle Database (via JDBC): regression in Oracle tests

Fixed default catalog name.

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.

All Talend Data Catalog licenses

QlikView: extra columns in QVD

Fixed the issue.

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.

All Talend Data Catalog licenses

Apache Cassandra NoSQL Database: miscellaneous option -backup does not work

Added support for backup/restore.

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.

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.

All Talend Data Catalog licenses

IBM Netezza Database (via JDBC): duplicate tables and views for the scanned schemas

Fixed column duplication.

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.

All Talend Data Catalog licenses

SAP PowerDesigner PDM: Unnamed Objects are extracted for View Reference, Foreign Key and Association

.

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.

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.

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.

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.

All Talend Data Catalog licenses

Microsoft SQL Server Reporting Services (SSRS) (Repository): could not log into Report Server URL

Added SSL support.

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.

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.

All Talend Data Catalog licenses

Talend Data Integration export / IBM InfoSphere DataStage: java.lang.NullPointerException

Improved export of Joblets.

Microsoft Azure Cosmos DB NoSQL Database: Test button works incorrectly

Added database check while testing.

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.

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

Fixed the issue.

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

Improved the FAQ section of the bridge documentation.