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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
