Pentaho Analytics for MongoDB Cookbook

The PDI MongoDB Lookup step

The PDI MongoDB Map/Reduce Output step

The PDI MongoDB GridFS Output Step

The PDI MongoDB Delete Step

Introduction

Chapter 8. Pentaho Community Contributions

Creating a Dashboard line chart component

Creating a Dashboard Table component

Defining dashboard layouts

Using a Thin Kettle data source

Using Pentaho Analyzer for MongoDB data source

Using a BeanShell data source

Using a transformation data source

Importing a sample repository

Copying the MongoDB JDBC library

Introduction

Chapter 7. Pentaho Dashboards

Creating a dashboard using Pentaho Dashboard Designer

Creating a new analysis view using Pentaho Analyzer

Importing Foodmart MongoDB sample data

Introduction

Chapter 6. The Pentaho BI Server

Running a report in the Pentaho server

Publishing a report to the Pentaho server

Creating a report with MongoDB via Java

Creating subreports

Grouping data in reports

Adding a formula to a report

Adding parameters to a report

Adding a chart to a report

Connecting to MongoDB via PDI

Connecting to MongoDB using Reporting Wizard

Copying the MongoDB JDBC library

Introduction

Chapter 5. Pentaho Reporting

Publishing a Mondrian 4 schema

Creating a Mondrian 4 cube

Creating a Mondrian 4 physical schema

Saving and publishing a Mondrian schema

Creating the customer and product dimensions

Creating an Orders cube

Creating a date dimension

Introduction

Chapter 4. A MongoDB OLAP Schema

Exploring saving deleting and opening analysis reports

Modifying the Instaview model

Modifying Instaview transformations

Creating an analysis view

Introduction

Chapter 3. Pentaho Instaview

Define a connection using a SQL Client (SQuirreL SQL)

Running the Pentaho Data Integration server in a single instance

Running the Carte server in a single instance

Using a transformation as a data service

Introduction

Chapter 2. The Thin Kettle JDBC Driver

Working with jobs and filtering MongoDB data using parameters and variables

MongoDB Map/Reduce using the User Defined Java Class step and MongoDB Java Driver

Exporting MongoDB data using the aggregation framework

Migrating data from files to MongoDB

Loading data from MongoDB to MySQL

Migrating data from the RDBMS to MongoDB

Learning basic operations with Pentaho Data Integration

Introduction

Chapter 1. PDI and MongoDB

Customer support

Reader feedback

Conventions

Sections

Who this book is for

What you need for this book

What this book covers

Pentaho Installation

Preface

Support files eBooks discount offers and more

www.PacktPub.com

About the Reviewers

About the Authors

Credits

版权页

封面

封面

版权页

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Support files eBooks discount offers and more

Preface

Pentaho Installation

What this book covers

What you need for this book

Who this book is for

Sections

Conventions

Reader feedback

Customer support

Chapter 1. PDI and MongoDB

Introduction

Learning basic operations with Pentaho Data Integration

Migrating data from the RDBMS to MongoDB

Loading data from MongoDB to MySQL

Migrating data from files to MongoDB

Exporting MongoDB data using the aggregation framework

MongoDB Map/Reduce using the User Defined Java Class step and MongoDB Java Driver

Working with jobs and filtering MongoDB data using parameters and variables

Chapter 2. The Thin Kettle JDBC Driver

Introduction

Using a transformation as a data service

Running the Carte server in a single instance

Running the Pentaho Data Integration server in a single instance

Define a connection using a SQL Client (SQuirreL SQL)

Chapter 3. Pentaho Instaview

Introduction

Creating an analysis view

Modifying Instaview transformations

Modifying the Instaview model

Exploring saving deleting and opening analysis reports

Chapter 4. A MongoDB OLAP Schema

Introduction

Creating a date dimension

Creating an Orders cube

Creating the customer and product dimensions

Saving and publishing a Mondrian schema

Creating a Mondrian 4 physical schema

Creating a Mondrian 4 cube

Publishing a Mondrian 4 schema

Chapter 5. Pentaho Reporting

Introduction

Copying the MongoDB JDBC library

Connecting to MongoDB using Reporting Wizard

Connecting to MongoDB via PDI

Adding a chart to a report

Adding parameters to a report

Adding a formula to a report

Grouping data in reports

Creating subreports

Creating a report with MongoDB via Java

Publishing a report to the Pentaho server

Running a report in the Pentaho server

Chapter 6. The Pentaho BI Server

Introduction

Importing Foodmart MongoDB sample data

Creating a new analysis view using Pentaho Analyzer

Creating a dashboard using Pentaho Dashboard Designer

Chapter 7. Pentaho Dashboards

Introduction

Copying the MongoDB JDBC library

Importing a sample repository

Using a transformation data source

Using a BeanShell data source

Using Pentaho Analyzer for MongoDB data source

Using a Thin Kettle data source

Defining dashboard layouts

Creating a Dashboard Table component

Creating a Dashboard line chart component

Chapter 8. Pentaho Community Contributions

Introduction

The PDI MongoDB Delete Step

The PDI MongoDB GridFS Output Step

The PDI MongoDB Map/Reduce Output step

The PDI MongoDB Lookup step