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.
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.
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 the Pentaho web app. In this way...