6 August 2024 Refine your in-app subscriptions with dynamic expressions Share this message In-app subscriptions are now more powerful with the use of bookmark capabilities, allowing for dynamic expressions to be used in report creation! When creating and sharing subscriptions, use expression search to filter the data at report generation time based on date expressions, calculated values, and moreā¦ allowing for more accurate reports! Expression search Scheduling reports with subscriptions Not supported in Qlik Cloud Government. Shared data space With the launch of Qlik Talend Cloud we introduced the Starter edition to simplify the experience of creating connections and projects for straightforward replication tasks. As part of this improved experience a data space, called Default_Data_Space, is automatically created in every tenant. This feature is extended to all editions of Qlik Talend Cloud: Starter, Standard, Premium and Enterprise. The owner of Default_Data_Space will be the first admin to enter the tenant, and all users of the tenant will be automatically granted with the following permissions: Can view Can consume data Can edit Can manage Can operate Working in spaces in Qlik Talend Data Integration Qlik Talend Data Integration improvements The following improvements require Qlik Data Gateway – Data Movement 2024.5.7 or later. For upgrade instructions and a list of resolved issues, see Upgrading the Data Movement gateway installation. Enhancements Support for automatic loading of new tables in replication tasks Tables created in the source database during the replication data task that match the include pattern, will now be automatically captured during CDC (Change data capture). Microsoft SQL Server (MS-CDC) source enhancements Timestamp and transaction ID preservation Previously, when reading multiple transactions from Microsoft SQL Server (MS-CDC), Qlik Talend Data Integration would preserve the transaction ID and timestamp of the first transaction only. On the target, this gave the appearance of the records being part of a single transaction. Now, Qlik Talend Data Integration will preserve the original transaction ID and timestamp for each individual record. This benefits customers who wish to leverage the Transaction ID and Timestamp header columns in Change tables. Transaction ID bytes order Previously, the bytes in the transaction ID were encoded in reverse order. From this version, the bytes will be encoded in the correct order. Information Customers who would rather preserve the existing behavior can do so using internal parameters. For details, please contact Qlik Support. Support for caching SHA-2 pluggable authentication with MySQL Qlik Talend Data Integration now supports caching SHA-2 pluggable authentication (caching_sha2_password) when working with MySQL sources or targets, either on-premises or in the cloud. In previous versions, only Native Pluggable Authentication (mysql_native_password) was supported. Amazon Redshift data type mapping changes BYTES and BLOB data types will now be mapped to VARBYTE on Amazon Redshift instead of VARCHAR. Newly certified platforms, endpoints and versions Data sources PostgreSQL 16.x MySQL 8.1 IBM DB2 for z/OS 3.1 Target platforms PostgreSQL 16.x MySQL 8.1 Databricks 14.3 LTS Drivers SQL Server ODBC Driver 18.3 End of support Support for the following database versions has been discontinued: All Oracle versions and drivers earlier than Oracle 19.x Microsoft SQL Server 2014 MySQL 5.7 PostgreSQL 11 IBM DB2 for LUW 10.5 IBM DB2 for z/OS: z/OS 2.3 How can we help? Barry has over 20 years experience as a Data & Analytics architect, developer, trainer and author. He will gladly help you with any questions you may have. Call us Mail us 17 April 2025 The 2025 Masters Summit for Qlik will be in Hamburg, Germany The Masters Summit for Qlik offers the next step in your journey towards becoming a Qlik specialist. In 3 days our team of experts, with over 50 combined years of Qlik experience in the field, will take your skills to the next level. Bitmetric Event Qlik Training 17 April 2025 Graphical transformation flow designer now supported in Qlik Cloud Government Qlik Cloud Government now supports the graphical transformation flow designer from Qlik Talend Data Integration. This no-code tool features a drag-and-drop interface for creating visual transformation flows, making it accessible for both data engineers and non-SQL experts. It offers a range of data transformation processors for cleansing and shaping datasets, and supports major data platforms like Snowflake, Databricks, and Azure Synapse Analytics. Transformation flows also support automated SQL-based capabilities such as materialization and incremental processing. New Release Qlik 17 April 2025 Transformation flows for SQL and Microsoft SQL Server now supported in Qlik Cloud Government Qlik Cloud Government now supports transformation flows for SQL and Microsoft SQL Server. The SQL Expression processor enables writing SQL expressions to process data. Users can create graphical and custom SQL-based transformations in data pipeline projects, enhancing data reshaping capabilities. New Release Qlik
17 April 2025 The 2025 Masters Summit for Qlik will be in Hamburg, Germany The Masters Summit for Qlik offers the next step in your journey towards becoming a Qlik specialist. In 3 days our team of experts, with over 50 combined years of Qlik experience in the field, will take your skills to the next level. Bitmetric Event Qlik Training
17 April 2025 Graphical transformation flow designer now supported in Qlik Cloud Government Qlik Cloud Government now supports the graphical transformation flow designer from Qlik Talend Data Integration. This no-code tool features a drag-and-drop interface for creating visual transformation flows, making it accessible for both data engineers and non-SQL experts. It offers a range of data transformation processors for cleansing and shaping datasets, and supports major data platforms like Snowflake, Databricks, and Azure Synapse Analytics. Transformation flows also support automated SQL-based capabilities such as materialization and incremental processing. New Release Qlik
17 April 2025 Transformation flows for SQL and Microsoft SQL Server now supported in Qlik Cloud Government Qlik Cloud Government now supports transformation flows for SQL and Microsoft SQL Server. The SQL Expression processor enables writing SQL expressions to process data. Users can create graphical and custom SQL-based transformations in data pipeline projects, enhancing data reshaping capabilities. New Release Qlik