Installation: Test User Setup

Test User Preferences

These implementation steps allow you to assign groups to a user profile so that you can test logging in as different users.

Requirements

• Qlik Sense Server (does not work with Desktop) Nov/2017 Release or higher.
• Access to QMC, to update modify User Directory Connectors.
• Already completed the Basic Installations steps.
• Microsoft Excel 64bit ODBC Driver Installed Download. NOTE: If you have to install the driver, you may have to restart the server before setting up the UDC.
• Ability to add users to your Operating System.

Steps

Setup Qlik Sense UDC:

1. From Qlik Sense QMC > User directory connectors...
2. Create New Connector, Type = Excel (ODBC)
3. NAME: "Excel UDC"
4. SYNC USER DATA FOR EXISTING USERS - Uncheck
5. USER DIRECTORY NAME: [Provide your user directory name] - Check out "QMC > Users" to see what yours is
6. USER TABLE NAME: [Users$]
7. ATTRIBUTES TABLE NAME: [Attributes$]
8. VISIBLE CONNECTION STRING: DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=Your_Unzip_Path\data\UsersUDC.xlsx
9. Press Apply

Setup Users:

1. In Excel, open the "Your_Unzip_Path\data\UsersUDC.xlsx"
2. In Windows, use "Local Users and Groups" application to add users.
3. Create a new user, for each user in the Excel file (suggestion: make password as as userid for testing purposes). Make sure to uncheck "must change password", and check "password never expires".

Update and publish application:

1. From Qlik Sense Hub > My Work, Open the "Multilingual & Multi Tenant-Department Sampler"
2. Using the Navigation Menu, select "Data Load Editor" to edit the Load Script
3. On the "Demo Variables" Section, modify the "vQlikLangApplySecurity" variable to be set to 'True()'
4. Reload the App
5. From Qlik Sense QMC > Apps...
6. Publish the "Multilingual & Multi Tenant-Department Sampler" app to a stream available to your users (probably Everyone).

Test Setup:

1. Open your Qlik Sense URL
2. Log in as each user created above
3. From the Stream, open the "Multilingual & Multi Tenant-Department Sampler"
4. Navigate to the first sheet and see that it is in the user's preferred language.

Next Steps

You have completed the final installation steps. You can now freely add/update languages and explore the application.