Create the TIBCO BPM Enterprise Database

A TIBCO BPM Enterprise database is required to hold data, both about the system itself, and data that is used by TIBCO BPM Enterprise applications.

1. Using a suitable SQL client application (for example, pgAdmin or psql), connect to the PostgreSQL server.
2. Create a new database with a suitable name. For example:

   $ createdb bpmdb

3. As the database administrator, run the following script to create the bpmuser role (user). TIBCO BPM Enterprise will use this user whenever it connects to the BPM database.

   CONFIG_HOME/tibco/cfgmgmt/bpm/database/createuser.sql

   Note: The BPME database tables are generated automatically using the BPME utility.
4. To execute the DDL SQL commands against the target database, run the Execute command,

   docker run -it --rm tibco/bpm/utility:5.0.0 utility -setupDatabase execute

   Note: Ensure that the database credentials of the user you created in the previous step are provided to the tool.

   Note: If you do not run the Execute command, the required SQL script file is sent to STDOUT. You can redirect STDOUT to a file in the normal way to run the script yourself.

   For more details regarding utility and its commands, see Appendix: Utility Commands of the TIBCO BPM Enterprise Administration Guide.