Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have QLik replicate 2022.11 version currently. I need to upgrade the version to 2023.5 (latest version). I would like to understand whether we can do downgrade install ie again from 2023.5 to 2022.11 in case of any issue? If so , what is the steps?
i) As per the release note, it is necessary to uninstall the current version and install the version needed. In that case, will that impact the existing setup and all configurations ? what about license? Whether it is required to do license again after uninstall?
ii) If i want to stop all the task in qlik replicate before installation/uninstallation, what is the process for stopping and starting all task in one go (without any manual process)
Thanks,
Mythili Boopathy
Hi,
I came across a scenario where the passthrough filter is surprisingly slower than the table filter in full load. What are the scenarios which can cause this to happen?
My understanding is that the passthrough filter offer greater performance as it alters the actual select statement sent to the source endpoint.
Regards,
Mohammed
We are running our replicate on windows server with Standard_E8s_v3 size. There will be two tasks always running on the server.
One will always be in CDC mode and other runs full loads 3 times a day and continues in CDC mode remaining time.
The issue we are seeing is when there is a full load running on the second task the CPU is in upwards of 80% and there is a latency on the CDC task.
I heard that when a task is in full load each table will occupy 1 CPU , is it correct ? and each task will need 1 cpu when it is running
Hi,
I have run into some interesting behaviour while I was doing some testing. I have a task that goes from Oracle to SQL server with one table only. The source table and target tables don't have any primary key or unique indexes defined on them. However, in Replicate -> Table Settings -> Transform, I've defined a combination of three columns as keys.
I tested inserting some duplicates on the source database however these duplicates are not applied to the target database, even though the target has no primary key or unique index defined on it. How exactly does this work? How does Replicate identify duplicates? Does it read the incoming records then compare them against the target table to decide whether or not to apply them? Is this less performant than having the actual PK/Unique Index on the target table? Please help me understand how this works, it is appreciated as always. Thanks.
Regards,
Mohammed
Using Nov 2022 Qlik Replicate Version from Oracle 19c to Snowflake on AWS.
We are taking data from an application table and creating a hash on the concatenation of the key columns eg:
ifnull(colA,'')||ifnull(colB,'')||ifnull(colC,'') for all key columns and then set the hash of this as our primary key in snowflake (Target). However, I see that when a record gets updated, QLIK tries to set the target key column as null. This calls a not null constraint on our Snowflake DDL.
Our source has the same 3 columns as a unique index, but we hash and concat them into our solo target key.
Is there any way around having QLIK temporarily set the column to NULL or should we remove the not null constraint on our target table? The exception table is showing that is it updating our hash_key to null where hash_key = theoldvalue.
I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_name_1 and it is replicating with the same name with "_1" which is different name like in the source. I would like to handle it somehow. In old qlik every table was represanted like schema.table_name and it was not any issue when few schemas had the same table names.
Hi team ,
I had complied a UDF and generated dll and .so file . when I followed the steps from Document , i couldn’t see my UDF in qlik under expression builder>>functions>>UDF .
need some help on this . please let me know if additional details needed
followed this .
https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/user_defined_transformations.htm#:~:text=the%20Expression%20Builder-,User%2Ddefined%20transformations,%3CINSTALL_DIR%3E%5Caddons%5Csamples%5CMyTransformation,-Information%20note
Anyone have luck getting the Qlik Mobile App to generate a CSRF API call successfully? Seeing no issues using the call on desktop and mobile browser but when using the Qlik Mobile App, the CSRF call doesn't return a token.
I submitted a support ticket but it was suggested to post here as well.
Hi,
I have a number of periods and intervals in a generic day-month format. My challenge is how to calculate the number of days an interval intersects with a period as per the example table below.
I have tried with the DayNumberOfYear() function, which works fine as long as I'm in the same year, i.e. line 1, but when intervals and periods span over 31-dec, as per line 2 & 3, this approach is no longer giving correct results.
period_start | period_end | interval_from | interval_to | #intervall_days_in_period |
12-dec | 20-dec | 01-dec | 15-dec | 3 |
05-dec | 20-jan | 20-dec | 10-jan | 21 |
25-dec | 15-feb | 20-jan | 01-mar | 27 |
Any assistance on how to solve this is highly appreciated. Regards//Peter
PS. interval_from & interval_to are user input hence solution need to be outside of the script.
The user has the following question:
Hello, I need to configure a condition in which the email is only triggered when my condition is satisfactory.
In my case, it will only send the email to those who are experiencing delays in the process.
When there was no such situation = late, the email should not be sent.
It happens that when the condition is satisfactory, it is sending an email without the attachment but with the email body message and the error message
In this case, the email was not supposed to be sent, as the condition is different from "Delayed"
Is this Qlik's default behavior?
Best Regards,
Junior de Sousa
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row.
Apply by December 16 to showcase your expertise and become a Qlik Lumbiary or Qlik Partner Ambassador!
Seamless Public Data Sharing with Qlik's New Anonymous Access Capability
With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!