Navigation:  How To > WebOffice usermanagement >

Adjusting service URLs in a user management database with DBeaver

Previous pageReturn to chapter overviewNext page

This chapter explains how to adjust URLs of services in an existing Usermanagement 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 user management change.

Note: Please note that the use of the DBeaver tool is under exclusion of any warranty by VertiGIS. 

Note: Be sure to create a backup before editing the user management database in DBeaver! 

 

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.

Connecting to Usermanagement Database

Connecting to Usermanagement Database

 

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

Connectioninformation to UM DB

Connectioninformation to UM DB

 

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.

Column NAME with the Service references

Column NAME with the Service references

 

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:

 

Execute command in SQL Editor

Execute command in SQL Editor

 

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.  

Search for changed references

Search for changed references

 

Step 5: Testing the customized usermanagement 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.

Note: For more information on importing a user management database via the WebOffice author standalone, see the Recover UM-DB. chapter.