Page Comparison

{excerpt}Sample Blend template for MongoDB{excerpt} 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.  NOTE: this sample blend does not include the Web-based Marketing data stored in MongoDB.  Therefore, you will be able to open the transformation and update the MongoDB connection information with your own MongoDB collections.  The sample customer usage data has been provided in the form of an Excel file so you can better understand how the pieces fit together.

{youtube}d_GPgWU5SgM{youtube}

h1. Prerequisites

In order to follow along with this how-to guide you will need a desktop installation of Pentaho Business Analytics.
[Download Pentaho|http://www.pentaho.com/download]


h2. Data Files

You will also need the sample Customer SupportUsage data spreadsheet available [here|GoogleMongDB Analytics Customer Service Blend^CustSupportData_GADemoMarketing Blend^ProductUsagePercentage.xls].   Save it to your data folder.  


h2. Add the GoogleMongoDB 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.
# *Get the Template*: Click [here|Google Analytics Customer Service Blend^GoogleAnalyticsBrowserBlendMongoDB Blend^MongDB_Blend.ktr] to download the template and save it to your PDI folder.  Open PDI and open the GoogleAnalyticsBrowserBlendMongoDB_Blend that you just downloaded.  Double click each onof the Customer ServiceMongoDB Input stepsteps and linkenter 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 name of the marketing collections in MongoDB you want to analyze.  Close the step and save the transformation.  


h2. 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

h2. Try the sample

# *Start*: Start up Pentaho Business Analytics and open the "GoogleAnalyticsBrowserBlend.ktr" template.
# From the
GoogleAnalyticsBrowserBlend
transformation:
# Click: "Google Analytics Input" step


** Enter a Google email, password and API key tied to your Google Analytics account as described above.
** Press the "Get Profiles" button to fill the drop down list with your web site information
** Select the website to profile from the "Get tableId from profile" dropdown
** Enter a start and end date
** You should use the "Preview" button on the bottom of the dialog to ensure your selections are correct.
** Press "OK" when done

# Open a browser and open the Pentaho User Console.
# Select Manage Data Sources
# Create a JDBC Driver (click the + and select JDBC)
_Click to enlarge image._
!sampleJDBCdriver.png|thumbnail,border=1!
# Create a data source using the data service from the GoogleAnalyticsBrowserBlendMongoDB_Blend transformation.
_Click to enlarge image._
!SampleDataSourceWizard.png|thumbnail,border=1!
# Create a new Analyzer view and begin to analyze the blended GoogleMongoDB and Customer ServiceUsage data.