A blog for my learnings
Following on my previous post, I had a look at the performance impact of enabling QVD and QVF encryption in Qlik Sense.
In this test, I’m using Qlik Sense Enterprise November 2019 release on an Azure B4ms (4 vCPU, 16GB RAM) VM running Windows Server 2019. Qlik Sense encryption settings were left at default.
From Qlik Sense Enterprise on Windows September 2019 (the option became configurable via the QMC in November 2019), users have the option of enabling one or both of QVD and QVF encryption – adding at-rest protection from people who shouldn’t have access to your valuable files. This is enabled server-wide and applies to all content on the environment.
The big issue that I see is that any security office is going to require that any and all encryption is enabled – without understanding the issues this could cause.
As an update to my previous post on using lambda to automate snaphots, I’ve finally logged back into the Lightsail console and seen they have added a new feature – automatic snapshots.
It looks like the feature was added in October, based on the help site.
Continue reading “AWS Lightsail snapshots – now automatic for Linux”In QlikView, you had the ability to select multiple variables and delete them en-mass. In Qlik Sense, the UI permits you to undertake this activity one-by-one, and each takes two or three clicks.
This bookmarklet (Chrome only this time, not tried elsewhere) removes ALL variables from a Qlik Sense application by cheating the APIs used by the Qlik Sense client.
This .gitignore is based on experience of using various Windows, Mac and Linux OS – and a few unexpected commits. It is my go-to for Qlik projects, and was built using the GitHub gitignore repo.
Script below, or latest version on GitHub.
Continue reading “.gitignore for Qlik Sense and QlikView projects”Application icons are prominently displayed throughout the Qlik Sense hub, and they are usually either the default blue, or some horrendously stretched icon that has no business being on an enterprise system.
This simple tool (packaged as an extension and accessible as a mashup) helps users generate consistent, appropriate app icons for use in their apps.
Forewarning – loading data directly from the repository is not recommended. Most requirements can be met through the QRS APIs.
This script loads all QRS data from the repository into an app. The code is below, or the latest is available on GitHub.
Continue reading “Qlik Sense Repository Explorer (PostgreSQL extractor)”If you’re doing anything but vanilla Qlik Sense development, it’s likely you’ll need to get to the object IDs at some point. You can do this by appending /options/developer to the end of the page URL and clicking on each object in turn, or using dev tools – but that’s slow.
This bookmarklet makes getting the object IDs fast in Chrome (and, begrudgingly, IE11).
Revisiting an earlier post on configuring a LAMP server, and on a recent post on installing Webmin, this time I’m dropping CentOS Web Panel (CWP) onto a new CentOS 7 box.
So, on a fresh CentOS 7 1901-01 box on AWS, let’s begin.
# Set the hostname correctly before we start off, otherwise CWP will pick up the wrong name
hostname sub.host.com
# Update existing packages
sudo yum -y update
# Install wget and nano (as I like nano and wget is needed for the CWP install)
sudo yum -y install wget nano
# Reboot the box to sort out any updates requiring reboot
sudo rebootAs a quick refresh from an earlier post, I’m going to use a new CentOS image with Webmin as the control panel of choice.
Happily, the only thing that’s changed in the documentation is the way the gpg key is imported – documentation is here: https://doxfer.webmin.com/Webmin/Installation
So, on a fresh CentOS 7 1901-01 box on AWS, let’s begin.
# Update all base packages
sudo yum -y update
# Install nano (my preferred text editor)
sudo yum -y install nano
# Edit the /etc/yum.repos.d/webmin.repo file
sudo nano /etc/yum.repos.d/webmin.repo