Could you please help clarify the following points related to enabling the MS replication-related prerequisites for Qlik Replicate on a Microsoft SQL Server source?

• What is the potential impact of enabling MS replication–related settings on the SQL Server database?

• During initialization, does the process require a full database snapshot, or could it cause table locking or significant I/O spikes, considering the large size of the database?

• How is transaction log usage managed to ensure it does not lead to excessive log growth or disk space issues?

• Are there any expected performance impacts on the source database, particularly for large datasets?

• Will any data or objects be written or modified in the source SQL Server database?

I have mobile numbers and one number can have multiple reference id's so the requirement is when I select one reference id then table should show all reference id with respect to mobile number means mobile number associated with selected reference id. so want to see all reference id with common mobile number after selection of one reference id through filter , example Data:
Load*
Inline [
Reference_ID,Mobile_Number
Ref12345,9999999999
Ref56789,9999999999
Ref98765,8888888888
];

so when select Ref12345 in filter then my table should show result Ref56789,9999999999

Hello everyone,

Google finally set Q3 2024 as the date for 100% blocking all content relying on third-party cookies rendered on web pages in Chrome. At Qlik, the date is not a surprise to us, and to all our customers who embed Qlik Sense, we appreciate your collaboration and patience. 

What does this mean for my embedded analytics?

Qlik has been working hard for two years to prepare our products to handle this change and the impact it has on your end users. We've documented additional information for you, which we believe will help you understand how to best configure Qlik Cloud and Qlik Sense Enterprise Client-Managed and keep embedded analytics working smoothly with your web applications and mashups.

Read all about it in Need to Know: Embedding Qlik Analytics and the End of Third-Party Cookies.

Thank you for choosing Qlik,
Qlik Support

Check out our new Qlik Sense app featured in the Qlik Gallery:

🏥 Unlock transformative insights in healthcare using Qlik Sense with AnyChart's extensions: Decomposition Tree, Gantt Chart, Combo Chart, Sunburst Chart, and Timeline Chart. Dive deep into metrics like admissions, patient counts, and treatment costs. Perform root cause analysis or ad-hoc explorations with ease. Maintain clear, actionable visibility of doctor-patient timelines and track each patient's journey with insightful precision.

Check out the app in the Qlik Gallery:
👉 https://community.qlik.com/t5/Explore-Qlik-Gallery/Healthcare-Dashboard-Oncology/ba-p/2458556

Nebula.js and enigma.js , can we use these to create charts on angular 20 application or we have to use iframe and <qlick-embed > only .Note here I am using a trial version or Nebula.js and enigma.js only we can use with enterprise version .

I am using(Nebula.js and enigma.js) these from localhost angular application to connect qlik cloud trail version(30days).

Kindly clarify .

Hello everyone,

I’m currently using the CrossTable element in Qlik Cloud Reporting Service (PixelPerfect) to build a pivot-like table.

The table itself works as expected, but I’m facing an issue with conditional background formatting. I tried applying a condition.

However, the background color is not applied when using the CrossTable object.

Is there a specific way to handle conditional formatting with CrossTable in PixelPerfect reports?
Are there any limitations or alternative approaches to achieve this?

Thanks in advance for your help!

Dear Qlik Support,

Thank you for assisting with the Qlik Replicate issue.

We are experiencing  source and target throughput limitation to an average of approximately 7,000 kbyte/s,  time  to time  we can reach the pick of  12000 kbyte/sec. We have investigated but have not been able to identify the root cause.

System resources checked

• Application server: 8-core CPUs, 35 GB RAM, 500 GB disk space
• Load balancer server: 2-core CPUs, 3.5 GB RAM No obvious issues were found on either side.

Current data flow

• From Oracle (ODS) to local disk: T_LSS_ODS
• From local disk: S_ODS_LSS to Azure Event Hub Note: Both T_LSS_ODS and S_ODS_LSS reside on the same Qlik application server.

Observation The same throughput limitation occurs for both replication paths: ODS → T-LSS_ODS and S_ODS_LSS → Azure Event Hub ( 20 tasks)  are  running in Batch optimized  .

This suggests the issue may be located at the Qlik Replication server itself. Impact The throughput issue affects a task that replicates a large number of records daily. ( +/- 5 Millions of records ) .

Qlik Replication configuration

• messageKey: SCHEMA_AND_TABLE
• partitionMapping: MESSAGE_KEY
• rdkafkaProperties: ssl.endpoint.identification.algorithm=none; queue.buffering.max.messages=500000; acks=1; linger.ms=100
• sslCAPath: /app/attadm/attunity/replicate/ca-azure.pem
• topic: wlbeodsqlik
• useSSL: true

NB:   There is not message in the Qlik log file related to PERFORMANCE  message  .  what does means no performance problem !!

We would really appreciate your assistance in diagnosing and resolving this throughput issue.

Kind regards,

Youssef

Greetings.
In our Qlik cloud environment, we're pulling users' gsuite accounts via IDP and connecting them to the Qlik environment using those accounts. Users are present in the system along with their email addresses. Our goal is this: instead of pulling individual email accounts, we're pulling the email groups that users belong to, assigning permissions to those groups, and then extending those permissions to everyone in that group. Is this feasible? In our IDP environment, we're using OIDC as the generic type and provider. Perhaps there's another way. The main point is that we want to grant permissions to users based on the email groups their email addresses belong to, not just their individual email addresses.

Thank you all,

Burç.