RSS / Atom connection strings

CData ADO.NET Provider for RSS

RSS Feed

Url=http://news.google.com/news?pz=1&cf=all&hl=en&topic=n&output=rss

Items in a standards compliant RSS feed have a defined structure. Therefore the schema is expected to be as the standard defines. Use the hard coded value of "RSSFeed" as table name when querying, i e SELECT * FROM RSSFeed

Atom Feed

URL=http://someservice.com/atom-feed/

Items in a standards compliant Atom feed have a defined structure. Therefore the schema is expected to be as the standard defines. Use the hard coded value of "AtomFeed" as table name when querying, i e SELECT * FROM AtomFeed

Custom Feed

It is possible to use several feeds in a single connection. Each feed becomes a table.

Tables=MicrosoftFeed=http://blogs.technet.com/microsoft_blog/rss.xml,GoogleN ews=http://news.google.com/news?pz=1&cf=all&ned=us&hl=en&output=rss;

Sql command examples for the above connected feeds, SELECT * FROM MicrosoftFeed and SELECT * FROM GoogleNews

Caching data

URL=http://someservice.com/atom-feed/;Cache Location=C:\cache.db;Auto Cache=true;Offline=false;

To retrieve data from the cache, use table name + "#Cache" in sql query. Example for an Atom feed would be SELECT * FROM [AtomFeed#Cache]

Cached data only / Offline mode

URL=http://someservice.com/atom-feed/;Offline=true;Query Passthrough=true;

SELECT statements will always retrieve data from the cache. DELETE/UPDATE/INSERT statements is not allowed and will throw an exception.

Using an External Cache Provider

RSSBus drivers have the ability to cache data in a separate database such as SQL Server or MySQL instead of in a local file using the following syntax:

Cache Provider=Provider.Namespace;Cache Connection='Connection String to Cache Database';

Above is just an example to show how it works. It can be used both with "Auto Cache" and with "Cached Data Only / Offline Mode". Read more about RSSBus Cache in this article.

Connect through a firewall

URL=http://someservice.com/atom-feed/;User=myUsername;Password=myPassword;Firewall Server=fireWallIPorDNSname;Firewall User=fwUserName;Firewall Password=fwPassword;

Specify firewall port

URL=http://someservice.com/atom-feed/;User=myUsername;Password=myPassword;Firewall Server=fireWallIPorDNSname;Firewall User=fwUserName;Firewall Password=fwPassword;Firewall Port=1234;

Specify firewall type

URL=http://someservice.com/atom-feed/;User=myUsername;Password=myPassword;Firewall Server=fireWallIPorDNSname;Firewall User=fwUserName;Firewall Password=fwPassword;Firewall Type=SOCKS5;

Valid values are TUNNEL, SOCKS4 and SOCKS5. TUNNEL uses port 80 as default. SOCKS4/5 uses port 1080 as default.