Adding Drivers for Web Analysis

If you are using an RDBMS as a data source or for relational drill-through, add the necessary drivers.

To add drivers for Windows:

Append EPM_ORACLE_INSTANCE/bin/deploymentScripts/setCustomParamsWebAnalysis.bat with an updated value for the EXT_POST_CLASSPATH variable. Add each RDBMS driver JAR file separately into the variable definition. For example:
```
set EXT_POST_CLASSPATH=C:/jdbcdrivers/db2java.jar;C:/jdbcdrivers/db2jcc.jar;C:/jdbcdrivers/db2jcc_license_cisuz.jar;C:/jdbcdrivers/ojdbc14.jar;%EXT_POST_CLASSPATH%
```
Editing this file affects only the Web Analysis services that were started using startWebAnalysis.bat in EPM_ORACLE_INSTANCE/bin.
Using Regedit, look in: HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\WebAnalysis\HyS9WebAnalysis\JVMOptionX for the –Djava.class.path value, and append the driver paths.
For example, for SQL Server, you might append:
```
C:\jdbc\msbase.jar;C:\jdbc\mssqlserver.jar;C:\jdbc\msutil.jar;C:\jdbc\sqljdbc.jar
```
The full list of JAR files:
- Oracle - ojdbc14.jar
- DB2 - db2java.jar db2jcc.jar db2jcc_license_cisuz.jar db2jcc_license_cu.jar
- SQL Server - msbase.jar mssqlserver.jar msutil.jar sqljdbc.jar
Restart Web Analysis.

To add drivers for UNIX:

Append EPM_ORACLE_INSTANCE/bin/deploymentScripts/setCustomParamsWebAnalysis.sh with an updated value for EXT_POST_CLASSPATH variable. Add each RDBMS driver JAR file into the variable definition separately. For example:
```
EXT_POST_CLASSPATH=$HOME/jdbcdrivers/db2java.jar:$HOME/jdbcdrivers/db2jcc.jar:$HOME/jdbcdrivers/db2jcc_license_cisuz.jar:$HOME/jdbcdrivers/ojdbc14.jar:${EXT_POST_CLASSPATH}
export EXT_POST_CLASSPATH
```
Restart Web Analysis.