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

  • Authentication

    URL=http://myservice/rss/;user=myUser;Password=myPassword;
  • 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.

Problems connecting?
Get answer in the RSS / Atom Q & A forum

Q&Aask question »

Articlesread all »

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.