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 of 1:18

• Products that contain Corvette in their name and with a scale of 1:24

Getting ready

In order to follow this recipe, you need the Steel Wheels database.

How to do it...

Perform the following steps:

1. Create a new transformation.

2. Create a stream that generates...