Database requirements

Studio requires a relational database to store configuration and state, including component configuration, user permissions, and system settings.

BDD supports the following database types:

Oracle 11g
Oracle 12c 12.1.0.1.0+
MySQL 5.5.3+

Note: BDD does not 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 production environment, you must create the following:

A database of one of the types listed above.
A database username and password.
An empty schema. The name of this is arbitrary, but the default is studio.

Note: All Studio instances must be able to connect and write to the same database. To avoid performance issues, Oracle recommends that you connect them over the same local network.

Sample commands for creating Oracle and MySQL database users and schemas are available in Sample commands for a production database.

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 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.

If you have a MySQL database, you must set UTF-8 as the default character set.

Demo environment database requirements

If you are installing BDD in a demo environment, you can use one of the databases listed above or a Hypersonic (HSQL) database.

Hypersonic is an embedded database running inside the JVM. It is useful for getting Studio up and running quickly, but can't be used in a production environment due to performance issues and its inability to support multiple Studio nodes.

Important: If you install in a demo environment with a Hypersonic database and later decide to scale up to a production environment, you must reinstall BDD with one of the supported MySQL or Oracle databases listed above.