Chapter 1. Working with Databases

In this chapter, we will cover:

• Connecting to a database

• Getting data from a database

• Getting data from a database by providing parameters

• Getting data from a database by running a query built at runtime

• Inserting or updating rows in a table

• Inserting new rows when a simple primary key has to be generated

• Inserting new rows when the primary key has to be generated based on stored values

• Deleting data from a table

• Creating or altering a table from PDI (design time)

• Creating or altering a table from PDI (runtime)

• Inserting, deleting, or updating a table depending on a field

• Changing the database connection at runtime

• Loading a parent-child table

• Building SQL queries via database metadata

• Performing repetitive database design tasks from PDI