The Table input step is the main step to get data from a database. To run very simple queries, the use of this step is straightforward, as explained in this example:
- Create a new Transformation.
- From the Input category of steps, select and drag to the work area a Table input step.
- Double-click on the step.
- As Connection, you should see the pagila connection selected by default. If not, select it.
- Click on the Get SQL select statement... button. The Database Explorer window appears.
- Expand the tables list, select ...