You're reading from Pentaho Data Integration Beginner's Guide - Second Edition Get up and running with the Pentaho Data Integration tool using this hands-on, easy-to-read guide with this book and ebook

Product type Paperback

Published in Oct 2013

Publisher Packt

ISBN-13 9781782165040

Length 502 pages

Edition 2nd Edition

Languages

Java

Tools

Pentaho

Concepts

Data Visualization

Author (1):

María Carina Roldán

View More author details

Table of Contents (21) Chapters

Preface

1. Getting Started with Pentaho Data Integration

2. Getting Started with Transformations FREE CHAPTER

3. Manipulating Real-world Data

4. Filtering, Searching, and Performing Other Useful Operations with Data

5. Controlling the Flow of Data

6. Transforming Your Data by Coding

7. Transforming the Rowset

8. Working with Databases

9. Performing Advanced Operations with Databases

10. Creating Basic Task Flows

11. Creating Advanced Transformations and Jobs

12. Developing and Implementing a Simple Datamart

A. Working with Repositories

B. Pan and Kitchen – Launching Transformations and Jobs from the Command Line

C. Quick Reference – Steps and Job Entries

D. Spoon Shortcuts

E. Introducing PDI 5 Features

F. Best Practices

Summary

G. Pop Quiz Answers

Index

Time for action – creating a connection to the Steel Wheels database

In this first database tutorial, you will download the sample database and create a connection for accessing it from the PDI.

Note

The Pentaho BI demo includes the sample data. So, if you have already downloaded the demo as explained in Chapter 1, Getting started with Pentaho Data Integration, just skip the first three steps. If the Pentaho BI demo is running on your machine, the database server is running as well. In that case, skip the first four steps.

Go to the Pentaho Download site http://sourceforge.net/projects/pentaho/files/.
Under the Business Intelligence Server | 1.7.1-stable look for the file named pentaho_sample_data-1.7.1.zip and download it.
Note
This is the only version of the sample database available for downloading alone. Despite being located together with a really outdated version of the Business Intelligence Server, the sample data is the same as the one bundled in recent versions.
Unzip the downloaded...