Over 50 recipes to learn how to use Pentaho Analytics and MongoDB to create powerful analysis and reporting solutions
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.
Chapter 1: PDI and MongoDB 1About This Book
- Create reports and stunning dashboards with MongoDB data
- Accelerate data access and maximize productivity with unique features of Pentaho for MongoDB
- A step-by-step recipe-based guide for making full use of Pentaho suite tools with MongoDB
Who This Book Is For
This book is intended for data architects and developers with a basic level of knowledge of MongoDB. Familiarity with Pentaho is not expected.What You Will Learn
- Extract, load, and transform data from MongoDB collections to other datasources
- Design Pentaho Reports using different types of connections for MongoDB
- Create a OLAP mondrian schema for MongoDB
- Explore your MongoDB data using Pentaho Analyzer
- Utilize the drag and drop web interface to create dashboards
- Use Kettle Thin JDBC with MongoDB for analysis
- Integrate advanced dashboards with MondoDB using different types of connections
- Publish and run a report on Pentaho BI server using a web interface
In Detail
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.
Style and approach
A comprehensive, recipe-based guide to take complete advantage of the Pentaho Analytics for MongoDB.Introduction 1
Learning basic operations with Pentaho Data Integration 2
Migrating data from the RDBMS to MongoDB 4
Loading data from MongoDB to MySQL 11
Migrating data from files to MongoDB 14
Exporting MongoDB data using the aggregation framework 18
MongoDB Map/Reduce using the User Defined Java Class step
and MongoDB Java Driver 20
Working with jobs and filtering MongoDB data using parameters
and variables 25
Chapter 2: The Thin Kettle JDBC Driver 29
Introduction 29
Using a transformation as a data service 30
Running the Carte server in a single instance 32
Running the Pentaho Data Integration server in a single instance 35
Define a connection using a SQL Client (SQuirreL SQL) 39
Chapter 3: Pentaho Instaview 45
Introduction 45
Creating an analysis view 45
Modifying Instaview transformations 48
Modifying the Instaview model 50
Exploring, saving, deleting, and opening analysis reports 55
Chapter 4: A MongoDB OLAP Schema 59
Introduction 59
Creating a date dimension 60
Creating an Orders cube 67
Creating the customer and product dimensions 72
Saving and publishing a Mondrian schema 78
Creating a Mondrian 4 physical schema 83
Creating a Mondrian 4 cube 86
Publishing a Mondrian 4 schema 88
Chapter 5: Pentaho Reporting 91
Introduction 91
Copying the MongoDB JDBC library 92
Connecting to MongoDB using Reporting Wizard 92
Connecting to MongoDB via PDI 98
Adding a chart to a report 101
Adding parameters to a report 104
Adding a formula to a report 111
Grouping data in reports 114
Creating subreports 118
Creating a report with MongoDB via Java 122
Publishing a report to the Pentaho server 125
Running a report in the Pentaho server 128
Chapter 6: The Pentaho BI Server 131
Introduction 131
Importing Foodmart MongoDB sample data 131
Creating a new analysis view using Pentaho Analyzer 134
Creating a dashboard using Pentaho Dashboard Designer 140
Chapter 7: Pentaho Dashboards 145
Introduction 145
Copying the MongoDB JDBC library 146
Importing a sample repository 147
Using a transformation data source 147
Using a BeanShell data source 152
Using Pentaho Analyzer for MongoDB data source 155
Using a Thin Kettle data source 161
Defining dashboard layouts 164
Creating a Dashboard Table component 171
Creating a Dashboard line chart component 174
Chapter 8: Pentaho Community Contributions 179
Introduction 179
The PDI MongoDB Delete Step 180
The PDI MongoDB GridFS Output Step 183
The PDI MongoDB Map/Reduce Output step 186
The PDI MongoDB Lookup step 189
No comments:
Post a Comment