O'Reilly logo

Pentaho Data Integration Cookbook Second Edition by María Carina Roldán, Adrián Sergio Pulvirenti, Alex Meadows

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 PUC. This recipe teaches you how to do it by using the Community Data Access (CDA) plugin.

You will experiment with 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 PUC.

Getting ready

In order to follow this recipe, you will need some experience with the Pentaho ...

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