Parse online RSS feeds and save to Redshift without programming

by

Want to parse online RSS feeds and save to Redshift? Want to schedule and automate this importing task?

Using File To DB, a native GUI tool for Windows, MacOS, and Linux, you can import online RSS feeds to Redshift easily and fast.

Download FileToDB Download FileToDB

Import online RSS feeds to Redshift

Choose Redshift and logon.

convert online FEED file to Redshift  table - Choose Redshift and logon

Click “Wizard – 1 File To 1 Table” at task dialog.

convert online FEED file to Redshift  table - task window

Select “Source Type” with “Url”.

convert online FEED file to Redshift  table - select type

then show the wizard.

1. Input the RSS feeds URL, and download to XML file.

import online RSS feeds to Redshift  - download from RSS feeds URL to XML file

2. Open the saved XML file.

import online RSS feeds to Redshift  - open saved XML file

3. Config target Redshift table.

import online RSS feeds to Redshift  - config Redshift  table

You can create new Redshift table by XML struct, just a few mouse clicks.

import online RSS feeds to Redshift  - create Redshift  table

Select table and config fields.

import online RSS feeds to Redshift  - config Redshift  fields

4. Summary.

import online RSS feeds to Redshift  - summary

5. Import.

import online RSS feeds to Redshift  - import to Redshift

See importing results in Redshift table

import online RSS feeds to Redshift  - view  Redshift  table

Import RSS feed to Redshift in command line

Save “RSS feed to Redshift” session, then you can:

Set scheduled tasks for importing RSS feed to Redshift

You can schedule and automate this importing task by:

1) Save session and create .bat file.

2) Set scheduled task.

FAQ


More about FileToDBRSS feed to Redshift converter