Hitachi Vantara Pentaho Community Wiki
Child pages
  • MongoDB Blend

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin


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.

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.


  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.
    Image Removed Image Added
  4. Create a data source using the data service from the MongoDB_Blend transformation.
    Click to enlarge image.
    Image Removed Image Added
  5. Create a new Analyzer view and begin to analyze the blended MongoDB and Customer Usage data.