UserManagement Admin Web supports 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 UserManagement Admin Web
Start UserManagement Admin Web in the browser via the URL Then choose the correct profile and log in with your credentials.
Start the UserManagementAdminWeb application
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).
UserManagementAdminWeb notes that there is no data model or it is 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.
Create or update the data model in UserManagementAdminWeb
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.
UserManagement Admin Web
If you want to delete all data and the data model from your database, you can use the SQL drop scripts. See directory WebOffice10.9-DVD\Software\UserManagement Admin Web\Database for database scripts.
•Once you have set up projects in your WebOffice 10.9 SP1 application, you need to synchronize the projects with your WebOffice usermanagement database. This can be done e.g. with the button "Synchronize projects to UserManagement" - see chapter Check all projects for more information.
•If the data model creation/update process fails, please see chapter WebOffice UserManagement Troubleshooting for information how to debug WebOffice usermanagement.