Table and schema creation

Depending on your database provider, you need different database tables and schemas for your database in IBM® Business Process Manager.

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 1. 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
This topic applies only to the Distributed platformsOracle This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX
This topic applies only to the Distributed platformsMicrosoft SQL This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX This topic applies only to the Distributed platforms  This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX
Table 2. Schema creation based on database provider
Database providers Messaging Engine Business Process Choreographer Business Process Choreographer Reporting IBM Process Server Performance Data Warehouse
This topic applies only to the Distributed platformsDB2 This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX This topic applies only to the Distributed platforms 
DB2 for z/OS X X X X X
This topic applies only to the Distributed platformsOracle This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX This topic applies only to the Distributed platformsX This topic applies only to the Distributed platforms 

The only way to configure the Common Event Infrastructure database is manually. For more information, see Configuring the Common Event Infrastructure database.

Parent topic: Planning your component-specific database configurations