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

Generating files from the PUC with PDI and the CDA plugin

As you know, PDI allows you to generate Excel, CSV, and XML files and starting with the latest version, also JSON files. You do it with a transformation that has to be executed from Spoon or the command line. There is a quicker way to generate those kinds of files in an interactive fashion from the Pentaho User Console (PUC). This recipe teaches you how to do it by using the Community Data Access (CDA) plugin.

You will experiment the CDA Editor and the CDA Previewer for querying the current weather conditions in a given city. Then, you will learn how to export the results to different formats. You will do that from the PUC.

Getting ready

In order to follow this recipe, you will need some ...

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