As part of a scheduled maintenance for Qlik Community, there will be a downgraded experience while managing your support cases on Tuesday, December 12 during a span between 4-8 hours. We will share updates when complete. During this time, you will be able to view your cases, but will not be able to add comments or create a new case. Our support engineers will still have access to view and manage your cases and can make updates as needed on your behalf. If you are experiencing any issue during this window, please contact us via chat. You will be able to access our chat and can be connected to an engineer by using our Support Chat on the Qlik Community Support Page. For Production Down Severity 1 Issues, please use our Critical issue chat line for urgent assistance. Choose Alert Here on our Support Page’s Critical Issue card. Thanks, Qlik Support ...View More

Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts. Next Thursday, December 14th Qlik will host another Techspert Talks session, and this time we are looking at Exploring Data Essentials with Qlik Cloud. But wait, what is it exactly?Techspert Talks is a free webinar held every month, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today. In this session, we will cover: Navigating the Qlik Cloud Hub Leveraging Collaboration tools Best practices for finding insights Click on this link to choose the webinar time that's best for you. The webinar is hosted using ON24 in English and will last 30 minutes plus time for Q&A.Hope to see you there!! ...View More

Don't miss our previous Q&A with Qlik!Hear from our panel of experts to help you get the most out of your Qlik experience. Our Qlik experts offered creative solutions to your analytics demands and answered your visualization questions. SEE THE RECORDING HERE ...View More

Great news! Qlik has recently introduced conversational analytics in Microsoft Teams. With our new Teams app, you can easily chat with Insight Advisor, Qlik's intelligent AI assistant, to explore data using natural language directly within Teams. Users can now ask questions through individual or group chat, and Qlik will respond with AI-generated data visualizations and insights using data from across your Qlik apps. And because it's Microsoft Teams, you can collaborate with others in real-time, collectively making decisions using the insights generated by Qlik. Insight Advisor within Teams provides a powerful new way to help more people find the right answers, make better decisions and collaborate together where and how they work. Look for the Qlik app in the Teams App Store to get started. Want to know more about Qlik's Conversational Analytics in Microsoft Teams? We have put together resources to help you get started. Video tutorials (SaaS in 60): Introduction to Qlik Conversational Analytics in TeamsMicrosoft Teams Integration Setup - Part 1Microsoft Teams Integration Setup - Part 2 Qlik Documentation: Accessing Insight Advisor Chat through external collaboration platformsExploring app content with conversational analytics in Microsoft TeamsManaging connections to external collaboration platformsAvailability of the Qlik chatbot app in Microsoft Teams Thank you for choosing Qlik,Qlik Support ...View More

Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts. The Techspert Talks session from November looked at Using Kafka with Qlik Replicate. But wait, what is it exactly?Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today. In this session, we will cover: How Replicate works with Kafka Kafka terminology Configuration best practices Click on this link to see the presentation ...View More

Welcome to October's Qlik Data Integration newsletter. Each month, we cover one endpoint and share our top resources, best practices, release updates and upcoming webinars. Subscribe to theQlikData Integrationtopic to be notified of future editions! Index WebinarResource HighlightsReminder: Qlik Replicate November 2023 and FIPSKnowledgebase ArticleEndpoint Spotlight: SAPNew Issues ReportedTips!Best PracticeRelease UpdatesFixesUpcoming EnhancementsTroubleshooting tipsAnalyze Qlik Replicate LogsQlik Replicate End of Life Versions Webinar Book your calendar for the upcoming Q&A with Qlik: Qlik Replicate Sources and TargetsQ&A sessionscheduled forOctober 24th (tomorrow!) at 10:00 AM EDT. It is a live Q&A session with a panel of Qlik experts. Bring your questions, and we do our best to answer them. Resource Highlights Reminder: Qlik Replicate November 2023 and FIPS The November 2023 release of Qlik Replicate is not yet FIPS compliant. If you require a compliant environment, remain on the already FIPS compatible versions. See Qlik Replicate November 2023 and FIPS: Release not yet FIPS compliantfor details. Knowledgebase Article Endpoint Spotlight: SAP Find our latest knowledge base articles for SAP endpoints. New Issues Reported Qlik Replicate: Replicating from SAP DB Source changing the precision on Currency Data Type to the Target Currency data from SAP appears to replicate incorrectly when source values are compared to the target system. See Qlik Replicate: Replicating from SAP DB Source changing the precision on Currency Data Type to the Target for details. Qlik Replicate SAP Application (DB) Cluster Tables missing data in the Target SAP Cluster Tables has missing data in the Target during CDC process. See Qlik Replicate SAP Application (DB) Cluster Tables missing data in the Targetfor details. Tips! Qlik Replicate Trigger SAP HANA conversion from Version 1 to Version 2 or Version 3 The Qlik Replicate SAP HANA source endpoint allows you to convert to using the log table with CDC changes. This article documents how to convert the existing triggers into Version 2 or CTS Mode Version 3. SeeQlik Replicate Trigger SAP HANA conversion from Version 1 to Version 2 or Version 3for details. Contact Qlik Support if you plan to convert your triggers, as additional migration steps may be needed to avoid data loss. Best Practice Qlik Replicate SAP HANA Trigger Base using SAP Application (DB) as the SourceQlik Replicate can now use SAP HANA as the Backend Database, which you can define on the SAP Application (DB) Source Endpoint setting with Triggers in SAP HANA. Release Updates Fixes Qlik Replicate May 2023 Patch 3(Build 2023.5.413) Jira issue:RECOB-7506Type:IssueComponent/Process: SAP Application (DB)Description: When the last batch contained operations on clustered tables, some changes would sometimes not be captured after detach/attach or stop/resume. Jira issue: RECOB-7477Type:IssueComponent/Process:SAP Extractor SourceDescription: An ABORT of a delta extractor job during change capture would result in a table being suspended, instead of a recoverable error. Jira issue: RECOB-7456Type: IssueComponent/Process: SAP ODPDescription: When unloading failed, it would be reported as completed instead of failed. Jira issue: RECOB-7440Type: EnhancementComponent/Process: SAP ODPDescription: Added support for CDS views that have mandatory parameters. Jira issue: RECOB-7414Type:IssueComponent/Process:SAP Extractor SourceDescription: Import of the Transport to a SAP Application Server would fail due to vulnerability issues. Jira issue: RECOB-7415Type: IssueComponent/Process: SAP ODPDescription: When Current Data mode was enabled, Full Load would not replicate any records and the following error would occur during CDC:java.lang.String incompatible with java.math.BigDecimal Qlik Replicate May 2023 Patch 2(Build 2023.5.322) Jira issue:RECOB-6976Type:EnhancementComponent/Process:SAP HANA Source (Trigger CTS mode)Description:Added support for a configurable sleep interval after an empty Trigger Table session. Jira issue:RECOB-7390Type:IssueComponent/Process:SAP Extractor SourceDescription: When Extractor unload job failed or was canceled on the SAP side, the extractor status would be changed to Completed instead of Suspended. Jira issue:RECOB-7323Type:IssueComponent/Process:SAP Extractor SourceDescription: When a specific Extractor Full Load was aborted, the next Full Load would replicate the data retrieved by the aborted Extractor Full Load. Jira issue:RECOB-7348Type:IssueComponent/Process: SAP Application (DB)Description:SAPPool table numeric values less than 0.1 would be replicated incorrectly. Jira issue:RECOB-7334Type:IssueComponent/Process:SAP ODP SourceDescription: Scheduler log messages would show an incorrect data set name and wrongly formatted time. Jira issue:RECOB-7262Type:IssueComponent/Process:SAP ODP SourceDescription:Data conversion problems would result in task failure or incorrect data replication. Jira issue:RECOB-7158, RECOB-6925Type:IssueComponent/Process:SAP Extractor SourceDescription:This resolves the following issues: DELTA per table would only start after all Full Loads completed Reloading a table would prevent all DELTAs An error in a table during Full Load would prevent DELTAs from scheduling Jira issue:RECOB-7308Type:IssueComponent/Process:SAP HANA Source (Trigger mode)Description: After applying a transport for maintenance to ACDOCA all CDC INSERT and UPDATE activity would be replicated as DELETEs. Upcoming Enhancements Qlik Replicate November 2023 IR Expose stream buffer tuning parameters in task settings (Replicate & QEM - Expose stream buffer tuning parameters in task settings) Confluent Schema Register using BOTH authentication methods (Public Key + Username & password) Snowflake - Support Transactions in Upsert Mode Boolean Data Type support for PG sources and Bit support for SQL Server targets Google BigQuery - Secure current authentication (no longer have credential files on customer file system) Aurora PostgreSQL source - without the "superuser" role certification Azure Database for MySQL Flexible Server - Source & Target Certification MariaDB 10.6 to 10.11 versions on MySQL - certification MariaDB 10.6 version on Amazon RDS - certification Google Cloud SQL for MSSQL Source endpoint Databricks 12.2 LTS Certification Databricks Serverless SQL warehouse certification SingleStore 8.X Target certification Troubleshooting tips Analyze Qlik Replicate Logs An evergreen pair of articles helps you read and analyze Qlik Replicate log files: How to analyze a Qlik Replicate logList of the error types in Qlik Replicate Qlik Replicate End of Life Versions Version Release Date End of Support Date Qlik Replicate May 2023 May 9, 2023 May 9, 2025 Qlik Replicate November 2022 November 8, 2022 November 8, 2024 Qlik Replicate May 2022 May 10, 2022 May 10, 2024 Qlik Replicate November 2021 November 8, 2021 November 8, 2023 Qlik Replicate May 2021 May 11, 2021 May 11, 2023 Qlik Replicate November 2020 November 10, 2020 November 30, 2022 Qlik Replicate April 2020 (6.6) April 16, 2020 April 30, 2022 Qlik Replicate 6.5 November 14, 2019 November 30, 2021 Qlik Replicate 6.4 April 1, 2019 April 14, 2021 Qlik Replicate 5.5 August 1, 2017 November 30, 2020 For more information, see Qlik Product Lifecycles. ...View More

Don't miss our next Q&A with Qlik! Pull up a chair and chat with our panel of experts to help you get the most out of your Qlik experience. Let our Qlik experts offer solutions, best practices and tips regarding your various Qlik Replicate sources and targets. See the recording here Qlik Global Support ...View More

QlikView May 2023users can now upgrade toService Release 1 (SR1)by logging into Qlik Community with their Qlik Account and visiting ourdownloads siteto install the latest version. This upgrade includes: Multiple resolved defects, such as fixes with drill-downs on calculated dimensions, and issues with quoting characters in CSV files, and more! Check out all the product upgrade details (including a list of fixes) in ourRelease Notes QlikView May 2023 SR1. Thanks for choosing Qlik! Qlik Global Support P.S. use the below filters to find the latest QlikView Service Release on ourDownload's site! ...View More

Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts. The Techspert Talks session from October was our first public Visualization Day! But wait, what is it exactly?Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today. In this session, we will cover: Future Visualization Updates New Layout Container Dynamic Linking with Bookmarks Click on this link to see the presentation ...View More

Welcome to September's Qlik Data Integration newsletter. Each month, we cover one endpoint and share our top resources, best practices, release updates and upcoming webinars. Subscribe to theQlikData Integrationtopic to be notified of future editions! Index WebinarResource HighlightsQlik Replicate November 2023 and FIPSKnowledgebase ArticleEndpoint Spotlight: DB2New Issues ReportedTips!Best PracticeRelease UpdatesFixesUpcoming EnhancementsTroubleshooting tipsAnalyze Qlik Replicate LogsQlik Replicate End of Life Versions Webinar Book your calendar for the upcoming Q&A with Qlik: Qlik Replicate Sources and TargetsQ&A sessionscheduled forOctober 24th at 10:00 AM EDT. It is a live Q&A session with a panel of Qlik experts. Bring your questions, and we do our best to answer them. Resource Highlights Qlik Replicate November 2023 and FIPS The November 2023 release of Qlik Replicate is not yet FIPS compliant. If you require a compliant environment, remain on the already FIPS compatible versions. See Qlik Replicate November 2023 and FIPS: Release not yet FIPS compliantfor details. Knowledgebase Article Endpoint Spotlight: DB2 Find our latest knowledge base articles for DB2 endpoints. New Issues Reported Qlik Replicate and R4Z after upgrade to 2023.5 SP02: additional download requiredThe Qlik Replicate service pack 02 release for 2023.5 includes old R4Z installation files from the previous SP01 build. To upgrade the R4Z component, additional files need to be downloaded and installed. See Qlik Replicate and R4Z after upgrade to 2023.5 SP02: additional download requiredfor details. SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation.Qlik Replicate with a DB2 z/OS source endpoint (using R4Z) displays authorization and privilege errors. SeeQlik Replicate DB2 z/OS - [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: 42501 NativeError: -551 Message: [IBM][CLI Driver][DB2] SQL0551Nfor more information and how to resolve the issue. Tips! R4Z Db2 mainframe install is completed but no Changes are coming throughCheck that the Tables you wish to be performing CDC replication upon, have been "turned on" for capturing the changes from the DB2 z/OS Logs. SeeQlik Replicate: R4Z DB2z No CDC coming throughfor details. Qlik Replicate DB2 z/OS task may stop/fail withR4DB2: ALL CB ENTRIES ARE IN USEThis means that a task is trying to start, but the maximum number of R4Z Control Blocks (in the R4Z CDC service environment on the mainframe) is in use. Find the resolution in Qlik Replicate: DB2 z/OS R4Z [SOURCE_CAPTURE ]W: R4DB2: ALL CB ENTRIES ARE IN USE. Best Practice Match R4Z and Qlik Replicate versionsThe Qlik Replicate and R4Z versions you install must be part of the same release, which can either be an initial release or a patch/service release. This means that if you upgrade Qlik Replicate, you must also upgrade your R4Z installation (to the version that correlates with the Qlik Replicate release you are installing), unless it has the same build number as your currently installed R4Z. Note that despite being part of the same release, the Qlik Replicate and R4Z build numbers (reflected in their file names) might not be the same. For example, Qlik Replicate May 2022 SR2 includes the following files: QlikReplicate_2022.5.0.499_X64.zip (the Replicate installer) QlikReplicate_2022.5.0.290_r4z.zip (the R4Z installer). How to avoid WLM tasks being cancelled due to Work Load Manager Policy settingsWhen installing and using the DB2 z/OS endpoint in Qlik Replicate, WLM tasks on the mainframe may get cancelled. There are multiple root causes for this, but a common one can be addressed by reviewing the execution priority (WLM settings).See Qlik Replicate and R4Z: Best practice to ensure DB2 z/OS Workload Manager (WLM) tasks are not cancelledfor details. Release Updates Fixes Qlik Replicate May 2023 Patch 3 ID:RECOB-7408Type: IssueComponent/Process: IBM DB2 for z/OS SourceDescription: The capture process would not recover from a communication error in the metadata connection. ID:RECOB-7385Type: IssueComponent/Process: IBM DB2 for z/OS SourceDescription: The following ambiguous warning message would sometimes be issued when resuming a task:Transaction <> was committed after the Full Load started and the BEGIN TRANSACTION statement was not captured.ID: RECOB-7220Type: IssueComponent/Process: DB2 z/OS SourceDescription: DB2 would sometimes abend in a data sharing environment when tasks moved back and forth between LPARs. Qlik Replicate May 2023 Patch 2ID: RECOB-7311Type: EnhancementComponent/Process: IBM DB2 for z/OS TargetDescription: Performance was improved when using the zload utility to load files. ID: RECOB-7146Type: IssueComponent/Process: IBM DB2 for z/OS TargetDescription:The task log would display the following incorrect warning when replicating from IBM DB2 on z/OS 13.1 (which is certified):Replicate has not been certified to work with DB2 z/OS version '13.01.0005', and therefore any issues you may encounter with this version are not covered by your license agreement. ID: RECOB-7114Type: IssueComponent/Process: IBM DB2 for z/OS TargetDescription: The R4Z DO4GRANT JCL was updated to grant the R4Z user permissions on the SYSIBM.SYSTABLEPART and SYSIBM.SYSPARMS tables. Upcoming Enhancements Qlik Replicate November 2023 IR Expose stream buffer tuning parameters in task settings (Replicate & QEM - Expose stream buffer tuning parameters in task settings) Confluent Schema Register using BOTH authentication methods (Public Key + Username & password) Snowflake - Support Transactions in Upsert Mode Boolean Data Type support for PG sources and Bit support for SQL Server targets Google BigQuery - Secure current authentication (no longer have credential files on customer file system) Aurora PostgreSQL source - without the "superuser" role certification Azure Database for MySQL Flexible Server - Source & Target Certification MariaDB 10.6 to 10.11 versions on MySQL - certification MariaDB 10.6 version on Amazon RDS - certification Google Cloud SQL for MSSQL Source endpoint Databricks 12.2 LTS Certification Databricks Serverless SQL warehouse certification Troubleshooting tips Analyze Qlik Replicate Logs An evergreen pair of articles helps you read and analyze Qlik Replicate log files: How to analyze a Qlik Replicate logList of the error types in Qlik Replicate Qlik Replicate End of Life Versions Version Release Date End of Support Date Qlik Replicate May 2023 May 9, 2023 May 9, 2025 Qlik Replicate November 2022 November 8, 2022 November 8, 2024 Qlik Replicate May 2022 May 10, 2022 May 10, 2024 Qlik Replicate November 2021 November 8, 2021 November 8, 2023 Qlik Replicate May 2021 May 11, 2021 May 11, 2023 Qlik Replicate November 2020 November 10, 2020 November 30, 2022 Qlik Replicate April 2020 (6.6) April 16, 2020 April 30, 2022 Qlik Replicate 6.5 November 14, 2019 November 30, 2021 Qlik Replicate 6.4 April 1, 2019 April 14, 2021 Qlik Replicate 5.5 August 1, 2017 November 30, 2020 For more information, see Qlik Product Lifecycles. ...View More