O'Reilly logo

Pentaho Data Integration 4 Cookbook by María Carina Roldán, Adrián Sergio Pulvirenti

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

Looking for values over an intranet or Internet

This example is similar to the previous one, with the difference being that you have to lookup the museum opening hours on a website instead of a web server. In this case, you will use the HTTP Client step.

Getting ready

You must have a database with the museum structure shown in the Appendix, Data Structures and a web page that provides the museum opening hours. The recipe uses an ASP page named hours.asp, but you can use the language of your preference. The page receives the museum's identification and returns a string with the schedule. You can download a sample web page from the book's website.

How to do it...

Carry out the following steps:

  1. Create a new transformation.
  2. Drop a Table input step into ...

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