Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration

  • 11h 52m
  • Matt Casters
  • John Wiley & Sons (US)
  • 2010

A complete guide to Pentaho Kettle, the Pentaho Data lntegration toolset for ETL

This practical book is a complete guide to installing, configuring, and managing Pentaho Kettle. If you’re a database administrator or developer, you’ll first get up to speed on Kettle basics and how to apply Kettle to create ETL solutions—before progressing to specialized concepts such as clustering, extensibility, and data vault models. Learn how to design and build every phase of an ETL solution.

  • Shows developers and database administrators how to use the open-source Pentaho Kettle for enterprise-level ETL processes (Extracting, Transforming, and Loading data)
  • Assumes no prior knowledge of Kettle or ETL, and brings beginners thoroughly up to speed at their own pace
  • Explains how to get Kettle solutions up and running, then follows the 34 ETL subsystems model, as created by the Kimball Group, to explore the entire ETL lifecycle, including all aspects of data warehousing with Kettle
  • Goes beyond routine tasks to explore how to extend Kettle and scale Kettle solutions using a distributed “cloud”

Get the most out of Pentaho Kettle and your data warehousing with this detailed guide—from simple single table data migration to complex multisystem clustered data integration tasks.

About the Author

Matt Casters is Founder of Kettle and works as Chief Data Integration at Pentaho, where he leads Kettle software development. Roland Bouman is an application developer focusing on open source web technology, databases, and business intelligence. Jos van Dongen is an independent business intelligence consultant and well-known author, analyst, and presenter.

In this Book

  • Introduction
  • ETL Primer
  • Kettle Concepts
  • Installation and Configuration
  • An Example ETL Solution—Sakila
  • ETL Subsystems
  • Data Extraction
  • Cleansing and Conforming
  • Handling Dimension Tables
  • Loading Fact Tables
  • Working with OLAP Data
  • ETL Development Lifecycle
  • Scheduling and Monitoring
  • Versioning and Migration
  • Lineage and Auditing
  • Performance Tuning
  • Parallelization, Clustering, and Partitioning
  • Dynamic Clustering in the Cloud
  • Real-Time Data Integration
  • Data Vault Management
  • Handling Complex Data Formats
  • Web Services
  • Kettle Integration
  • Extending Kettle
  • Errata
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Course Working with Scorecards, Dashboards, & Paginated Reports in Power BI
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Data Loading & Visualization in Power BI: Getting Started
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Book The Kubernetes Book, 2024 Edition