Create the TIBCO BPM Enterprise Schema

To create a database schema run the -setupDatabase option with the execute argument,

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

Note: Ensure that the database credentials of the user you created in the previous section are provided to the tool using the -dbConfig option. Also, the URL must reflect the type and location of the database you are using.

Note: If you do not run the -setupDatabase option with the execute argument, 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.

Alternatively, to create a database schema running the utility as a Kubernetes job, use

cat <<EOF | kubectl apply -f -
apiVersion: batch/v1
kind: Job
metadata:
  name: utility
  namespace: bpme
spec:
  template:
    spec:
      hostPID: true
      containers:
      - name: utility
        image: tibco/bpm/utility:5.1.0 
        command: ["utility","-dbConfig","url=jdbc:postgresql://postgres-service:5432/postgres  username=xxx password=xxx","-setupDatabase execute"]
      restartPolicy: Never 
 EOF

Note: Update the above -dbConfig options depending on the database that is used.

Note: As a Kubernetes and OpenShift user, you can use this to create a database schema running utility.

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