Preparing the MongoDB 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.7 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/lib/jvm/jre-1.7.0
```
If you have JDK installed:
```
export JAVA_HOME=/usr/lib/jvm/jdk-1.7.0
```
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 has an embedded MongoDB Java driver:
```
\unityJDBC\mongodb_unityjdbc_full.jar
```
Alternatively, you can use the following two files:
```
\UnityJDBC\unityjdbc.jar
\UnityJDBC\drivers\Mongo\mongo-java-driver-2.13.0.jar
```
The free version of the UnityJDBC driver is limited to 100 rows after 30 days. The licensed version removes these restrictions.
Mongo. To read data from Mongo, the server only requires the JDBC driver. However, to write data to Mongo using DataMigrator, Quick Copy, or Insert Sample Data, the Mongo import program is used. In order for the server to find this program, add the Mongo Bin directory to your PATH.

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 listed above. The file names must be entered one per line.

Note: For a server running on Windows, use Windows syntax for directory names
Scroll down and click the Save and Restart Java Services button.