Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Qlik Sense QMC Utilities

Not applicable

Qlik Sense QMC Utilities

Qlik Sense QMC Utilities

A collection of management console utilities for use with Qlik Sense.

____________________________________________________________________________________________________________

Introduction

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.

Minimum Requirements

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.

Installation

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).

For a walkthrough of the installation process, please have a look at the install documentation here: **(Installing QMC Utilities · eapowertools/QlikSenseQMCUtility Wiki · GitHub)**

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.

Security

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.

Usage

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/"


Example 1 (default virtual proxy):

If the Qlik Sense hostname is sense3.112adams.local and the virtual proxy is default, in the browser address bar enter https://sense3.112adams.local:9945/qmcu/.


Example 2 (non-default virtual proxy):

If the Qlik Sense hostname is sense3.112adams.local and the virtual proxy is called "test", in the browser address bar enter https://sense3.112adams.local:9945/test/qmcu/.

Please note the trailing forward slash - it is very important so make sure to include it!


Plugins

QMC Utilities uses a plugin architecture to instantiate the tools in the menu framework.

Version 3.0 and above includes the following tools:

____________________________________________________________________________________________________________

App Meta Fetcher

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.

Documentation Link

____________________________________________________________________________________________________________

App Mover

App Mover is a tool to help administer application movement from site to site. It allows exporting from one Qlik Sense environment and importing into 1 or many Qlik Sense environments.

Please note that owner information will not traverse between sites.

Documentation Link

____________________________________________________________________________________________________________

App Object Approver

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.


Documentation Link

___________________________________________________________________________________________________________

Custom Property Bulk Loader

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.

Documentation Link

____________________________________________________________________________________________________________

Real QMC

The Real QMC is exactly that - the QMC embedded into the QMC Utilities. Enjoy all the security and functionality of the real QMC directly from within the QMC Utilities.

Documentation Link

____________________________________________________________________________________________________________

Security Rule Manager

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.

Documentation Link

____________________________________________________________________________________________________________

Source Control Assistant

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.

Documentation Link

____________________________________________________________________________________________________________

License

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.

Issues

If you experience an issue, open an issue! We want your feedback! Open an issue here: Issues

Comments
Luminary
Luminary

Super-super-super cool and useful!

The plug-in system, is it documented so third party plugins can be developed (in node.js?) ?

0 Likes
Luminary
Luminary

Btw, the link for reporting Issues on GH is broken..

0 Likes
Not applicable

thanks!  Fixed!

0 Likes
lakshmikandh
Valued Contributor II

Thank you, These tools will be very much helpful.

Employee
Employee

Very helpfull Jeffrey!

Congratulations and thank you.

Employee
Employee

jog‌‌, Is there a way to restrict the QMC utilities only when try http://localhost:9945?

We want to keep the utilities installed on the server, but disabled when try to access by internal network.

Regards.

0 Likes
Not applicable

Ricardo, the best way to do it would be to create a firewall rule that blocks 9945 inbound at the domain level.  That way you should be able to access via local server (rdp) but not access from a remote web browser.

jg

0 Likes
Employee
Employee

Ok Jeffrey, thanks.

We did a simple change on server.js and works fine . Take a look on this code:

Current: server.listen(config.thisServer.port, function()

New: server.listen(config.thisServer.port,'localhost' function()

It can help other customer

Regards.

0 Likes

It would be great if something could be added to display full task chains. 

There are ways of looking at task chains in QMC but they are somewhat user hostile and do not show the full picture.

0 Likes
mohitd910
Contributor II

great

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎10-06-2016 02:24 PM
Updated by: