Chapter 9. Integrating Kettle and the Pentaho Suite

In this chapter, we will cover:

  • Creating a Pentaho report with data coming from PDI
  • Creating a Pentaho report directly from PDI
  • Configuring the Pentaho BI Server for running PDI jobs and transformations
  • Executing a PDI transformation as part of a Pentaho process
  • Executing a PDI job from the Pentaho User Console
  • Populating a CDF dashboard with data coming from a PDI transformation

Introduction

Kettle, also known as PDI, is mostly used as a standalone application. However, it is not an isolated tool, but part of the Pentaho Business Intelligence Suite. As such, it can also interact with other components of the suite, For example, having Kettle act as the data source for a report or a dashboard, or even ...

Get Pentaho Data Integration Cookbook Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.