Embedding Qlik Analytics in SharePoint

[Troy_Raney]

This Techspert Talks session covers:

• Qlik Cloud settings for SharePoint embedding
• Using JWT Authentication
• Using Anonymous Access

Chapters:

• 01:14 - Qlik Tenant Settings when using JWT
• 02:14 - JWT Authentication architecture
• 02:49 - Content Security Policy
• 03:48 - Web Integration
• 04:46 - Building the authentication script
• 06:00 - JWT Decoder
• 07:11 - Web Server Settings
• 07:43 - SharePoint Settings
• 09:32 - Building a dynamic script
• 10:21 - Anonymous Tenant settings
• 14:00 - Embedding from Anonymous
• 16:02 - Q&A: How often should the token be renewed?
• 16:27 - Q&A: How can a tenant in Sweden affect performance?
• 17:14 - Q&A: Does Section Access work with JWT authentication?
• 17:52 - Q&A: Is this part of Qlik Embed?
• 18:56 - Q&A: What authentication options are there?
• 19:44 - Q&A: Is this the same for Qlik Sense Enterprise?
• 20:43 - Q&A: How much is an Anonymous Tenant?
• 20:58 - Q&A: Does Qlik offer services to help setup?
• 21:23 - Q&A: Can you publish apps to a different tenant?
• 22:11 - Q&A: How troubleshoot a failed login error?

Resources:

• Anonymous Access documentation
• Qlik Embed parameters
• Anonymous Access Embed Tutorial
• Qlik Anonymous Access subscriptions
• Sharing app content with anonymous access
• Embedding a visualization or a sheet in a web page
• SPFX Web Parts
• Why Qlik Embed
• Qlik Sense for Windows: All you need to know to start using iFrames/Mashups
• How to contact Professional Services

Q&A:

Q: Is there any difference between anonymous users access and ad-hoc generated anonymous users?

A: Ad-hoc generated anonymous users was a way to “simulate” anonymous user access before the anonymous user feature was implemented. It’s using JWT authentication to generate on the fly random username and make it seem as it’s anonymous.

Q: We have Entra Id IDP, could this work instead of JWT?

A: No, SharePoint blocks the redirection to log in to Entra Id when it’s embedded.

Q: Is this also possible to embed Qlik Answers with an iFrame? And if yes what needs to be prepared on Qlik Cloud and on SharePoint?

A: This is a relatively new offering, but it is possible. There are two methods for embedding Qlik Answers Assistant: 1. Using Qlik Embed and 2. Full code integration using Qlik APIs. Here is a Qlik Community post with more information

Q: Is this SharePoint embedding possible on on-prem (Client-Managed) version?

A: Yes. The basic principle is actually pretty similar. You would have to set up a virtual proxy, and all the things around that to actually embed into SharePoint. You have a bit more option when it comes to the authentication part; which you have Ticket, you have Header, and then you have JWT and Anonymous also.