Qlik Sense Utility comes bundled with Qlik Sense. It is able to assist in the backing up process to help with the manual process.
Key elements that need to be backed up are:
the certificates used by Qlik Sense for internal communication
the Repository Database used to store meta-data about the Qlik Sense site
the applications used by the Qlik Sense site
the Extensions, thumbnail images, etc used by Qlik Sense apps
Other options components can include:
Logs of activity on the site
Supplemental material used by the Qlik Sense site (e.g. QVDs, Excel files, etc)
By using the QlikSenseUtil tool, an administrator can back all of these up and configure the tool to be integrated in a silent, incremental backup policy.
Locate the QlikSenseUtil tool
By default it will be located in C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe
For installations to custom paths it will be located at Drive:\InstallationPath\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe
In Notepad or Text Editor, construct the desired command line syntax for the backup.
A sample command: C:\"Program Files"\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe -backup -databaseHostname="FQDNofTheDatabase" -databasePassword="SuperUserPassword" -path="Drive:\BackupLocation" -rootPath="\\ServiceCluster\Path"
For a full listing of the flags possible, consult later in this article or the Readme.txt in the QlikSenseUtil directory
Note: Executing a backup will stop Qlik Sense services, so only execute this tool when downtime is acceptable Note: Executing as the Qlik Sense service account is recommended since the client certificate used by Qlik Sense is only accessible to the service account Note: For silent backups, do remember to use the -f flag Note: Logs for this tool will be written to %USERPROFILE%\AppData\Local\Temp\logs for the account executing the tool
Once the command is written out, launch a command prompt and paste in the command
Observe the files backed up to the path specified in the path flag
backup: specifies a backup operation (mandatory) path: path to the folder where to store the backup (mandatory) certificatePassword: password for protecting the certificates. If not specified then the certificates will not be backed up databaseHostname: Hostname where the database is running (mandatory) databasePassword: Superuser or postgres account password (mandatory, if password was configured) databasePort: port number used by the database) f: silent backup h: help