The Butler family
The Butler tools started out with a very specific need to start Qlik Sense reloads from outside systems.
A small microservice was created to solve this, exposing a single API to the world, offering a single endpoint that could start Sense reload tasks.
Over the years a few projects (for example Butler SOS, which simplifies day 2 operations (, ) have spun off from the original Butler project, and still other projects have been created from scratch to solve specific challenges around developing Sense apps and running Qlik Sense server environments.
All members of the Butler family are open source and available on Ptarmigan Labs' GitHub page.
Projects with production grade release status are:
The original Butler. Offers various utilities that make it easier to develop Sense apps, as well as simplifying day 2 operations.
- Alerts when reload tasks fail or are aborted. Alert destinations include email, MS Teams, Slack, webhooks, MQTT, New Relic and Signl4.
- Keep script logs of all failed reloads.
- Scheduler for reload tasks.
- Key-value store that enables parameter passing between reload tasks.
- Secure file system operations from Sense loads scripts.
Real-time operational metrics for Qlik Sense. A must-have if you are responsible for a Sense environment with more than a dozen or so users.
Butler SOS makes it possible to detect and alert on issues as they happen, rather than in retrospect much later.
Several storage and visualisation options available, including InfluxDB + Grafana and New Relic.
Butler Sheet Icons
Automates the creation of sheet icons for both Qlik Sense Cloud and client-managed Qlik Sense Enterprise on Windows (QSEoW) applications.
It's a cross platform command line tool which given the correct Sense credentials will take screen shots of all (or some) sheets in a Sense app (or all apps on a Sense server!), then create thumbnail versions of those screenshots.
Finally those thumbnails will be used as sheet icons.
No more manual screenshot taking, resizing images, navigating hundreds of sheets in dozens of apps.
Start Butler Sheet Icons instead and go get a nice fika.
The tool can be used stand-along or as part of an automated release process.
Given the name this tool doesn't sound like a member of the Butler family.
Let's say Ctrl-Q is a sibling of the Butler bunch.
While the Butler tools are (usually) intended to solve and simplify rather specific use cases, Ctrl-Q is aimed at being the lazy Qlik developer/admin's best friend.
Let's say there is some manual, tedious, time consuming and error prone activity that a Qlik Sense developer or admin is faced with.
For example importing dozens of apps from QVF files and creating a hundred associated reload tasks.
Ctrl-Q lets you do this with a single command using definitions in an Excel file.
Instead of spending a day on this the actual execution takes a minute or so.
In other words: Ctrl-Q focus on high-value use cases that are difficult or impossible to solve using other tools.
Butler Cache Warmer. Cache warming is the process of proactively forcing Sense apps to be loaded into RAM, so they are readily available when users open them.
Using Butler CW is an easy way to make your end users' experience of Sense a little better.
Butler App Duplicator
No matter if you are a single developer creating Sense apps, or have lots of developers doing this, having app templates is a good idea:
- Lowered barrier of entry for new Sense developers.
- Productivity boost when developing Sense apps.
- Encouraging a common coding standard across all apps.
This tool is mainly of interest if you have lots of QVDs and apps, but when that's the case it's of paramount importance to understand what apps use which QVDs. In other words what data lineage looks like.
Butler Spyglass also extracts full load scripts for all Sense apps, creating a historical record of all load scripts for all Sense apps.
Butler Icon Uploader
Visual looks is important when it comes to analytics and this holds true also for Qlik Sense apps.
The Butler Icon Uploader makes it easy to upload icon libraries (for example Font Awesome) to client-managed Qlik Sense Enterprise.
With such icons available it is then easy for app developers to use professional quality sheet and app icons in their Sense apps.