Creating SQL Server databases
You must create the required
databases before you install IBM® Business Process Manager. Usually
you require the Process database, the Performance Data Warehouse database,
and the Common database.
Before you begin
- You cannot share databases across multiple installations or deployment environments.
- The Process Server and Performance Data Warehouse components require their own separate databases and cannot be configured on the same database as the other IBM Business Process Manager components.
- The Process Server and Performance Data Warehouse components require the databases to be case insensitive for SQL Server.
- The CommonDB (and legacy WebSphere® Process Server) components require the databases to be case sensitive for SQL Server.
- The user who creates the databases cannot be the same user that you plan to assign as the login user for accessing the databases. If you deviate from this requirement, the default schema dbo will be used.
- The schema name used for each component should match the user.
About this task
The default database names are BPMDB for the Process database, PDWDB for the Performance Data Warehouse database, and CMNDB for the Common database.