New features and improvements
| Feature | Description | Available in |
|---|---|---|
| Miscellaneous parameters: standardization of ETL post processing options with user-friendly long names | The ETL post processing options have been improved with user-friendly names, such as -ppus renamed with -etl.summary.add.ultimate. |
ⓘ 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 HANA Database (via JDBC): new support for data profiling and sampling for calculation views | The bridge now supports the data profiling and sampling for calculation 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 |
| Microsoft ADLS Gen2: new support for Managed Service Identity (MSI) authentication | The bridge now supports the Managed Service Identity (MSI)
authentication:
|
ⓘ 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 parameters: standardization of options with user-friendly long names | The existing options have been improved with user-friendly names, such as -j renamed with -java.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 |
| Oracle SQL DML (PL/SQL) Script: support for File as a connection | The initial lineage for the file related API has been added. |
|
| Talend Data Integration: new support for tRedshiftUnload | The tRedshiftUnload component (query command/schema) 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 SQL Server (via JDBC): expression parsing / new support for CALL name | The CALL name 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 |
| Talend Data Integration: expression parsing / new support for question marks 'where ISCL_SOK = ?' | The question marks are 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: expression parsing / new support for variables | The variables such as @[var] are now supported. |
|
| Oracle Business Intelligence (OBI) Enterprise Edition (Server): improved expression parser | The expression parser has been improved to detect lineage of the SELECT tables. |
|
| Denodo Virtual DataPort: new backup miscellaneous parameter | The -backup parameter 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 |
| Amazon S3 Storage: improved the Root directory parameter description | The Root directory parameter description has been updated to reflect five levels of browsing depth. |
ⓘ 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: new support for data profiling and sampling | The bridge now supports the data profiling and sampling. |
ⓘ 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 |
| Change detection for import bridges: improved the checksum stability | The checksum stability has been improved for the QlikSense, IBM InfoSphere Data Architect and SAP BW import 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 |
| IBM Infosphere Data Architect (IDA) | The import of the RelationshipProjection association and the searching of Entity have been improved. If the generalization relationships contain a 'href' tag, it will be skipped. |
|
| Hadoop Hive (via JDBC) import bridges: new support for Metastore on SQL Server | Hive Metastore is now supported on 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 |
| SAP BusinessObjects import bridges | The error handling has been improved for these bridges. The session ID is now displayed as debug log message. |
|
| Talend Data Integration and Microsoft Data Lake Storage import bridges: improved import by merging duplicate tables/schemas | Talend Data Catalog now merges tables/schemas duplicated due to a case sensitivity issue into one table/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 |
| Microsoft Azure Data Lake Storage Gen2: new support for Shared Access Signature (SAS) authentication token | The Shared Access Signature (SAS) authentication token 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 |
| Talend Data Integration / Microsoft Data Lake Storage: model stitching | A container has been added to the connection 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 |
Notable fixes
| Issue | Description | Available in |
|---|---|---|
| Talend Data Integration: lineage will not be made when tDBRow uses an asterisk in query | Added the support for the 'propagate recordset' feature. |
ⓘ 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 (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: import failing with 'java.lang.NoSuchMethodError | Fixed the ResolveParameter() signatures. |
|
| Denodo Virtual DataPort: cannot show schema name and view | Fixed searching of database DB2. |
ⓘ 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 |
| Teradata DML Script (TPT): no tables | Improved the support for the APPLY operator. |
|
| Java based export bridges: new miscellaneous parameters | Added miscellaneous parameters to the Java based export 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 |
| SAP PowerDesigner: failing with Access Violation (C0000005) | Fixed the double attributes in an association. |
|
| Database (via JDBC) import bridges: data sample shows several same rows | Fixed the duplicate records in the data sampling. |
ⓘ 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 (or not supported) | Fixed the parsing log file. Added support for the "section" keyword and the backup functionality. |
ⓘ 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: unnecessary S3 folder created when Access key is encrypted | Removed the extra slashes coming from the access key property used in the connection name. |
ⓘ 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 S/4HANA / ECC: Model is not consistent | Removed invalid FKs. |
|
| Apache Atlas: GUIDs are not extracted while processing summary lineage with the -ppus miscellaneous option | Fixed the processing of GUIDs by improving the post-processor and summarizer to customize their behavior for each bridge type. |
|
| Oracle (via JDBC): issue about system release version | Improved the detection of Oracle system release 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 |
| Microsoft SSRS 2012: cannot import a dataset and data source when using a shared dataset to create the reports | Improved the bridge to load external datasets and sources. |
|
| Oracle (via JDBC): The Model is not consistent -Argument must be associated to a Type | Fixed the data 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 |
| SAP BusinessObjects: added support for version 14.3 | Added the support for BusinessObjects version 14.3 (BO XI 4.3). |
|
| Database via JDBC import bridges: issue with the -backup miscellaneous parameter | Fixed the issue to save the backup of a single model if the field of
the Schema parameter contains more than 256 characters. Fixed the issue to restore a single model if the bridge imports several databases. |
ⓘ 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: java.io.FileNotFoundException error with dynamic jobs | Fixed the import errors and improved the error 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 |
| Oracle ODI: test connection fails | Improved I/O exception handling and added a new debug message. |
|
| Microsoft SQL Server (via JDBC): MITI.MIRException: There already exists a COLUMN with the name in the parent TABLE with Case Sensitive DB | Fixed the case-sensitive detection at model level and the model SystemCase property. |
ⓘ 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 |
| Database SQL DML (DI/ETL) Script: incremental import parameter replaced with the -cache.clear miscellaneous option | Replaced the incremental import parameter with the -cache.clear option. |
|
| SAP HANA: database name is always coming as "Database" | Fixed the database name. |
ⓘ 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 |
| Hortonworks Hadoop Hive Database (via HCatalog and Metastore via JDBC): fails with SQL error - ORA-904 on Oracle Metastore | Added the support for Hive Metastore hosted on Oracle. |
ⓘ 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 OBIEE: MBI_OBIEE_E0031: 'com.ctc.wstx.exc.WstxEOFException: Unexpected EOF in prolog at javax.xml.stream | Fixed the IndexOutOfBoundsException error for the invalid FK columns. |
|
| 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 |
| Database SQL DML (DI/ETL) Script (TransactSQL): column propagation | The column lineage of an output table is derived as * from the input table. |
|
| Microsoft SSIS: lineage is breaking in EDC when MITI extracts SQL query as Excel as Source/Target object | Added support for SQL in File Stores. |
|
| Database SQL DML (DI/ETL) Script (TransactSQL): new support for BULK INSERT | Added support for BULK INSERT in SQL Server. |
|