MODULE 1: INTRODUCTION TO PENTAHO DATA INTEGRATION

  Lesson 1: Objectives & Class Logistics

  Lesson 2: What is Pentaho Data Integration (PDI)?

 

MODULE 2: TRANSFORMATION BASICS

  Lesson 1: Learning the PDI User Interface

  Lesson 2: Creating Transformations

      Exercise 1: Generate Rows, Sequence, Select Values

  Lesson 3: Error Handling & Logging Introduction

  Lesson 4: Introduction to Repositories

 

MODULE 3: READING & WRITING FILES

  Lesson 1: Input & Output Steps

  Lesson 2: Parameters & kettle.properties

      Exercise 2: CSV Input to Multiple Text Output Using Switch/Case

      Exercise 3: Serializing Multiple Text Files

      Exercise 4: De-serialize a File

MODULE 4: WORKING WITH DATABASES

  Lesson 1: Connecting to & Exploring a Database

  Lesson 2: Table Input & Output

      Exercise 5: Reading & Writing to Database Tables

  Lesson 3: Insert, Update, & Delete Steps

  Lesson 4: Data Cleansing

  Lesson 5: Using Parameters & Arguments in SQL

      Exercise 6: Input with Parameters & Table Copy Wizard

 

MODULE 5: DATA FLOWS & LOOKUPS

  Lesson 1: Copying and Distributing Data

      Exercise 7: Parallel Processing

  Lesson 2: Lookups

      Exercise 8: Lookups & Data Formatting

  Lesson 3: Merging Data

 

MODULE 6: CALCULATIONS

  Lesson 1: Using the Group By Step

  Lesson 2: Calculator

      Exercise 9: Calculating & Aggregating Order Quantity

  Lesson 3: Regular Expression

  Lesson 4: User Defined Java Expression

  Lesson 5: JavaScript

 

MODULE 7: JOB ORCHESTRATION

  Lesson 1: Introduction to Jobs

      Exercise 10: Loading JVM Data into a Table

  Lesson 2: Sending Alerts

  Lesson 3: Looping & Conditions

      Exercise 11: Creating a Job with a Loop

  Lesson 4: Executing Jobs from a Terminal Window (Kitchen)

 

MODULE 8: SCHEDULING

  Lesson 1: Setting up the Scheduler

  Lesson 2: Monitoring Scheduled Tasks

 

MODULE 9: EXPLORING DATA INTEGRATION REPOSITORIES

  Lesson 1: The Pentaho Data Integration Repository

      Exercise 12: Using the Pentaho Enterprise Repository

 

MODULE 10: DETAILED LOGGING

  Lesson 1: Detailed Logging throughout Execution

 

Module 11 - Metadata Injection

Metadata Injection Concepts

Metadata Injection Workflows

Standard Metadata Injection

Push Metadata Injection

Pull Metadata Injection

Push/Pull Metadata Injection

Phase Metadata Injection

Using Filters in Metadata Injection (2-Phase Metadata Injection

Lab: Retail Case Study

Module 12 : PDI as a Data Source

Report Designer

Pentaho Reporting Step

Pentaho Reporting - Parameters

Report Designer – PDI Transformation

Community Data Access