External Enterprise Dashboard Database Configuration

The Enterprise Dashboard uses an internal Derby database by default. We recommend that you use an external database instead.

The Enterprise Dashboard does not support IBM DB2.

Follow these steps:

Log on to the server where the Enterprise Dashboard is installed.
Navigate to LISA_HOME and open the local.properties file.
Locate the following lines in the Enterprise Dashboard Options section, which specifies whether to use the internal Derby database in the Enterprise Dashboard.
```
# Should the internal Derby DB instance in the Enterprise Dashboard be started?
dradisdb.internal.enabled=true
```
Change the value to false.
```
dradisdb.internal.enabled=false
```

Perform one of the following actions:

To use an Oracle database, edit the following properties to set values to an external database similar to the following example:

lisadb.pool.dradis.driverClass=oracle.jdbc.driver.OracleDriver

lisadb.pool.dradis.url=Jdbc:oracle:thin:@[HOST]:[PORT]:[SID]

lisadb.pool.dradis.user=oracle_username

lisadb.pool.dradis.password=oracle_password

To use a SQL Server database, edit the following properties to set values to an external database similar to the following example:

lisadb.pool.dradis.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver

lisadb.pool.dradis.url=jdbc:sqlserver://[SERVER]:[PORT];databaseName=[DATABASENAME]

lisadb.pool.dradis.user=sqlserver_username

lisadb.pool.dradis.password=sqlserver_password

To use a MySQL database, edit the following properties to set values to an external database similar to the following example:

lisadb.pool.dradis.driverClass=com.mysql.jdbc.Driver

lisadb.pool.dradis.url=jdbc:mysql://DBHOST:DBPORT/DBNAME

lisadb.pool.dradis.user=mysql_username

lisadb.pool.dradis.password=mysql_password