Talend Cloud Data Catalog and Talend Data Catalog Bridges
New features and improvements
| Feature | Description | Available in |
|---|---|---|
| Microsoft SSIS: new support for nested task variables | Support has been added for nested tasks. |
|
| 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. |
|
| Microsoft SSIS: new support for environment variables | Support for environment variables has been added. |
|
| Talend Data Integration / SQL Override: new multi-statement support | Multi-statement support has been added. |
All Talend Data Catalog licenses |
| Microsoft SSIS: new support for components | Support for versioned components has been added. |
|
| Google BigQuery Database: JDBC driver based new version of the bridge | Support for function arguments has been added. |
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. |
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. |
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. |
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. |
|
| 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. |
All Talend Data Catalog licenses |
| Oracle MySQL database (via JDBC): parser error on CHARSET | Support for CHARSET has been added. |
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. |
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. |
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. |
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. |
|
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. |
All Talend Data Catalog licenses |
| Amazon Athena: custom Athena SQL expression parser | Added support for Athena expression parser. |
All Talend Data Catalog licenses |
| Amazon Athena database (via JDBC): support for schema browsing | Added support for Athena schema browser. |
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. |
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. |
All Talend Data Catalog licenses |
| Talend Data Preparation: "Index of bounds" runtime data flow overview problem | Fixed the lineage cleanup after merging stitched objects. |
All Talend Data Catalog licenses |
| Microsoft SQL Server: SQL parser errors | Improved parameters and variables resolution. |
All Talend Data Catalog licenses |
| Google Cloud Storage: "java.lang.NoSuchMethodError" | Fixed the description of the Root directory parameter. |
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. |
All Talend Data Catalog licenses |
| Metadata Excel Format / Data Mapping: "MITI.MIRException: org.xml.sax.SAXParseException" | Fixed validation errors. |
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. |
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'. |
|
| 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. |
|
| 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 Integration: tMysqlRow does not produce connection when using "Create Index" | Updated the CREATE INDEX statement in the expression analyzer. |
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. |
All Talend Data Catalog licenses |
| Talend Data Integration: "Create table" by tRedshiftRow does not produce lineage | Added support for table attributes DISTSTYLE and DISTKEY. |
All Talend Data Catalog licenses |
| Talend Data Integration: "Create index" by tMysqlRow does not get table information | Added support for CREATE INDEX. |
All Talend Data Catalog licenses |
| Google BigQuery: issue with expression parser for backtick | Resolved backtick issue. |
All Talend Data Catalog licenses |
| Amazon Redshift (via JDBC): function arguments are not extracted | Added support for function arguments. |
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. |
|
| 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. |
|
| Microsoft SSIS: no connection schemas available for the database catalog | Made the comparison of schemas and connection packages case sensitive. |
|
| Talend Data Integration: "Create table" by tRedshiftRow does not get table information | Added support for ENCODE and DISTKEY. |
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 Integration: "Drop table if exists" by tRedshiftRow does not get table information | Added support for "DROP TABLE IF EXISTS". |
All Talend Data Catalog licenses |