ActiveMatrix BPM: BDS Database Configuration

Field/Button Description
Use different database to other AMX-BPM components Whether ActiveMatrix BPM should host the BDS case data store in the ActiveMatrix BPM database or in a separate database.
  • When selected, the BDS case data store will be hosted in a separate database. The remaining fields on this page are available. The database type of both BDS case data store and the ActiveMatrix BPM database should be the same.
  • When cleared, the BDS case data store will be hosted in the ActiveMatrix BPM database, as specified on the ActiveMatrix BPM: Runtime Database Configuration screen.

Default: Cleared

build.properties entry: bpm.bds.owndatabase

URL JDBC connection string that identifies the database to be used to host the BDS case data store.

In the case of DB2, this database must have been created previously. For other databases, the specified string will be used to automatically create the database.

ActiveMatrix BPM will use this string to connect to the BDS case data store.

For the format to use, see JDBC Connection String Formats.

build.properties entries: bpm.bds.url, plus other database specific entries representing the different URL components - for example, on SQL Server:

  • bpm.bds.dbname
  • bpm.bds.port
  • bpm.bds.xadriver
  • bpm.bds.dialect
  • bpm.bds.servername
BDS Username Database server (or for DB2, operating system) user account that ActiveMatrix BPM should use to connect to the specified database URL.

If you are using a DB2 database, this must be the name of an existing operating system user.

Default: bpmuser

build.properties entry: bpm.bds.username

BDS Password Password for the specified BDS Username.

build.properties entry: bpm.bds.password

Tablespace Name Name of the Oracle tablespace in which the tables for the BDS case data store will be created:
  • TIBCO Configuration Tool will create this tablespace if it does not already exist.
  • The Administrator database, BPM database, and BDS case data store must each use a separate tablespace.
  • If multiple BDS case data stores (for different BPM systems) are hosted on this server, each BDS case data store must use a separate tablespace.

If the BDS case data store is being hosted on SQL Server or DB2 this field is ignored.

Default: bds_tablespace

build.properties entry: bpm.bds.tablespace

Test Connection Verifies that TIBCO Configuration Tool can connect to the specified database using the information supplied on this page.
Generate Scripts Generates the SQL scripts needed to create the specified BDS database.

You must generate the database creation scripts if you chose to manually create the BPM and BDS databases in the ActiveMatrix BPM: Database Administrator screen. See Manually Running BPM Database Creation Scripts for more information about how to manually create the BDS database.