This documentation supports the 19.02 version of BMC Digital Workplace Advanced.

To view an earlier version, select the version from the Product Version menu.

Pre-creating the database

If you have database access restrictions and cannot allow the BMC Digital Workplace installer to create a database, you can pre-create a database. When you do this, you create database users and assign required roles to them. 

The following topics are provided:

Before you begin

This topic is part of Preparing for installation of Digital Workplace. Complete the previous steps, described in the following topics:

Required database schemas

BMC Digital Workplace requires the following database schemas:

Schema Purpose Contains
schemaName_business Stores business data
  • Location
  • Certificates
  • Configuration
  • Customizations
  • Images
schemaName_system Stores system data
  • Provider Info (from BMC Digital Workplace)
  • Tenant
  • Plugin

The database tables above start out small and grow, but the size is much smaller when compared to the ITSM DB.

You can replace schemaName with DWP or any other identifier that you prefer. BMC recommends that you keep "_business" and "_system" as part of these schema names so that you can easily identify the data in the tables. During installation, you can specify these schemas.

Databases you can pre-create

Depending on the database you are using, follow the instructions in the corresponding topic:

Was this page helpful? Yes No Submitting... Thank you

Comments