The Workflow Manager Service requires a relational database to
store state information.
Like Studio, the Workflow Manager Service
supports the following types of databases:
- Oracle 11g
- Oracle 12c 12.1.0.1.0+
- MySQL 5.5.3+
You must create the following for the Workflow Manager Service:
- A database of one of the
types listed above. Note that this must be separate from the Studio database.
- A database username and
password.
- An empty schema. The name of
this is arbitrary.
Note that BDD doesn't currently support database migration. If you
decide to switch to a different type of database later on, you must reinstall
BDD with a new database instance. If you're installing BDD in a non-production
environment with the QuickStart option, you
must use a MySQL database named
workflow. For more information, see
QuickStart Installation.
Additionally:
- You must install the
database client on the install machine. For MySQL, this should be MySQL client.
For Oracle databases, this should be Oracle Database Client, installed with a
type of Administrator. Note that the Instant Client is not supported.
- If you have a MySQL
database, you must set UTF-8 as the default character set.
- If you have an Oracle
database, you must set the
ORACLE_HOME environment variable to the directory one
level above the
/bin directory that the
sqlplus executable is located in. For example, if the
sqlplus executable is located in
/u01/app/oracle/product/11/2/0/dbhome/bin, you
should set
ORACLE_HOME to
/u01/app/oracle/product/11/2/0/dbhome. Note that
this is different from the
ORACLE_HOME property in BDD's configuration file.
Sample commands for creating Oracle and MySQL database users and schemas
are available in
Sample commands for production databases.
