Open navigation

How to connect data to Qlik Sense

Using the Supermetrics Query Manager, you can easily create queries and connect your data from various data sources to Qlik Sense via the Supermetrics API.


We recommend using the KEY-JSON output format.


Before you begin

See Qlik documentation for more information about creating a REST connection to transfer your data.


Instructions

  1. Log in to the Supermetrics Hub.
  2. Go to API.
  3. Select for Supermetrics API from the dropdown menu next to the page title.
  4. Click Select data source.
  5. Select a data source and connection to use. 
  6. In the sidebar on the left, build your query. Click Run to test it and review your data in the preview.
  7. From the URL format options, select K-JSON
  8. Copy the K-JSON URL.

    The query URL includes an API key that gives anyone with the URL access to your data. Treat this as you would a password and keep it safe. If you need to share the URL publicly, use the Short URL option that does not display your API key.

  9. Open Qlik Sense, and create a new app.
  10. Continue to add data to the app.
  11. In the Add data view, select the REST option.
  12. In the connection configuration view, paste the Query URL you copied from the Query Manager in step 7 into the URL field and select a name for the connection.

  13. Click Test connection to ensure the configuration is valid.

  14. To finalize the setup, click Create.



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.