During configuration, on the Configure Database page, click Advanced to specify additional JDBC parameters, which are used by EPM System JDBC drivers to connect to the database.
The following table describes the format to use to enter the parameters if you are using JDBC drivers.
| Database | Format |
|---|---|
| Oracle Database | jdbc:oracle:thin:@hostname:port:SID |
| SQL Server | jdbc:weblogic:sqlserver://hostname:port;databaseName=databaseName |
| DB2 | jdbc:weblogic:db2://hostname:port;databaseName=databaseName;DynamicSections=3000 |
The following table describes additional information about the parameters:
| Property | SQL Server | DB2 |
|---|---|---|
| LOADLIBRARYPATH | Yes | Yes |
| MAXPOOLEDSTATEMENTS | Yes | Yes |
| ALTERNATESERVERS | Yes | Yes |
| CONNECTIONRETRYCOUNT | Yes | Yes |
| CONNECTIONRETRYDELAY | Yes | Yes |
| LOADBALANCING | Yes | Yes |
| DYNAMICSECTIONS | Yes | |
| CREATEDEFAULTPACKAGE | Yes | |
| REPLACEPACKAGE | Yes | |
| DATABASENAME | Yes | Yes |
For Oracle Database parameters, see the Oracle Thin JDBC Driver documentation.