Preparing the Environment

Preparing the Environment

How to:

Configure the Java CLASSPATH

The following components are the prerequisites needed to use the adapter for MongoDB:

Java. To use this Java-based adapter, you must have the JDK installed. MongoDB requires Version 1.6 or later. Java can be downloaded from
http://www.java.com.
The location of the JDK must be specified in an environment variable.

If you are using Linux, add a line to your profile with the location where Java is installed. For example:
```
export JAVA_HOME=/usr/java/jdk1.7.0_07 
```
Alternatively, add to the server environment. From the Data Management Console or the Web Console, go to the Workspace folder or page. Expand the Configuration Files and Miscellaneous folders. Double-click Environment - edaenv.cfg. Enter, for example
```
JAVA_HOME=/usr/java/jdk1.7.0_07
```
If you are using Windows, right-click Computer and select Properties. Then select Advanced System Settings and click Environment Variables. Add the locations to your PATH variable. For example:
```
C:\Program Files\Java\jdk7\bin\server;C:\Program Files\Java\jdk7\bin;
```
Unity JDBC Driver for MongoDB. The Unity JDBC driver can be downloaded from
http://www.unityjdbc.com/mongojdbc/mongo_jdbc.php. Follow the instructions to install the driver to a location of your choice. The JDBC driver consists of the followingtwo files:
```
\UnityJDBC\mongodb_unityjdbc_full.jar
\UnityJDBC\unityjdbc.jar
```
The free version of the UnityJDBC driver is limited to 100 rows after 30 days. The licensed version removes these restrictions.

Procedure: How to Configure the Java CLASSPATH

The location of the driver jar files must be specified to the server. You must extract the jar files to a location on your system and specify their location.

This can be done in the system CLASSPATH or in the DataMigrator or WebFOCUS Reporting Server IBI_CLASSPATH variable as follows:

From the Web Console menu bar, select Workspace
or

From the Data Management Console, expand the Workspace folder.
Expand the Java Services folder. Right-click DEFAULT and select Properties.
The Java Services Configuration page opens.
Click on the chevrons to expand Class Path
In the IBI_CLASSPATH box, enter the full location of the jar files shown below. The file names must be entered one per line.
```
path/unityjdbc.jar 
```
```
path/mongodb_unityjdbc_full.jar
```
Note: For a server running on Windows, use Windows syntax for directory names. For example:
```
directory\unityjdbc.jar 
```
```
directory\mongodb_unityjdbc_full.jar
```
Scroll down and click the Save and Restart Java Services button.

WebFOCUS