RSS Feed

RSS reader ..

This step does not work in Pentaho Data Integration 9.5+

Steel Wheels have several JSON data sources. In this guided demonstration, you will create a simple workflow to extract the required reporting dataset.

In this guided demonstration, you will configure:

• RSS Input

• Filter Step

RSS (Rich Site Summary; originally RDF Site Summary; often called Really Simple Syndication) uses a family of standard web feed formats to publish frequently updated information: blog entries, news headlines, audio, video.

RSS

To create a new transformation

1. In Spoon, click File > New > Transformation:

Any one of these actions opens a new Transformation tab for you to begin designing your transformation.

• By clicking New, then Transformation

• By using the CTRL-N hot key

1. RSS Input

This step imports data from an RSS or Atom feed. RSS versions 0.91, 0.92, 1.0, 2.0, and Atom versions 0.3 and 1.0 are supported.

1. Drag the ‘RSS Input’ step onto the canvas.

2. Double-click on the step, and configure the following properties:

2. Filter rows

The Filter Rows step allows you to filter rows based on conditions and comparisons. Once this step is connected to a previous step (one or more and receiving input), you can click on the "", "=" and "" areas to construct a condition.

To enter an IN LIST operator, use a string value separated by semicolons. This also works on numeric values like integers. The list of values must be entered with a string type, e.g.: 2;3;7;8

1. Drag the ‘Filter rows’ step onto the canvas.

2. Double-click on the step, and configure the following properties:

3. Text File ouput

The Text file output step is used to export data to text file format. This is commonly used to generate Comma Separated Values (CSV files) that can be read by spreadsheet applications. It is also possible to generate fixed width files by setting lengths on the fields in the fields tab.

1. Drag the ‘Text File Output’ step onto the canvas.

2. Double-click on the step, and configure the following properties:

4. RUN

1. Click the Run button in the Canvas Toolbar

2. Click on the Text File Output step and Preview data.