Many people have chosen MongoDB—a leading NoSQL database—as their data storage solution over a relational database approach, and now they need to analyze and report on their data residing in MongoDB. Pentaho, the leading commercial open source analytics platform, decided to meet this need by forming an early partnership with MongoDB, enabling analytics and reporting on the document-oriented data structures inside MongoDB.
This chapter will introduce you to the powerful combination of MongoDB and Pentaho and will provide step-by-step guidance on how to install and configure both technologies as well as restore the sample MongoDB data provided with this book. We start with an overview of the technologies and then set up a local installation of both technologies along with sample data on a single Windows machine.
The following are the topics that we will cover in this chapter:
Overview of Pentaho and MongoDB
Installing MongoDB
Restoring the sample MongoDB database
Installing Pentaho Enterprise Edition
We will focus on the Pentaho Enterprise Edition for this book, because it includes the Big Data utility, Instaview, which we use in later chapters. By the end of this chapter, you will have Pentaho and MongoDB running on a Windows computer with the sample MongoDB database provided with this book and restored to your MongoDB server.