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 – getting data about shipped orders

Let's continue working with the sample data.

  1. Create a new transformation.
  2. Select the Design view.
  3. Expand the Input category of steps and drag a Table input step to the canvas. Then, double-click on the step.
  4. As Connection, you should see the sampledata connection selected by default. If not, please select it.
  5. Click on the Get SQL select statement... button. The database explorer window appears.
  6. Expand the tables list, select ORDERS, and click on OK.
  7. PDI asks you if you want to include the field names in the SQL. Answer Yes.
  8. The SQL box type gets filled with a SELECT SQL statement:
    SELECT
      ORDERNUMBER
    , ORDERDATE
    , REQUIREDDATE
    , SHIPPEDDATE
    , STATUS
    , COMMENTS
    , CUSTOMERNUMBER
    FROM ORDERS
  9. At the end of ...

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