This chapter explains how to adjust URLs of services in an existing user management database. This can be especially helpful if WebOffice or ArcGIS Server are to be transferred to new system environments and therefore the referenced URLs for UserManagement change.

 

 

Step 1: Download and install DBeaver

Download the free DBeaver tool and install it locally.

 

Step 2: Creating a connection to the user management database

Open DBeaver and create a connection to your user management database using the button in the upper left corner of the application. If you want to edit a backup created with the WebOffice author standalone, it will be in SQLite format.

 

Specify the connection information to the database you want to edit.

 

Step 3: Change the URLs of the service references

The references of the services are stored in the schema of the user management database in the UM_SERVICE table in the NAME column.

 

For example, to change a URL the following syntax can be used:

Update UM_SERVICE SET NAME = REPLACE(NAME, https://gisserver_OLD.domain.com/arcgis/, https://gisserver_NEW.domain.com/arcgis/)

 

This command is entered in the SQLEditor and executed with the start symbol:

 

 

Step 4: Review the changes

In the last step, the changes should be checked to make sure that the references have been adapted correctly. This can be done by searching for the modified string.  

 

Step 5: Testing the customized user management database in WebOffice

When the customizations are finished, they can be imported from the backup back into the user management database included in WebOffice. To do so, use the Recover UM-DB function in WebOffice author standalone.