O'Reilly logo

Pentaho Data Integration Beginner's Guide by María Carina Roldán

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

Time for action – exploring the sample database

Let's explore the sample database:

  1. Open the transformation you just created.
  2. Right-click on the connection in the Database connections list and select Explore in the contextual menu. The database explorer shows up.
  3. Expand the Tables node of the tree. This is how the explorer looks:
    Time for action – exploring the sample database
  4. Right-click on the CUSTOMERS table and select View SQL. The following SQL editor window appears:
    Time for action – exploring the sample database
  5. Modify the text in there so you have this:
    SELECT 
      CUSTOMERNUMBER
    , CUSTOMERNAME
    , CITY
    , COUNTRY
     FROM CUSTOMERS
  6. Click on Execute. You ...

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