In this post I will share with you how I transformed OraNA from an aggregator powered by Wordpress to a powerful, robust and easy to manage feed aggregator powered by Google Reader and FeedBurner.
I will take you through the three easy steps that I followed to set up OraNA. You can follow the same steps to set up your own aggregator if you wish.
I will also share with you the features that make OraNA unique, like the ability for anyone to contribute feed items, the aggregation of feeds for websites that do not have feeds (like Jonathan Lewis’s web site), and the option to “plug-n-play” the aggregator on any website or blog, with just one line of code.
Here is how I (re)created OraNA:
1 - Set up the feeds in Google Reader:
Recently Google Reader introduced the ability to share labels. Using this feature, you can subscribe to many feeds, label them with a specific label, and then share that label. A shared label has one unique feed URL. subscribing to that one shared label feed is the same as subscribing to every feed with the same label.
So, I subscribed to all the feeds that I wanted to include in OraNA, labeled them “oracle” and then turned on sharing on that label.
2 - Created the OraNA feed in FeedBurner:
Next, using FeedBurner, I burned the feed produced in the first step above. The result was the final OraNA feed: http://feeds.feedburner.com/orana. This feed, by itself and when viewed in a browser, looks and acts like a totally functional feed aggregator, however, I wanted to publish the feed’s content on its own customized HTML web page. No problem. FeedBurner has the “BuzzBoost” service that republishes your burned feed’s content as go-anywhere HTML. I activated BuzzBoost. The result was a snippet of JavaScript that I pasted into the OraNA web page.
3 - Added the sources to BlogRolling:
I wanted to display the feeds that OraNA aggregates. To do that, I exported the feeds in Google Reader to an OPML file, then imported the file into BlogRolling. In BlogRolling, I edited the links so that they pointed to the source website instead of the feed. Then I copied and pasted the BlogRolling JavaScript code into the OraNA web page.
That’s it.
Now, when I want to add a new feed to OraNA, all what I need to do is to subscribe to the feed I want to add in Google Reader, label it “oracle” and add it to the blogroll in BlogRolling.
OraNA features:
OraNA aggregates the feed for http://del.icio.us/OracleNews. I created the OracleNews del.icio.us account specifically for OraNA. If you have a del.icio.us account, links that you tag for:oraclenews will appear in OraNA. I will have to approve the links first before publishing them to OraNA (i.e. save them to OracleNews).
OraNA has a Firefox extension, get it here.
OraNA aggregates ALL the blogs listed in blogs.oracle.com, including ALL Oracle executive blogs, ALL Oracle employee blogs and ALL Oracle non-employee blogs. I will make sure that new blogs added to blogs.oracle.com, will also be aggregated by OraNA.
OraNA aggregates ALL the feeds listed in http://www.oracle.com/rss/, except AskTom and the forums. Let me know if you want AskTom - New Questions feed added.
New feed content normally appears on OraNA within few minutes from publishing. Updated feed content will also reappear on OraNA.
OraNA includes Jonathan Lewis’ feeds for jlcomp.demon.co.uk/faq/ind_faq.html and jlcomp.demon.co.uk/ind_misc.html. I know, these pages do not have an RSS feed, but with the help of feed43.com or Ponyfish, everything is possible :). Here is the feed for the FAQ page, and here is the feed for the articles page.
Moreover, it is very easy to put OraNA on your website or blog. See how it looks on my blog. All what you need is this JavaScript code:
And to list the sources, add this code:
Happy news reading
Important Note: If you are already subscribed to the OraNA feed, make sure you use http://feeds.feedburner.com/orana to continue receiving updates.
Related articles:
- How OraNA.info Aggregates Blogs.Oracle.com
- Google Reveals Documents from the Independent Oracle Users Group (IOUG)
- XML Goodness in SQL - Part 1
Tagged aggregator, blog, feed, Google, news | Comments Closed | Trackbacks Closed

















Great Work Eddie!
April 20th, 2006, at 3:19 am #Your combination of Web/Oracle Skills is very usefull for the oracle community
Karl
Thanks Karl. You’ve done a good job on your blog too. I have (re)added it to OraNA.
April 20th, 2006, at 9:01 am #Thanks!
April 20th, 2006, at 11:02 pm #Karl
great post Eddie,
August 6th, 2006, at 11:58 pm #many thanks for the ideas regarding pages not having a RSS feed.
regards,
eric
does anyone know how to link wordpress to an ori database??
September 24th, 2006, at 8:13 am #Very informative, thank you very much. I’m hoping to get something similar setup once I get a decent enough site happening.
October 30th, 2006, at 9:39 pm #