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
Oracle	X	X	X	X	X
Microsoft SQL	X	X		X	X

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
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. For more information, see Configuring the Common Event Infrastructure database.