Copying the MongoDB JDBC library
We will be using some scripting in these recipes, so it's important to make sure that we have the MongoDB JDBC library copied to the correct location in our Pentaho server.
Getting ready
Make sure you have access to the filesystem that is running your Pentaho server.
How to do it…
Proceed with the following steps:
- In your filesystem, navigate to
PentahoEE/server/biserver-ee/pentaho-solutions/system/kettle/plugins/pentaho-mongodb-plugin/lib
. - Copy the
mongo-java-driver.xxx.jar
file from the folder. - Navigate to
PentahoEE/server/biserver-ee/tomcat/webapps/pentaho/WEB-INF/lib
. - Paste the
mongo-java-driver.xxx.jar
file. - Restart your Pentaho server.
How it works…
By default, it isn't possible to use the scripting/BeanShell data source in dashboards with MongoDB database. This is because the MongoDB Java driver isn't available for the plugin.
In this recipe, we copy the driver that is available in the Kettle BI Server plugin to the lib
folder of...