QMC Utilities is an application designed to assist with administration capabilities and workflows within the Qlik Sense platform. An open source project, QMC Utilities is built using the fully supported Qlik Sense APIs while taking advantage of your existing security modules.
QMC Utilities requires the following environment to function properly:
QMC Utilities must be installed on a server running Qlik Sense Enterprise or QAP software.
Qlik Sense Enterprise 3.0 and higher **or** Qlik Analytics Platform 3.0 and higher.
Qlik Sense service account for running the EA PowerTools service dispatcher.
Ability to make requests to the Qlik Repository Service API on the Central Node using port 4242.
An available port (by default port 9945) to connect to the QMC Utilities user interface.
The preferred method for installing QMC Utilities is the installer found here: QMCUtilities.exe. The installer includes includes all node and bower modules (npm not required).
QMC Utilities may be installed by downloading the source from GitHub and running npm install. However, some manual configuration of the config.js configuration file will be required before running if installed using this method. No documentation is provided for this method.
QMC Utilities now uses Qlik Sense authentication to validate user access to the powertool. This will control the data that users see in each of the plugins. Future releases will have more robust control to show / hide plugins based on the user.
After installing QMC Utilities, open a web browser and navigate use the following URL format to access the interface:
"https://" + "<hostname>" + ":<port number used in installation>/" + "<virtual proxy name>/" + "qmcu/"
If using a default virtual proxy, the virtual proxy name can be excluded from the URL:
"https://" + "<hostname>" + ":<port number used in installation>/" + "qmcu/"
App Meta Fetcher is used in conjunction with the Governed Metrics Application (included in the Governed Metrics Service installation). This plugin outputs Site-level application metadata into a collection of csv files which can be used to identify application, master and non-master item, visualization, and sheet metadata.
The App Object Approver enables approval of published sheets, stories, bookmarks, dimensions, measures, and Master Items in an app, thus, making them base objects of the Qlik Sense application. In addition, it's possible to un-approve objects as well and push them back to the community.
To approve or un-approve objects, qualifying items will have a clear checkbox. Click the checkbox to activate and then select the appropriate approve or un-approve button that is relevant to the selections made.
The Custom Property Bulk Loader enables administrators to upload a list of values for managing custom properties without having to enter values manually.The bulk loader is able to update existing custom properties, or create new custom properties for a Qlik Sense deployment.
Select a custom property or provide a name, select the resources the custom property will apply to, and upload a csv file with a single column list of values. Once that's done click the Create or Update button and to add or modify the custom property.
The Security Rule Manager allows a Qlik Sense administrator to export and import security rules from the Qlik Sense repository. This is helpful if you have developed a security model in one environment and would like to bring the whole model (or even specific security rules) over to a different environment.
The Source Control Assistant is an application backup and restore solution for Qlik Sense. Apps are serialized to json files, which can be easily stored and versioned in popular source control systems like Subversion, TFS, and Github.
EA Power Tools are a collection of software programs and methodologies for Qlik products. EA Power Tools and QMC Utilities are provided free of charge and are not supported by Qlik. EA Power Tools and QMC Utilities use Qlik APIs, but are open source solutions provided without warranty. Use of EA Power Tools and QMC Utilities is at your own risk.
If you experience an issue, open an issue! We want your feedback! Open an issue here: Issues