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
| Category | What | Why |
|---|---|---|
| App and Sheet Metadata | App names, descriptions, and owners; sheet titles and layouts; sheet object types (charts, tables, KPIs) and their master item references | To catalog Qlik apps and their sheets for discovery and lineage mapping |
| Expressions and Lineage | Chart/table expressions (measures and dimensions); data connection strings and load script contents; field-level mapping back to source tables in your data warehouse | To trace how fields in Qlik apps map back to your underlying data warehouse tables |
| Usage Activity | App open and sheet view counts; active users and session timestamps, from Qlik's session/audit logs | To 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
- Log into your Qlik Cloud tenant as an administrator
- Navigate to Management Console → Users
- Create a dedicated user for Solid (e.g.,
[email protected]) - 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
- Navigate to Management Console → API keys
- Click Generate new key, scoped to the Solid service account
- Copy and save the key immediately — it will not be shown again
Step 3: Grant Space Access
- In each space containing apps you want Solid to scan, add the Solid service account
- Grant it the Can view (or equivalent read-only) role
Step 4: Configure Solid
- Log into the Solid platform
- Navigate to Settings → Integrations → Qlik Sense
- Enter:
| Field | Description |
|---|---|
| Tenant URL | Your Qlik Cloud tenant URL (e.g., https://yourcompany.qlikcloud.com) |
| API Key | The key generated in Step 2 |
- Click Test Connection
- Select which spaces you want Solid to monitor
- Click Save
Option B: Qlik Sense Enterprise (On-Premises)
Step 1: Create a Service Account
- In the QMC, navigate to Users
- Create a dedicated user for Solid (e.g.,
SOLID_SERVICE) - 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.
- In the QMC, navigate to Certificates and export the client certificate for the Solid service account (or generate a new one for it)
- Securely transfer the certificate and private key to your Solid administrator
Step 3: Configure Solid
- Log into the Solid platform
- Navigate to Settings → Integrations → Qlik Sense
- Enter your Qlik Sense Enterprise server address and upload the client certificate
- Click Test Connection
- Select which streams you want Solid to monitor
- Click Save
Solid will begin indexing your Qlik Sense metadata.
Permissions Needed
| Permission/Role | Purpose |
|---|---|
| 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 certificates | Required by the administrator performing the Solid setup |
Troubleshooting
Connection Issues
- Verify the tenant URL / server address is correct and reachable from Solid's network
- Check the API key hasn't expired or been revoked (Cloud), or that the client certificate is still valid (Enterprise)
- Confirm the service account is active and not disabled
Permission Issues
- Verify space/stream access — the service account needs explicit read access to each space (Cloud) or stream (Enterprise) you want scanned
- Check the assigned role includes permission to view apps and their load scripts
Missing Data
- Confirm apps are published — unpublished personal apps may not be visible to the service account
- 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
Updated 8 days ago
Did this page help you?
