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:

   SELECT
     id_title
   , title
   , price
   , genre
   , CONCAT(firstname, ' ', lastname) AS author_name
   , b.create_date AS publish_date
   FROM books b
   JOIN authors a ON b.id_author = a.id_author

4. Click on OK and exit the Table Input step.

5. From the Transformation...