Book Image

Pentaho Analytics for MongoDB

By : Bo Borland
Book Image

Pentaho Analytics for MongoDB

By: Bo Borland

Overview of this book

<p>Pentaho Analytics for MongoDB will teach you MongoDB and Pentaho integration points and developer skills needed to create turnkey analytic solutions that deliver insight and drive value for your organization.<br /><br />Starting with how to install, configure, and develop content in both Pentaho and MongoDB, this book will give you the complete range of skills needed to gain insight into MongoDB data using Pentaho Business Analytics.&nbsp; You will learn about MongoDB data models and query techniques, which are covered in combination with the provided sample MongoDB database. You then advance to data integration, analysis, and reporting using Pentaho.<br /><br />You will learn how to use Pentaho Data Integration to blend and enrich data from additional sources. From this blended data, you will develop professional-looking reports and analysis views that are visual and interactive. Lastly, we will cover the Pentaho web portal and web interfaces for deploying analytics out to a broader set of consumer users.</p>
Table of Contents (15 chapters)
Pentaho Analytics for MongoDB
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Using the Data Source Wizard to model your data


Pentaho provides a web-based Data Source Wizard in PUC to enable business users to quickly create data sources for analysis and interactive reporting. The Data Source Wizard guides you through the process of creating a connection to CSV files and JDBC-compliant data sources and creating cube and relational metadata models. The Data Source Wizard is accessed from the Manage Data Sources button on the Home perspective. Now that we have successfully loaded the blended clickstream dataset into a PostgreSQL database, we can use the wizard to access it from a browser.

Creating a JDBC connection and default metadata model

In the next exercise, we create a JDBC connection to the hibernate database and model metadata using the Data Source Wizard:

  1. Launch a web browser and enter the URL http:/localhost:8080/pentaho to launch PUC.

  2. Select Login as an Evaluator and Administrator, and then click on the GO button.

  3. After PUC loads, click on the Manage Data Sources...