Navigation:  Installation & General Information > Installation > WebOffice usermanagement (Application Server) > Create a Usermanagement Database

UserManagement Admin Web supports MS ACCESS, MS SQL, PostgreSQL, Oracle databases as well as SQLite files.

UserManagement Admin Web is able to create the data model automatically.

Prerequisites for this are

•an existing database schema,

•a database user with the right to create and edit tables (Insert, Update, Delete, Select). It is recommended to use the schema owner user for this. The user also needs the right for CREATE PROCEDURE and ALTER PROCEDURE.

•a correctly configured database connection in the web.config file of UserManagementAdminWeb

 

Start UserManagement Admin Web in the browser via the URL http://<server name>/UserManagementAdminWeb. Then choose the correct profile and log in with your credentials.

 

 

The application will guide you through the database creation/upgrade wizard (UserManagement Admin Web is able to either create the data model from scratch or to upgrade the data model if it out of date).

 

 

After pressing the button Start Update, you will get immediately the information whether the creation/Update of the data model was successful or not. If the upgrade finished without any errors you can proceed to the login.

 

 

After login you see the main page of UserManagement Admin Web. On the left side you can choose between Simple and Advanced Menu which controls the number of displayed wizards in the left menu.

 

 

Note: If you want to delete all data and the data model from your database, you can use the SQL drop scripts. See directory WebOffice10.7-DVD\Software\UserManagement Admin Web\Database for database scripts.

Note: If the data model creation/update process fails, please see chapter WebOffice usermanagement Troubleshooting for information how to debug WebOffice usermanagement.