Sample Blend template for MongoDB

that can be easily added to your installation. It demonstrates how to blend data from a sample customer support system with MongoDB web-based marketing campaign data.

d_GPgWU5SgM

Prerequisites

In order to follow along with this how-to guide you will need a desktop installation of Pentaho Business Analytics.
Download Pentaho

Data Files

You will also need the sample Customer Support spreadsheet available here. Save it to your data folder.

Add the Google Analytics Blend sample template to your copy of Pentaho Data Integration

Now that there is data in the right place, all you need to do is open the template and point to the data file.

  1. Get the Template: Click here to download the template and save it to your PDI folder. Open PDI and open the GoogleAnalyticsBrowserBlend that you just downloaded. Double click on the Customer Service Input step and link to the data file you downloaded, then close the step. Open the Google Analytics Input step and enter you're username, password and token, and select the website you want to analyze. Close the step and save the transformation.

Configure JDBC Driver:

Follow the directions to configure the Thin Kettle JDBC driver: http://wiki.pentaho.com/display/EAI/Configuration+of+the+Thin+Kettle+JDBC+driver

Try the sample

  1. Start: Start up Pentaho Business Analytics and open the "GoogleAnalyticsBrowserBlend.ktr" template.
  2. From the GoogleAnalyticsBrowserBlend transformation:
  3. Click: "Google Analytics Input" step
  1. Open a browser and open the Pentaho User Console.
  2. Select Manage Data Sources
  3. Create a JDBC Driver (click the + and select JDBC)
    Click to enlarge image.
  4. Create a data source using the data service from the GoogleAnalyticsBrowserBlend transformation.
    Click to enlarge image.
  5. Create a new Analyzer view and begin to analyze the blended Google and Customer Service data.