Qlik Sense

This guide explains how to connect Qlik Sense to Solid so you can analyze app usage, lineage, and data connection metadata.

Overview

Solid connects to Qlik Sense to read metadata about apps, sheets, data connections, and usage activity, helping you understand app lineage and adoption across your organization. Solid supports both Qlik Sense Cloud (API key authentication) and Qlik Sense Enterprise (certificate-based authentication).

Important: Solid does not modify or publish anything in Qlik Sense. All access is read-only.

Solid needs:

  • Administrative access to your Qlik Sense tenant (Cloud) or the Qlik Management Console — QMC (Enterprise)
  • Permission to create service accounts / API keys, or issue client certificates
  • Access to the streams/spaces containing the apps you want Solid to scan

What Is Collected

CategoryWhatWhy
App and Sheet MetadataApp names, descriptions, and owners; sheet titles and layouts; sheet object types (charts, tables, KPIs) and their master item referencesTo catalog Qlik apps and their sheets for discovery and lineage mapping
Expressions and LineageChart/table expressions (measures and dimensions); data connection strings and load script contents; field-level mapping back to source tables in your data warehouseTo trace how fields in Qlik apps map back to your underlying data warehouse tables
Usage ActivityApp open and sheet view counts; active users and session timestamps, from Qlik's session/audit logsTo surface which apps and sheets are actively used across your organization

Automatic Pull (Recommended)

Option A: Qlik Sense Cloud (Recommended)

Step 1: Create a Service Account

  1. Log into your Qlik Cloud tenant as an administrator
  2. Navigate to Management Console → Users
  3. Create a dedicated user for Solid (e.g., [email protected])
  4. Assign the user a Professional (or equivalent) license and a role with read access to the spaces you want Solid to scan

Step 2: Generate an API Key

  1. Navigate to Management Console → API keys
  2. Click Generate new key, scoped to the Solid service account
  3. Copy and save the key immediately — it will not be shown again

Step 3: Grant Space Access

  1. In each space containing apps you want Solid to scan, add the Solid service account
  2. Grant it the Can view (or equivalent read-only) role

Step 4: Configure Solid

  1. Log into the Solid platform
  2. Navigate to Settings → Integrations → Qlik Sense
  3. Enter:
FieldDescription
Tenant URLYour Qlik Cloud tenant URL (e.g., https://yourcompany.qlikcloud.com)
API KeyThe key generated in Step 2
  1. Click Test Connection
  2. Select which spaces you want Solid to monitor
  3. Click Save

Option B: Qlik Sense Enterprise (On-Premises)

Step 1: Create a Service Account

  1. In the QMC, navigate to Users
  2. Create a dedicated user for Solid (e.g., SOLID_SERVICE)
  3. Assign it a role with read access to the streams containing the apps you want Solid to scan

Step 2: Issue a Client Certificate

Solid authenticates to Qlik Sense Enterprise's Repository Service (QRS) API using mutual TLS.

  1. In the QMC, navigate to Certificates and export the client certificate for the Solid service account (or generate a new one for it)
  2. Securely transfer the certificate and private key to your Solid administrator

Step 3: Configure Solid

  1. Log into the Solid platform
  2. Navigate to Settings → Integrations → Qlik Sense
  3. Enter your Qlik Sense Enterprise server address and upload the client certificate
  4. Click Test Connection
  5. Select which streams you want Solid to monitor
  6. Click Save

Solid will begin indexing your Qlik Sense metadata.


Permissions Needed

Permission/RolePurpose
Administrative access to Qlik Sense tenant (Cloud) or QMC (Enterprise)Required to create the service account and configure access
Professional (or equivalent) license (Cloud)Assigned to the Solid service account
Role with read access to target spaces (Cloud) or streams (Enterprise)Lets the service account view the content Solid should scan
Can view (or equivalent read-only) role, at the space level (Cloud)Grants explicit read access to apps within a specific space
Permission to create service accounts/API keys, or issue client certificatesRequired by the administrator performing the Solid setup

Troubleshooting

Connection Issues

  1. Verify the tenant URL / server address is correct and reachable from Solid's network
  2. Check the API key hasn't expired or been revoked (Cloud), or that the client certificate is still valid (Enterprise)
  3. Confirm the service account is active and not disabled

Permission Issues

  1. Verify space/stream access — the service account needs explicit read access to each space (Cloud) or stream (Enterprise) you want scanned
  2. Check the assigned role includes permission to view apps and their load scripts

Missing Data

  1. Confirm apps are published — unpublished personal apps may not be visible to the service account
  2. Check usage logging is enabled on your tenant/server if usage activity is missing

Security Notes

  • Use a dedicated service account rather than a personal user account
  • Store API keys and certificates securely in a password manager or secrets management system
  • Never commit credentials to version control
  • Rotate API keys and certificates regularly according to your organization's security policies
  • Grant minimum necessary access — only the spaces/streams Solid needs to scan
  • Revoke unused API keys and certificates immediately when they're no longer needed

Did this page help you?