Summary

This chapter discussed how to use PDI to work with databases. Specifically, the chapter covered the following:

  • Introduction to the Pentaho Sample Data Steel Wheels—the starting point for you to learn basic database theory
  • Creating connections from PDI to different database engines
  • Exploring databases with the PDI Database explorer
  • Basics of SQL
  • Performing CRUD (Create, Read, Update, and Delete) operations on databases

In the next chapter you will continue working with databases. You will learn some advanced concepts, including datawarehouse-specific operations.

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.