O'Reilly logo

Pentaho Data Integration Cookbook Second Edition by María Carina Roldán, Adrián Sergio Pulvirenti, Alex Meadows

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

Looking for values in a database with dynamic queries

The Database join step that you learned to use in the previous recipe is quite powerful and has several advantages over the simple Database lookup step. There is a still more powerful step for searching in a database; The Dynamic SQL row step. This recipe explains to you its capabilities and shows you how to use it.

In order to let you compare the different options for searching in a database with ease, we will work with an example similar to that you saw in the previous two recipes—we will work with the Steel Wheels sample data. You want to look for the following products:

  • Products that contain Aston Martin in their description
  • Products that contain Ford Falcon in their name and with a scale ...

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