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:
PentahoEE/server/biserver-ee/pentaho-solutions/system/kettle/plugins/pentaho-mongodb-plugin/lib
.mongo-java-driver.xxx.jar
file from the folder.PentahoEE/server/biserver-ee/tomcat/webapps/pentaho/WEB-INF/lib
.mongo-java-driver.xxx.jar
file.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, we can use the MongoDB driver classes in the Pentaho dashboard.