Note: The steps below illustrates and further details the main configuration steps mentioned in the video above.
Qlik Sense Configuration:
In order for the server running QlikView Distribution Service (Publisher, QDS) to connect to the Qlik Sense machine, three settings need to be changed on the Qlik Sense server:
Configuring the Qlik Sense Repository to accept connections from Publisher
Note: This setting may have only been needed on earlier versions of the Unified Hub deployments and may not be needed in newer versions of Qlik Sense and QlikView. Starting with all Qlik Sense services in a stopped state, complete these steps:
Open Notepad.exe (or your preferred text editor on the server) as administrator
Open the Repository.exe.config file in Notepad
By default this file is located in C:\Program Files\Qlik\Sense\Repository\Repository.exe.config but this file will live in the install location for Qlik Sense, which is configurable.
Change the SharedContentEnabled key present in the config file from false to true, like so:
Note: If the line is not present just add it like the example below.
Save the file
Start Qlik Sense services
Configuring security rules to allow users to view QlikView documents
The next step will be to configure the appropriate security rule in order to allow users to view the documents which will be published.
In the QMC, go into the Security rules section, and select Create new to create a new security rule
Give the security rule a name (in this example it is named Unified Hub (from QVS))
For the Resource filter, use the filter SharedContent_*
For the Action, grant the action Create
For the Condition, enter the condition that you want to use. In the example below of access is granted to all authenticated users indicated by the QlikView Publish task under Named Users, but further customization here may be needed depending on the use case for the environment
For the Context, set to Only in hub.
An example of this security rule is as follows:
Exporting the certificates for the Publisher machine to establish trust
The next step will be to export a set of certificates from Qlik Sense for use by the Publisher machine for use in establishing trust for the distribution.
In the QMC, go to the Certificates section
Under Machine name enter the fully qualified domain name (FQDN) of the server running the QlikView Distribution Service
Create a password for the certificates
Select the checkbox to include the secret key on the exported certificate
Use the default option of using Windows format for the exported certificates
Select Export certificates
Navigate to C:\ProgramData\Qlik\Sense\Repository\Exported Certificates and copy the exported certificates to the server running QlikView Distribution Service.
Importing the Qlik Sense certificates
On the Publisher server:
Login as the service account / run MMC as the service account
You can use the runas /user:domain\username mmc command in cmd.exe if you need to execute MMC as the service account
Note that sometimes a non-unicode character can be entered when directly copying from MMC; pasting this thumbprint to a separate notepad window then copying from that notepad window should avoid this. Make sure to use the Backspace and Delete keys to remove the invisible character.
<add key="QVWSMachineName" value="the value for the server connection in QMC > System > QVWS > Select QVWS > AccessPoint > Server Connections > Name" />
The resulting file will look like this:
Start the QDS service
Configuring the Distribution task to distribute to Qlik Sense
Setup a distribution task to distribute to Named Users and specify the users or groups
On the Document Information Tab on the distribution task, add in the following attribute:
Run distribution task
Validation & limitations
At this point the distribution should complete successfully and now you should validate that things appear as expected on the Qlik Sense side. Assuming that you’ve distributed the document to at least the user account that you are using then you should see the document appear in the QlikView documents section of the Hub which should have magically appeared:
If you are encountering further issues, then contact Qlik Support for a deeper level of troubleshooting.
Currently it is not possible to un-publish all document links from the Qlik Sense Hub. The publish task in QlikView needs to have at least one Named User as destination in order to allow for the task to run successfully. This removes the document links for other users and leaves it to the single user assigned to the Named User field in the Publish task. As a workaround, you can delete distributed reports for the single user via Qlik Sense hub by right-clicking > Delete.
Currently it is not possible to distribute a document hosted on a HTTPS enabled QVWS / IIS. The QVWSMachineName value in the QDS config is hard-coded to direct users to http:// rather than potentially https://