If you need to create a dataset with data coming from a database, you can do it just by using a
Table Input step. If the
SELECT statement that retrieves the data doesn't need parameters, you simply write it in the Table Input setting window and proceed. However, most of the times you need flexible queries—queries that receive parameters. This recipe will show you how to pass parameters to a
SELECT statement in PDI.
Assume that you need to list all products in Steel Wheels for a given product line and scale.
Make sure you have access to the
Perform the following steps to connect to a database with parameters: