Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Pentaho Analytics for MongoDB Cookbook
  • Table Of Contents Toc
Pentaho Analytics for MongoDB Cookbook

Pentaho Analytics for MongoDB Cookbook

By : Joel Andre Latino, Harris Ward
Buy this Book
close
close
Pentaho Analytics for MongoDB Cookbook

Pentaho Analytics for MongoDB Cookbook

By: Joel Andre Latino, Harris Ward
Buy this Book

Overview of this book

MongoDB is an open source, schemaless NoSQL database system. Pentaho as a famous open source Analysis tool provides high performance, high availability, and easy scalability for large sets of data. The variant features in Pentaho for MongoDB are designed to empower organizations to be more agile and scalable and also enables applications to have better flexibility, faster performance, and lower costs. Whether you are brand new to online learning or a seasoned expert, this book will provide you with the skills you need to create turnkey analytic solutions that deliver insight and drive value for your organization. The book will begin by taking you through Pentaho Data Integration and how it works with MongoDB. You will then be taken through the Kettle Thin JDBC Driver for enabling a Java application to interact with a database. This will be followed by exploration of a MongoDB collection using Pentaho Instant view and creating reports with MongoDB as a datasource using Pentaho Report Designer. The book will then teach you how to explore and visualize your data in Pentaho BI Server using Pentaho Analyzer. You will then learn how to create advanced dashboards with your data. The book concludes by highlighting contributions of the Pentaho Community.
Table of Contents (10 chapters)
close
close
close
Preface
Icon
Preface
Icon
Pentaho Installation
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Sections
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. PDI and MongoDB
chevron up
Icon
1. PDI and MongoDB
Icon
Introduction
Icon
Learning basic operations with Pentaho Data Integration
Icon
Migrating data from the RDBMS to MongoDB
Icon
Loading data from MongoDB to MySQL
Icon
Migrating data from files to MongoDB
Icon
Exporting MongoDB data using the aggregation framework
Icon
MongoDB Map/Reduce using the User Defined Java Class step and MongoDB Java Driver
Icon
Working with jobs and filtering MongoDB data using parameters and variables
2
2. The Thin Kettle JDBC Driver
Icon
2. The Thin Kettle JDBC Driver
Icon
Introduction
Icon
Using a transformation as a data service
Icon
Running the Carte server in a single instance
Icon
Running the Pentaho Data Integration server in a single instance
Icon
Define a connection using a SQL Client (SQuirreL SQL)
3
3. Pentaho Instaview
Icon
3. Pentaho Instaview
Icon
Introduction
Icon
Creating an analysis view
Icon
Modifying Instaview transformations
Icon
Modifying the Instaview model
Icon
Exploring, saving, deleting, and opening analysis reports
4
4. A MongoDB OLAP Schema
Icon
4. A MongoDB OLAP Schema
Icon
Introduction
Icon
Creating a date dimension
Icon
Creating an Orders cube
Icon
Creating the customer and product dimensions
Icon
Saving and publishing a Mondrian schema
Icon
Creating a Mondrian 4 physical schema
Icon
Creating a Mondrian 4 cube
Icon
Publishing a Mondrian 4 schema
5
5. Pentaho Reporting
Icon
5. Pentaho Reporting
Icon
Introduction
Icon
Copying the MongoDB JDBC library
Icon
Connecting to MongoDB using Reporting Wizard
Icon
Connecting to MongoDB via PDI
Icon
Adding a chart to a report
Icon
Adding parameters to a report
Icon
Adding a formula to a report
Icon
Grouping data in reports
Icon
Creating subreports
Icon
Creating a report with MongoDB via Java
Icon
Publishing a report to the Pentaho server
Icon
Running a report in the Pentaho server
6
6. The Pentaho BI Server
Icon
6. The Pentaho BI Server
Icon
Introduction
Icon
Importing Foodmart MongoDB sample data
Icon
Creating a new analysis view using Pentaho Analyzer
Icon
Creating a dashboard using Pentaho Dashboard Designer
7
7. Pentaho Dashboards
Icon
7. Pentaho Dashboards
Icon
Introduction
Icon
Copying the MongoDB JDBC library
Icon
Importing a sample repository
Icon
Using a transformation data source
Icon
Using a BeanShell data source
Icon
Using Pentaho Analyzer for MongoDB data source
Icon
Using a Thin Kettle data source
Icon
Defining dashboard layouts
Icon
Creating a Dashboard Table component
Icon
Creating a Dashboard line chart component
8
8. Pentaho Community Contributions
Icon
8. Pentaho Community Contributions
Icon
Introduction
Icon
The PDI MongoDB Delete Step
Icon
The PDI MongoDB GridFS Output Step
Icon
The PDI MongoDB Map/Reduce Output step
Icon
The PDI MongoDB Lookup step
9
Index
Icon
Index

Learning basic operations with Pentaho Data Integration

The following recipe is aimed at showing you the basic building blocks that you can use for the rest of the recipes in this chapter. We recommend that you work through this simple recipe before you tackle any of the others. If you want, PDI also contains a large selection of sample transformations for you to open, edit, and test. These can be found in the sample directory of PDI.

Getting ready

Before you can begin this recipe, you will need to make sure that the JAVA_HOME environment variable is set properly. By default, PDI tries to guess the value of the JAVA_HOME environment variable. Note that for this book, we are using Java 1.7. As soon as this is done, you're ready to launch Spoon, the graphical development environment for PDI. To start Spoon, you can use the appropriate scripts located at the PDI home folder. To start Spoon in Windows, you will have to execute the spoon.bat script in the home folder of PDI. For Linux or Mac, you will have to execute the spoon.sh bash script instead.

How to do it…

First, we need configure Spoon to be able to create transformations and/or jobs. To acclimatize to the tool, perform the following steps:

  1. Create a new empty transformation:
    1. Click on the New file button from the toolbar menu and select the Transformation item entry. You can also navigate to File | New | Transformation from the main menu. Ctrl + N also creates a new transformation.
  2. Set a name for the transformation:
    1. Open the Transformation settings dialog by pressing Ctrl + T. Alternatively, you can right-click on the right-hand-side working area and select Transformation settings. Or on the menu bar, select the Settings... item entry from the Edit menu.
    2. Select the Transformation tab.
    3. Set Transformation Name to First Test Transformation.
    4. Click on the OK button.
  3. Save the transformation:
    1. Click on the Save current file button from the toolbar. Alternatively, from the menu bar, go to File | Save. Or finally, use the quick option by pressing Ctrl + S.
    2. Choose the location of your transformation and give it the name chapter1-first-transformation.
    3. Click on the OK button.
  4. Run a transformation using Spoon.
    1. You can run the transformation by either of these ways: click on the green play icon on the transformation toolbar and navigate to Action | Run on the main menu or simply press F9.
    2. You will get an Execute a transformation dialog. Here, you can set parameters, variables, or arguments if they are required for running the transformation.
    3. Run the transformation by clicking on the Launch button.
  5. Run the transformation in preview mode using Spoon.
    1. In the Transformation debug dialog, select the step you want to preview the output data.
    2. After selecting the desired output step, you can preview the transformation by either clicking on the magnify icon on the transformation toolbar, going to Action | Preview on the main menu, or simply pressing F10.
    3. You will get a Transformation debug dialog that you can use to define the number of rows you want to see, breakpoints, and the step that you want analyze.
    4. You can click on the Configure button to define parameters, variables, or arguments. Click on the Quick Launch button to preview the transformation.

How it works…

In this recipe, we just introduced the Spoon tool, touching on the main basic points for you to manage ETL transformations. We started by creating a transformation. We gave a name to the transformation, First Test Transformation in this case. Then, we saved the transformation in the filesystem with the name chapter1-first-transformation.

Finally, we ran the transformation normally and in debug mode. Understanding how to run a transformation in debug mode is useful for future ETL developments as it helps you understand what is happening inside of the transformation.

There's more…

In the PDI home folder, you will find a large selection of sample transformations and jobs that you can open, edit, and run to better understand the functionality of the diverse steps available in PDI.

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Pentaho Analytics for MongoDB Cookbook
End of Section 1
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon