Generating an RSS Feed

RSS feeds allow for a quick means of staying current on many different media types (blogs, news sites, alert notifications, and so on). By utilizing the data integration capabilities of Kettle, we can create our own customized RSS feeds that can then be consumed by any tool that can read the specialized RSS feed format, such as Feedly (http://www.feedly.com) or NewsBlur (http://www.newsblur.com).

Getting ready

You must have a database of books with the structure shown in Appendix A, Data Structures.

How to do it...

Perform the following steps:

  1. Create a new transformation.
  2. Under the Input section, bring over a Table Input step.
  3. Open the Table Input step and select the books database connection. For the SQL statement, add the following: ...

Get Pentaho Data Integration Cookbook Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial