19 September 2023 Improvement for error handling Share this message Operators can now recover suspended or failed loads at a table level within the Landing area of the pipeline, with any follow-on tasks reacting automatically to bring the whole pipeline back into sync. More granular control is available to select one or more specific tables to be reloaded, without having to do a full reload of all the tables, bringing greater efficiencies in error handling. Continuing our commitment to improving pipeline performance with automation, when a reload occurs, Storage will automatically run a compare job for you to ensure history is tracked. Monitoring the landing task New Qlik Data Gateway – Direct Access version Qlik Data Gateway – Direct Access 1.5.2 provides support for the new ODBC (via Direct Access gateway) connector as well as improving overall stability and performance. New features and enhancements: Provides support for the new ODBC (via Direct Access gateway) connector. The Version column in the Administration activity center will now display the Direct Access gateway version instead of the RepAgent (one of its sub-components) version. Resolved issues: Upgrading Direct Access gateway would reset advanced ODBC Connector logging settings (such as log file retention and maximum size) to default. In rare cases, the ODBC connector would crash and could not be restarted by the Direct Access gateway agent. When a connection failed or the SQL query was not valid, a generic “Offset and length were out of bounds…” error would be returned instead of the actual error cause. In rare scenarios, hub reloads would fail with a “DirectAccess-4008” error for apps larger than 3 GB that had extended delays or processing after the initial gateway query. Additional logging has been added to assist in identifying any related issues. For upgrade instructions, see Upgrading the Direct Access gateway installation. New ODBC (via Direct Access gateway) connector With the introduction of the ODBC (via Direct Access gateway) connector, customers can now access ODBC data stores from within their Qlik apps, using standard ODBC drivers. As well as providing greater flexibility, the ability to use standard ODBC drivers is especially useful for customers who need to access data stores that are currently not part of Qlik’s extensive offering of built-in connectors. Like existing connectors, this new connector empowers organizations with hybrid data landscapes to securely access, query, and analyze data residing both in the cloud and on local servers. ODBC (via Direct Access gateway) 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