Processing RSS in ODI

We can process RSS using ODI XML technology which has a driver whose file specification includes support for filesystem, URL and ftp. Use a url like below to define an XML dataserver.

jdbc:snps:xml?f=http://feeds.bbci.co.uk/news/rss.xml&s=BBC&dtd=d:/bbcrss.dtd

When you use the selective reverse engineer you can see the available datastores in the model generated.;

To access the URL from within ODI studio we might need to define web proxy and URL from Studio UI open Tools->Preferences Web Browser,  Proxy tab, & define the proxy.

Once reverse engineered you can view the model in designer and see the objects reversed. Unlike file based XML, the HTTP based ones are read only, but let you easily integrate XML oriented datastreams such as RSS very easily.

Advertisements