Vizlib Live! - the Power of Cloud
Vizlib Live! allows users to view and interact with live data without leaving Qlik Sense.
We'll show you how to use the live query data engine of Astrato, also built by Vizlib, to deliver the power of now for Qlik Sense Enterprise and Qlik SaaS users where speed to insight and decision-making are paramount.
Vizlib Live! delivers:
- A no-code way for Qlik Sense Enterprise and Qlik SaaS users to view and interact with live data held in a data cloud (like Snowflake).
- Real-time access to your live data without the need for ETL processes.
- The ability to explore REALLY BIG data sources with Qlik’s in-memory analytics and Astrato’s powerful live query data engine.
- A familiar method for Qlik users to produce the pixel-perfect data stories you need to share.
TABLE OF CONTENTS
- Vizlib Live! - the Power of Cloud
- Getting Started with Vizlib Live!
- Setting up Astrato
- Qlik Enterprise Setup
- Setting a data refresh rate in Qlik
- Using Vizlib Live!
In addition to your Qlik account, your checklist for success includes:
- An account to access your live data in a Snowflake, Google BigQuery, PostgreSQL, or Dremio Cloud.
- An Astrato Account to create your pixel-perfect live data story to view and share in Qlik. You can sign up for Astrato here if you have not signed up already.
- The Vizlib Live! extension from the Vizlib User Portal.
Trial accounts and free plans are available for all the products required.
Getting Started with Vizlib Live!
Vizlib Live! How to video
Or open the Vizlib Live! getting started video in a new window.
Checklist for using Vizlib Live!
This checklist takes you through all the steps required, including where role permissions in Qlik Sense, your chosen data source, and Astrato may affect your initial setup.
Role permissions in Vizlib are linked to Qlik, and Astrato permissions can be managed directly or use enterprise authentication.
You must have a role that has permission to:
- Access to the QMC that can modify whitelisted domains.
- Download Vizlib Live! from the User Portal.
- Create and use data in the cloud. Astrato can create connections to data in: Snowflake, Google BigQuery, PostgreSQL, or Dremio Cloud.
- Create an Astrato Account.
- Whitelist domains in Astrato. All users of Astrato that are Owners have Administration rights.
- Connect their data to use in Astrato.
- Create a Workbook in Astrato and publish it.
- Create the Embed link in Astrato and click the option to Copy Link to just use the URL.
Setting up Astrato
Connecting your Qlik domain securely in Astrato
Once your accounts are created, you can add links for the content you want to share in Vizlib Live!
- Start in Astrato by allowing the connection to your Qlik domain.
- From the lobby sidebar, click Administration.
- Click View in the Embed section.
- Click the Allow list tab.
- Click Add and enter the URL for your Qlik domain. If you're using Qlik Desktop, you must add http://localhost:4848.
- Click Save to add the domain.
Figure 1: Allow connection to your Qlik Sense or Qlik SaaS domain in Astrato
Creating your data connection in Astrato
- In Astrato, connect to your live data source.
- From the lobby sidebar, click Data.
- Click (+) New connection and select the cloud data source type. The steps for each source type are slightly different, with options for user/password or enterprise SSO. Please see the article in Astrato on setting up data connections. We recommend using Snowflake with Vizlib Live!
Tip: The schema, view and field name can also be identified when creating the embed link in Astrato. Apply a filter before creating an embed link, and the name of the schema, view and field name will be included in the URL when including the filter in the embed link.
Viewing your data model details in Astrato
Now that you’ve connected your data, the data model details as they display in Astrato will need to be added in Vizlib Live!
You can copy and paste them from Astrato into the fields in Vizlib Live! to ensure that the field names match, including any spaces.
- Data View/ Table name
- Schema name
- Field name
Please note: the content in these fields must be the same - the fields are case-sensitive, and they must match any spaces in the names.
Figure 2: Showing the location of the View (1), Schema (2), and Field (3)
Creating and publishing your Workbook in Astrato
Now that you're connected to your data, the next steps are to:
- Create your workbook. There's also a tutorial for learning Astrato in our VizLab. We hope you'll enjoy creating your workbook while exploring how working with live data could benefit your business.
- Publish your workbook to a collection. You'll select the embedded object, groups, or sheets from your published workbook to link to in Vizlib Live!
- Use the Embed process to generate the link to view and interact with your data story in Qlik Sense. You can select a single data object, a group, or the whole sheet to share in Qlik Sense. Click the option to Copy Link to just use the URL.
Qlik Enterprise Setup
Setting up Vizlib Live! in Qlik SaaS has two set-up prerequisites, but the rest of the steps are the same for Qlik Sense Enterprise and Qlik SaaS.
Qlik SaaS setup for Vizlib Live!
- In your Qlik SaaS Management Console, navigate to the Content Security Policy, click Add and paste the web address for your Astrato workbook in the Origin field.
- Click Directive, and from the options displayed, click the box beside frame-src, and click Add, to complete the setup.
Figure 3: Adding the origin URL for Astrato in Qlik SaaS.
Vizlib Live! Set up in Qlik Sense and Qlik SaaS
- Download the Vizlib Live! extension.
- Decide whether you want your users to interact with the live data in a new Qlik App or use an existing one.
- In your Qlik sheet, click Edit, drag, and drop the Vizlib Live! extension onto the sheet.
- Paste the embed link in the field Astrato Embed URL in the left toolbar. Your live data story built in Astrato begins to render in Vizlib Live!
Setting a data refresh rate in Qlik
You can use the property panel to set the data refresh interval for your embedded content.
You can create a custom interval using an expression or select from the following options:
- 5 seconds
- 10 seconds
- 30 seconds
- 1 minute
- 2 minutes
- 5 minutes
- 15 minutes
- 30 minutes
- Custom using an expression
Selecting a data refresh rate
Select your embedded object.
From the properties panel, click the option Interactivity.
Just below the Information bar toggle, the dropdown list of Data refresh intervals displays with its default set to Off.
Select a data refresh rate from the list.
Adding a custom interval using an expression
Select ‘Custom' from the dropdown.
An expression input field appears.
Enter your expression that returns the intervals to set the data refresh intervals to.
Please see the page on Embeds in Astrato for more details.
Using Vizlib Live!
Before using Vizlib Live! ensure that the:
- Domains are whitelisted in Astrato and Qlik Sense.
- You’ve copied the embed link into the Astrato embed URL section.
Adding your data model details to Vizlib Live!
- Open Qlik Sense, and click Vizlib Live! Click the Data tab.
- In the first box, Field, enter the name of the field in Qlik Sense (1) that you want to pass the selection to in Vizlib Live! The field name entered for Qlik must match the field you selected in Astrato, including any spaces.
- Enter the Schema (2), View (3), and Field (4) names from Astrato. Your embedded content should display.
- The field name is visible in the bottom left corner of the extension.
Figure 4: Entering the details of your data model in Vizlib Live! Qlik Field (1), View (2), Schema (3), and Field (4)
Tip: The schema, view, and field name can also be identified when creating the embed link in Astrato. Apply a filter before creating an embed link, and the name of the schema, view and field name will be included in the URL when including the filter in the embed link.
Viewing your Embedded Astrato visualization
When a field is connected in the extension, it appears in the lower-left corner, indicating the field from Qlik Sense that has been connected through the extension (1).
Figure 5: Shows the field connection (1), the cloud icon to disconnect the data connection (2), and the icon to refresh your data (3).
Refreshing the data displayed
Click the refresh button in the lower right corner (3).
Disabling the data connection
To disable the Live connection in the extension, click on the cloud in the lower right corner of the extension (2). This may be useful if you want to restrict the consumption of data from your data cloud or, if you are going to add many selections/filters; as this stops visualisation from loading/recalculating with each filter applied.