Summary

This chapter discussed how to use PDI to work with relational databases. You learned how to create connections from PDI to different database engines and to explore databases with the PDI Database Explorer. Then, you learned how to perform insert, update and delete operations on databases. 

You also learned to search for data on databases. First, you were introduced to the simplest way to search by using the Database lookup step. As that step has limitations, you were also introduced to other options that PDI offers for performing more complex lookups.

Finally, you also performed useful tasks such as checking a connection, verifying the existence of a table, running some DDLs, and more. In the next chapter, you will continue working with databases. Specifically, you will learn how to load a data mart.