Pentaho Data Integration

Module 1: Introduction to Pentaho Data Integration

Lesson 1: Goals & 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

Lesson 3: Error Handling and Logging Introduction

Lesson 4: Introduction to Repositories

Module 3: Reading & Writing Files

Lesson 1: Input & Output Steps

Lesson 2: Parameters & kettle.properties

Module 4: Working with databases

Lesson 1: Connecting to a database & Explore

Lesson 2: Tables Input & Output

Lesson 3: Inserting, Updating & Deleting Steps

Lesson 4: Data Cleansing

Lesson 5: Using parameters and arguments in SQL

Module 5: Data Flows & Lookup

Lesson 1: Copying and distributing data

Lesson 2: Lookups

Lesson 3: Merging Data

Module 6: Calculations

Lesson 1: Using the Group By Step

Lesson 2: Calculators

Lesson 3: Regular Expression

Lesson 4: Custom Java Expression

Lesson 5: JavaScript

Module 7: Orchestrating Jobs

Lesson 1: Introduction to Jobs

Lesson 2: Sending Alerts

Lesson 3: Looping Conditions

Lesson 4: Running Jobs from a Terminal Window

Module 8: Scheduling

Lesson 1: Setting up the Scheduler

Lesson 2: Monitoring Scheduled Tasks

Module 9: Examining Data Integration Repositories

Lesson 1: The Pentaho Data Integration Repository

Module 10: Detailed Logging

Lesson 1: Detailed logging of the entire execution

Pentaho Report Designer I

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

• Implementation guarantee - Implementation guarantee for two or more participants
• Mobile classrooms - the ideal complement for company seminars
• Free support - for questions after the seminar
• Delivery on account - no prepayment required
• Interview with the trainer / quality assurance - get to know and assess the trainer in advance
• Clarify seminar requirements - review your knowledge with the trainer
• Assistance with travel costs - we cover part of the costs of hotel accommodation
• Meals - all day cold / hot drinks and a full lunch in the restaurant
• Location of training centres - always centrally located and easily accessible
• Discount - we have attractive prices, take advantage of our additional discounts
• Remotelabs - rent our Remotelabs for your own seminars or as a complement to your company seminars