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 table

In order to search for data in a database, Kettle offers several ways of accessing the data. The simplest situation is the one in which you need to get one or more columns from a single database table. In this recipe, you will learn how to do this by using the Database lookup step. We will work with the Steel Wheels sample data. If you wish to become more familiar with the sample dataset or need to learn how to configure database access, refer to Chapter 1, Working with Databases. Suppose that you want to look for products that match a given search term, and whose prices are below a given value, this recipe shows you how to do this.

Getting ready

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

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