Manually Creating the BPM and BDS Databases

When creating a BPM system, although TIBCO Configuration Tool can create the BPM and (if it is separate) BDS databases automatically, there may be situations in which you need to create these databases manually.

When you use the Create TIBCO ActiveMatrix BPM Server Wizard to create a BPM system, TIBCO Configuration Tool can automatically create the BPM and BDS databases, provided you have the username and password of a database server user account that has database administrator privileges (a DBA user).

Note: TIBCO recommend that you allow TIBCO Configuration Tool to automatically create the BPM and BDS databases unless either of the following applies:
  • You do not have access to the credentials of a DBA user.
  • Your database administrator wants to examine and possibly edit the database creation scripts before they are run - for example, to customize or optimize them for your particular database environment.

If you decide that you need to manually create the BPM and (if it is separate) BDS database, you must perform the following steps.

Procedure

  1. On the ActiveMatrix BPM: Database Administrator screen, clear Create BPM Database Instance.
  2. On the ActiveMatrix BPM: Runtime Database Configuration screen, click Generate Scripts to create the SQL scripts required to create the BPM database.
  3. On the ActiveMatrix BPM: BDS Database Configuration screen, if you have selected Use different database to other AMX-BPM components, click Generate Scripts to create the SQL scripts required to create the BDS database.

    TIBCO Configuration Tool writes both sets of scripts to the following folder:

    CONFIG_HOME\bpm\BPMApplicationName\database

  4. On the Administrator Server Configuration: Summary screen, Save your configuration session data, then Cancel the wizard.
    Warning: Do NOT click Configure at this point!
  5. Get a database administrator to manually create the BPM and BDS databases - see Manually Running BPM Database Creation Scripts.
  6. Run the Create TIBCO ActiveMatrix BPM Server Wizard again to complete the configuration process, as described in your particular installation scenario.