Book Image

Pentaho for Big Data Analytics

By : Manoj R Patil, Feris Thia
Book Image

Pentaho for Big Data Analytics

By: Manoj R Patil, Feris Thia

Overview of this book

<p>Pentaho accelerates the realization of value from big data with the most complete solution for big data analytics and data integration. The real power of big data analytics is the abstraction between data and analytics. Data can be distributed across the cluster in various formats, and the analytics platform should have the capability to talk to different heterogeneous data stores and fetch the filtered data to enrich its value.<br /><br />Pentaho Big Data Analytics is a practical, hands-on guide that provides you with clear, step-by-step exercises for using Pentaho to take advantage of big data systems, where data beats algorithm, and gives you a good grounding in using Pentaho Business Analytics’ capabilities.<br /><br />This book looks at the key ingredients of the Pentaho Business Analytics platform. We will see how to prepare the Pentaho BI environment, and get to grips with the big data ecosystem through. The book provides a clear guide to the essential tools of Pentaho Business Analytics, providing familiarity with both the various design tools for setting up reports, and the visualization tools necessary for complete data analysis.</p>
Table of Contents (14 chapters)
Pentaho for Big Data Analytics
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Creating data connections


To finish the chapter, we will show you how to create a MySQL data connection both in PAC and PUC. Follow these steps to create a new data connection from PAC:

  1. Click on the Administration tab in the left-hand pane.

  2. Click on the Database Connections tab in the center pane. You will see that there is already one connection defined, SampleData. The following screenshot shows the Database Connections tab:

  3. Click the plus (+) button in the title pane to add a new connection.

  4. Fill in the database connection details. The following configurations are taken from my local setup:

    • Name: PHIMinimart

    • Driver Class: com.mysql.jdbc.Driver

    • User Name: root

    • Password: (none)

    • URL: jdbc:mysql://localhost/phi_minimart

    If you are familiar with Java programming, this configuration is actually the JDBC connection string.

  5. Click on the Test button. If everything is ok, a successful notification dialog appears.

  6. Click on the OK button to finish the process.

  7. The PHIMinimart connection is now available as your...