Parse online RSS feeds and save to Redshift

by

Posted on by

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

Try Withdata FileToDB, a desktop RSS to Redshift converter for Windows, MacOS, and Linux, Import online RSS feeds to Redshift, Easy and Fast.

Download Withdata 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. Preview data will be in Redshift table.

import online RSS feeds to Redshift - summary

5. Import RSS feed to Redshift.

import online RSS feeds to Redshift - import to Redshift

See importing results in Redshift table

import online RSS feeds to Redshift - view Redshift table

More about XML (RSS) to Redshift converter