Configure WebSphere Environment Variable for Database Driver
- Configure WebSphere Environment Variable for Database Driver.
- A variable must be used to define the location where the database driver is located. The name of the variable depends on the type of database.
- Oracle: ORACLE_JDBC_DRIVER_PATH
- IBM DB2: DB2UNIVERSAL_JDBC_DRIVER_PATH and DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH
- Select Environment>WebSphere Variables.
- Select the scope of the ODS server from the drop-down list.
- Click New.
- Enter the name of the database driver variable, as listed above.
- In the Value field, enter the path to the directory where the database driver is located.
For example: /opt/oracle/db_drivers or C:\oracle\ods\db_drivers
- Click OK.