Time for action—exploring the sample database

Let's explore the sample database:

  1. Open the transformation you just created.
  2. Right-click the connection in the Database connections list and select Explore in the contextual menu. The Database explorer on connection window opens.
  3. Expand the Tables node of the tree and select CUSTOMERS. This is how the explorer looks:
    Time for action—exploring the sample database
  4. Click on the Open SQL for [CUSTOMERS] option.
  5. The following SQL editor window appears:
    Time for action—exploring the sample database
  6. Modify the text in the window so that you have the following:
    SELECT CUSTOMERNUMBER , CUSTOMERNAME , CITY , ...

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.