Can Collaboration Objects / User Objects be migrated when moving the QlikView servers? Can they be migrated if the server is moved to a different domain, or user names are being changed?
User Objects and Bookmarks are stored in the .SHARED or .TSHARED file residing in the same location as the QlikView document (.QVW). These need to be moved with the .QVW if the documents are relocated.
Ownership is identified by DOMAIN\UserID, or ServerName\UserID for local server users.
Without changes to the Domain or User Names
No extra steps are required. User Objects and Bookmarks owners are identified by DOMAIN\UserID. If this remains the same, only the .shared / .tshared file needs to be moved along with the .qvw.
Moving Windows Domains or changes to User Names
This also applies if no Windows Domain is used, but users were logging in locally with ServerName\UserID.
There are three different methods that can be used to transfer over bookmarks, each suitable for different volumes that need to be administered.
In this example, the following setup is being used:
QlikView Server B is located in Domain2, has a user named euuser2. This user has one bookmarks.
QlikView is being migrated to QlikView Server A, located on Domain1, and the bookmarks need to be transferred to user1
The QlikView Administrator will have to edit the domain\ prefix for all available objects.
For ease of administration (view only, no editing supported!), refer to the Power Tools for QlikView and the Sever Object Handler (Note: as stated above, using different service accounts on the QlikView services may result in unexpected behavior, so ensure the same service account is in use on all services.)
Method 1: Manual administrator in the QlikView Management Console.
Navigate to Documents > User Documents > YourQlikViewDocument.qvw > Server > Server Objects
Tranferring this bookmark can be easily achieved by clicking the "User" icon on the far right and moving it to the correct user. Any objects can be moved like this, but may lose their positioning on sheets and have to be re-added from the Repository by the user.
Method 2: CleanUp toolkit
C:\Temp\SharedFileToolTemp>qvs.exe -x "C:\ProgramData\QlikTech\Documents\Golf Quest.qvw.shared" –p -ro domain\olduser domain\newuser
-so will set owner -ro replace
Method 3: ServerObjectHandler from our Power Tools Package
Note! This method is provided "as is" and not supported and that the power tools are not directly supported by Qlik technical support. You can obtain them from our Community. Ensure that backups of your .shared files are available.
Note! If this method is used to change server objects on sheets, the sheet positionings will be lost, and users will need to manually repopulate their sheets.
Execute the ServerObjectHandler, connect to the QlikView Server, and change the users/objects as desired.