TRAINING

Enroll Now

Pentaho Training  

Pentaho Data Integration is an open-source data integration tool for defining jobs and data transformations.

In this instructor-led, live training, participants will learn how to use Pentaho Data Integration's powerful ETL capabilities and rich GUI to manage an entire big data lifecycle, maximizing the value of data to the organization.

By the end of this training, participants will be able to:

Create, preview, and run basic data transformations containing steps and hops Configure and secure the Pentaho Enterprise Repository Harness disparate sources of data and generate a single, unified version of the truth in an analytics-ready format. Provide results to third-part applications for further processing

Audience

• Data Analyst
• ETL developers

Pentaho Course Content

Introduction

• Objectives & Class Logistics
• What is Pentaho Data Integration (PDI)?

Transformation Basics

• Learning the PDI User Interface
• Creating Transformations
• Generate Rows, Sequence, Select Values
• Error Handling & Logging Introduction
• Introduction to Repositories

READING & WRITING FILES

• Input & Output Steps
• Parameters & kettle.properties
• CSV Input to Multiple Text Output Using Switch/Case
• Serializing Multiple Text Files
• De-serialize a File

WORKING WITH DATABASES

• Connecting to & Exploring a Database
• Table Input & Output
• Reading & Writing to Database Tables
• Insert, Update, & Delete Steps
• Data Cleansing
• Using Parameters & Arguments in SQL
• Input with Parameters & Table Copy Wizard

DATA FLOWS & LOOKUPS

•  Copying and Distributing Data
• Parallel Processing
• Lookups
• Lookups & Data Formatting
• Merging Data

CALCULATIONS

• Designer
• Using the Group By Step
• Calculator
• Calculating & Aggregating Order Quantity
• Regular Expression
• User Defined Java Expression
• JavaScript

JOB ORCHESTRATION

• Introduction to Jobs
• Loading JVM Data into a Table
• Sending Alerts
• Looping & Conditions
• Creating a Job with a Loop
• Executing Jobs from a Terminal Window (Kitchen)

SCHEDULING

• Setting up the Scheduler
• Monitoring Scheduled Tasks)

EXPLORING DATA INTEGRATION REPOSITORIES

• The Pentaho Data Integration Repository
• Using the Pentaho Enterprise Repository

DETAILED LOGGING

• I Detailed Logging throughout Execution