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:

  1. In your filesystem, navigate to PentahoEE/server/biserver-ee/pentaho-solutions/system/kettle/plugins/pentaho-mongodb-plugin/lib.
  2. Copy the mongo-java-driver.xxx.jar file from the folder.
  3. Navigate to PentahoEE/server/biserver-ee/tomcat/webapps/pentaho/WEB-INF/lib.
  4. Paste the mongo-java-driver.xxx.jar file.
  5. 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 the Pentaho web app. In this way, we can use the MongoDB driver classes in the Pentaho dashboard.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset