O'Reilly logo

Pentaho Data Integration 4 Cookbook by María Carina Roldán, Adrián Sergio Pulvirenti

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Introduction

Databases are broadly used by organizations to store and administer transactional ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required