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 ...
Get Pentaho Data Integration Cookbook Second Edition 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.
