New features and improvements
| Feature | Description | Available in |
|---|---|---|
| Talend Data Integration: "The Model is not consistent" | Support for tOracleSCD has been improved to better set model destination in some cases. |
ⓘ 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 HDFS: common utility for connection configuration | Common utility has been created for HDFS connection configuration. |
ⓘ 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 |
| Databricks Delta Lake Hadoop Hive Database: tables created as “delta” table not showing individual columns | Support for 'delta' table columns 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 |
| Any Database (via JDBC) import bridge / Data profiling: 0 no longer profiles all rows | The limit used to process only the first 100,000 rows has been removed when setting the number of records to profile to 0. |
ⓘ 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 (via JDBC) import bridge: new driver class path option | The option for JDBC drivers location 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 SSRS: extended debug logging | Debug logging has been extended for local/shared DataSets and Data Sources. |
|
| Informatica PowerCenter: support of extracting multiple workflow instances which use concurrent workflow option | Support for concurrent instances workflow has been added. |
|
| AWS RedShift Database: new driver version | The import bridge has been updated to use the latest Amazon RedShift driver version. |
ⓘ 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 |
| PostgreSQL Database SQL DML Script: improved data lineage | Support for the following JSON operators ('->', '-->', '#>', '#>>') has been added to the expression parser. |
|
| Google BigQuery Database: new miscellaneous parameter -driver.location | The new option -driver.location 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 |
| Salesforce import / Erwin DM export: improved data type mapping | "REFERENCE" data type mapping has been updated into
"VARCHAR". Support for "nullable" attribute 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 |
Notable fixes
| Issue | Description | Available in |
|---|---|---|
| Talend Data Integration: wrong module name set when a Job extracts data from Salesforce | Fixed tSalesforceInput processing. |
ⓘ 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 / SAP Sybase ASE Database: stitching issue between target and destination | Added processing of the miscellaneous option -connection.casesensitive. |
ⓘ 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: integration with Talend Data Preparation / Data lineage not showing when using tDataPrepRun component | Fixed data preparation import and renamed action. |
ⓘ 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: connection split needed | Added the new option -connection.split to 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 |
| Tableau: missing links between DB connection and table | Improved connection layer to fix the case sensitivity issue in the stitching process. |
ⓘ 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: support for version 2020 | Added support for Tableau 2020.x. |
ⓘ 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 DataStage: expression syntax not recognized or not supported | Added support for NEXT VALUE FOR in DB2 expression analyzer. |
|
| Cloudera Impala Hadoop Hive Database (via JDBC): harvesting views creates External Schemas | Added support for local connections for Hive bridges. |
ⓘ 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 Power BI (File): "Illegal Argument: The Model already contains a StoreConnection with this PhysicalName" | Improved support for Snowflake and parameters used in Power Query statement for Microsoft SSAS import bridge. |
|
| Any Database (via JDBC) import bridges: external connections processing | Fixed external connection processing. Fixed bridge profiles to support it. |
ⓘ 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: import failed with the error "Consistency: Element 'StoreConnection' has no name" | Added a warning for connections without Connection String. |
|
| Metadata Excel Format export: tables with same business name are not exported | Fixed the issue when exporting tables with the same business
name. Added a new bridge parameter called Include business name and description. |
ⓘ 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 (Repository): support for connection to Amazon Aurora MySQL | Extended the list of the supported data stores with Amazon Aurora. |
ⓘ 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 |
| AWS Athena Database (via JDBC) - Technical Preview: missing views in scan | Improved the processing of template query to control the ResultSet structure. |
ⓘ 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): PIVOT syntax cannot be harvested | Added support for PIVOT syntax with feature definitions to 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 |
| PostgreSQL Database SQL DML (DI/ETL) Script: inferred semantic classification not visible with SQL based ETLs | Improved the expression printer to support pass-through links in SQL Script import bridges. |
|
| MongoDB NoSQL Database (JSON): cannot run import when Databases field is empty | Defined the Databases bridge parameter as an optional field. |
ⓘ 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: missing table in a RedShift connection | Fixed access key processing when the inherit credentials option is selected. |
ⓘ 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: target schema <no name> | Fixed schema processing in the SCD components. |
ⓘ 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 |
| Salesforce (SFDC) Database / data sampling and profiling: invalid XML character (Unicode: 0xfffe) was found in the element content of the document | Added support for the -backup option. Added code to replace invalid XML chars with '?'. |
ⓘ 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 Atlas: does not return all results available for a search | Implemented offset loading of filtered entities and added the miscellaneous parameters -request.limit and -entities.limit. |
|
| Talend Data Integration: "Create temporary table like" by tRedshiftRow does not get table information and connection | Added support for CREATE TABLE LIKE syntax. |
ⓘ 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): environment configuration override does not work properly | Fixed parameter override for parameterized connections. |
|
| Apache Kafka using JAAS PLAIN authentication: "Timeout expired while fetching topic metadata" | Added log message for JAAS JVM properties and improved JVM properties processing. |
ⓘ 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 ADLS Gen2 / MSI authentication: Windows with two managed identities / System Identity and User Defined Identity: "failed with Status code 403: request is not authorized" | Added a note for MSI authentication: For "System assigned managed identity", you should replace the Client-Id with Application-Id from automatically created enterprise application for this virtual machine. |
ⓘ 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 Kafka: unable to connect with SSL handshake error | Added the parameters "Keystore file","Password of the keystore", "Password of the key" to support Kafka ssl.client.auth=required. |
ⓘ 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: when source in Schema for Metadata Excel Format has a slash at the beginning, it will be converted as Working Directory | Improved building of the file path. |
ⓘ 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: stitching issue | Fixed setting of stitching by name or position for Delimited and Hierarchical models. |
ⓘ 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 Power BI (File): support for Microsoft SSAS as a source | For Microsoft PowerBI File import bridge, if the cube parameter is
missing in SSAS live connection, use default perspective name. Added initial support for legacy Oracle driver for Microsoft SSAS import bridge. |
|
| Oracle database (via JDBC): support for PIVOT clause that is followed by JOIN clause | Fixed PIVOT clause that is followed by JOIN 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 |
| Oracle DML: not extracting one table from the script | Fixed the summary lineage to trace until the first connection object instead of far left. |
|