IBM BPM, V8.0.1, All platforms > Install IBM BPM > Plan for IBM BPM > Plan the database configuration > Plan the component-specific database configurations

Table and schema creation

Depending on your database provider, you need different database tables and schemas for your database in IBM BPM.

In the administrative console, when you select Resources > JDBC > Business Integration Data Sources and click a data source, you can select the check box for Create Tables to create the tables from the data source. If only a database administrator can create database tables, clear the check box, locate the scripts in the message box, and give these scripts to your database administrator to run. If you enable Create Tables, various deployment environment functions of each database provider are available, as shown in the following tables. An "X" indicates that the table or schema is created.

Tip: You configure the common database during profile creation.

Table creation based on database provider
Database providers Messaging Engine Business Process Choreographer

Business Process Choreographer reporting

IBM Process Server Performance Data Warehouse
DB2 X X X X X
Oracle X X X X X
Microsoft SQL X X   X X

Schema creation based on database provider
Database providers Messaging Engine Business Process Choreographer Business Process Choreographer Reporting IBM Process Server Performance Data Warehouse
DB2 X X X X  
DB2 for z/OS X X X X X
Oracle X X X X  

The only way to configure the Common Event Infrastructure database is manually. See Configure the Common Event Infrastructure database.

Plan the component-specific database configurations