Centralized QlikView Security Management Module - Click2Manage

QlikView is a fantastic business intelligence platform but it does have some limitations when it comes to security management. Although the application is quite secure (it is used in a lot of banks where security is extremely important) but setting up security is cumbersome. QlikView platform by default lacks a single, easy manageable and scalable security module. The built-in security framework is highly manual and script based to setup. Although it is manageable for 50-100 users, security management becomes a real burden for a few hundred to few thousand users. In addition to manageability issues, QlikView default security framework lacks the following:

Role based security setup assignment – Every users security configuration is done separately even a large group of users share the same security configuration where role based security assignment is crucial.

GUI based security configuration – Security configuration in QlikView is script based. Although QlikView Publisher (an add-on product to QlikView Server) offers somehow GUI based security setup, this is still not role based and the Publisher is an expensive addition to the QlikView platform.

Audit trail – Although almost all actions of users in QlikView are logged, security access configuration changes are not logged so there is no way to understand who changed what sort of security configuration

Layered security admin structure – QlikView’s security access manager, ADMIN, can do every changes about security. This prevents defining different levels of security admins to distribute the load of security configuration and creates significant security issues.

Encrypted security setup storage – QlikView does not provide an encrypted security setup storage.

Click2Manage

Click2Manage is a centralized QlikView Security Management Module developed by Singapore based Knowledge Management Solutions. Click2Manage still sits on the standard QlikView security access model in the background but provide a layer on it to overcome its limitations. Click2Manage deploys easy GUI based management interface to create and manage the SECURITY profile for QlikView Security setup. The module:

- Offers a web based GUI

- Stores security access matrix in secured, encrypted SQL database

- Deploys role based security to simplify security management

- Enables row level, field level, sheet level and application level security

- Interact with AD for user authentication and also supports Custom Created Users

- Provides audit logging

- Provides layered security management

Click2Manage offers a web based GUI and security setup features like role based security groups.

Benefits

Easy management of security for hundreds or thousands of users and profiles.Security setup with out of the box tools provided by QlikView server and publisher may be sufficient for 50-100 users, but it becomes labourous and unproductive for a few thousands of users. Click2Manage provides an easy to use, intiutive user interface and modules to overcome this problem.

Single point of QlikView security administration. Click2Manage provides a single point of QlikView security administration for all enterprise dashboards.

Secured Storage of QlikView security setup Click2Manage provides secured storage of QlikView security setup in an encrypted database and managed by a secured administrative environment for organization where IT policies mandate such setups.

Detailed audit reports for QlikView security setup updates Many organizations require strict audit reporting on the changes of QlikView security profile by security administrators. Click2Manage keeps track of all changes to security matrix across all dashboards and when requested produce detailed audit reports.