Connecting to Qlik Sense

Connecting to Qlik Sense

Question

How do we connect Digital Hive to Qlik Sense?

Answer

As a Digital Hive administrator, connecting to Qlik Sense can be accomplished via the following steps:

Create a Qlik Sense Certificate

  1. Launch Qlik Management Console (QMC)
  2. Under CONFIGURE SYSTEM, click Certificates
  3. Add machine name of the Digital Hive server, enter a password (in this example: secret), note where the certificate will be exported to and click Export certificates
  4. In File Explorer, navigate to where the certificates were exported too, in this example: c:\ProgramData\Qlik\Sense\Repository\Exported Certificates
  5. Copy and paste the generated certificates to a folder on the Digital Hive server (outside of the Digital Hive install, in this example: c:\Qlikcerts)

Steps to Generate a Java Keystore

  1. Launch Command Prompt as Administrator
  2. Navigate to where the Qlik certificate was placed, in this example cd c:\QlikCerts
  3. Create a client Java keystore by excuting this command (note in this example, secret was the password we created)
    c:\DigitalHive\Java\bin\keytool.exe -importkeystore -srckeystore "client.pfx" -srcstoretype pkcs12 -destkeystore "client.jks" -deststoretype JKS -srcstorepass secret -deststorepass secret -noprompt
  4. Create a server keystore by executing this command
    c:\DigitalHive\Java\bin\keytool.exe -import -alias QlikCA -keystore "root.jks" -file "root.cer" -storepass secret -noprompt

Adding Qlik Sense Connection Settings in Digital Hive

  1. Launch Digital Hive and login with an admin account
  2. Click your avatar (your initials on the top right)
  3. Select Manage Digital Hive
  4. Select Make connections to add content
  5. Select Qlik Sense

  6. Enter a name for the connector, in this example Qlik Sense
  7. For the Authentication Method, select either Qlik Sense User Pass or Qlik Sense SSO, based on what kind of authentication your Qlik Server uses:
    1. If you use Qlik Sense User Pass, in the System Credentials section enter the User Name, Password, and Namespace information

    2. If your server is using Qlik Sense SSO, in the System Credentials section enter User Name and Namespace information

      NOTE: Namespace is the User directory in QMC:
  8. For Your Account enter a user that we can authenticate with to finish the configuration. Assuming, you have a Qlik Sense account, select a different account and enter the Username, Password and Namespace
  9. For Server Information, for Server Type, select Qlik Sense Server and For Base Url, enter the fully qualified name of the Qlik Server
  10. For the Properties section modify any information that is not correct (for example, if you use different ports).  You will have to enter the Certificate Folder, Root Certificate Pass, Client Certificate Pass and Default Namespace

  11. Now you will want to add Qlik Sense content that you want to access in Digital Hive. In this example, I already have other folders added. If this is your first connector, you won't see that.
  12. You don't have to this, but I like to create Folders for each connector and then add content to them. Click to add a new folder
  13. Give the fodler a name, in this case Qlik Sense
  14. Click CREATE FOLDER
  15. Go into that folder, by clicking Qlik Sense. You should now be in the Qlik Sense folder that you created
  16. You should see all the content that you can expose
  17. You can now drag the folders that you want to make available in Digital Hive to the Qlik Sense folder you created. Or if you want to make everything available, you can drag  to the Qlik Sense folder you created. 
  18. Click 
You are now able to display Qlik Sense content to your Hives.



    • Related Articles

    • Connecting to Qlik View

      Question How do we connect Digital Hive to Qlik View? Answer As a Digital Hive administrator, connecting to Qlik View can be accomplished via the following steps: Install the QlikView NTFS Auth Application In your extracted Digital Hive installation ...
    • Selecting a Specific Visual from a Qlik Sense Sheet

      Question There is one specific Qlik Sense visualization that is required for a Digital Hive Unified Dashboard. Do we have to add the entire Qlik Sense sheet, or is it possible to 'extract' just the stand-alone chart? Answer It is possible to access ...
    • Connecting to Microsoft PowerBI

      Question How do we connect Digital Hive to Microsoft PowerBI? Answer As a Digital Hive administrator, connecting to Microsoft PowerBI can be accomplished via the following steps: Open the Digital Hive Control Center Click on the Connectors and select ...
    • Connecting to SharePoint Online

      Question How do we connect Digital Hive to Microsoft SharePoint Online? Answer As a Digital Hive administrator, connecting to Microsoft SharePoint Online can be accomplished via the following steps: Open the Digital Hive Control Center Click on the ...
    • Connecting to Salesforce

      Question How do we connect Digital Hive to the Salesforce CRM platform? Answer Before Digital Hive can successfully connect to Salesforce, a Connected App must first be created within Salesforce Setup. Launch Salesforce Setup Navigate to App Manager ...