Read DB table

Workshop - Read DB

The warehouse manager at Steel Wheels requires a report highlighting the status of the ORDERS shipped.

In this guided Lab, you will:

• Connect to a database

• Modify SQL statement

• Configure the following steps:

Table Input

Calculator

Ranges

Sort Rows

Read from a database

---

English

Placeholder for Read DB table.

Second Tab

Create a new Transformation

Any one of these actions opens a new Transformation tab for you to begin designing your transformation.

• By clicking File > New > Transformation

• By using the CTRL-N hot key

1. Table input

Table input

This step is used to read information from a database, using a connection and SQL. Basic SQL statements can be generated automatically by clicking Get SQL select statement.

Connects to the ORDERS data table and extracts the required dataset where the status of the order is ‘Shipped’.

1. Start Pentaho Data Integration.

Windows - PowerShell

Set-Location C:\Pentaho\design-tools\data-integration
.\spoon.bat

Linux

cd
cd ~/Pentaho/design-tools/data-integration
./spoon.sh

1. Drag the Table Input step onto the canvas.

2. Open the Table Input properties dialog box. Ensure the following details are configured, as outlined below:

Table input

1. Preview and Click OK.

2. Calculator

3. Number range

4. Sort rows

5. Select values

6. RUN