Connect to RSS Feeds in DBArtisan

The CData ODBC Driver for RSS seamlessly integrates RSS feeds into database management tools like DBArtisan by enabling you to access RSS feeds as a database. This article shows how to create an data source for RSS in DBArtisan and execute queries. You can then edit data visually and execute standard SQL.

Integrate RSS Feeds into DBArtisan Projects

If you have not already, first specify connection properties in an ODBC DSN (data source name). This is the last step of the driver installation. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.

You can connect to RSS and Atom feeds, as well as feeds with custom extensions. To connect to a feed, set the URL property. You can also access secure feeds. A variety of authentication mechanisms are supported. See the help documentation for details.

You can then follow the steps below to register RSS feeds as a database instance in your project:

1. In DBArtisan, click Data Source -> Register Datasource.
2. Select Generic ODBC.
3. Enter a name for the data source and select the DSN.
4. Finish the wizard to connect to RSS feeds. RSS entities are displayed in the Datasource Explorer.

You can now work with RSS feeds as you work with any other database. See the driver help documentation for more information on the queries supported by the RSS API.