Establishing a Connection
The Lyftron Provider for RSS supports connecting to RSS and Atom feeds, as well as feeds with custom extensions. To connect to a feed, set the URI property. The provider also supports accessing secure feeds. A variety of authentication mechanisms are supported. See the connection properties for details.
Creating a Schema
You can use the GenerateSchemaFiles property to generate table definitions for RSS and ATOM feeds. This property can be used to generate schemas when you connect or when you execute a query. Set the URI to the feed url and the Format is the format of the feed RSS or ATOM. Set the Location connection property to the folder where you want the resulting schemas to be placed.
EXEC CreateSchema TableName='MyFeed', URL='http://myservice/myfeed/'
Add a ColumnTable columns are defined in the rsb:info block, which defines the column names, data types, element path. To add a new column to a table, you can simply append an attribute to rsb:info. You will need to set the following values:
- name: the desired column name. The column names do not need to match the element names from the feed; you will define this mapping in the next step.
- xs:type: an appropriate data type. The provider accepts the following data types: int, double, datetime, time, string, long, boolean, and decimal.
- key: whether this column is a primary key (a unique identifier that can be used to select this record and this record only).
- other:xPath: path to the element relative to the channel
Remove a ColumnDeleting an attr element from rsb:info will remove the column from the resource. This means that your table will not list the column. Note that it is important to delete the entire XML element for the column that you want to remove.
Editing a ColumnYou can rename a column by changing the name attribute of the attr. You can also edit a column's data type by changing the xs:type attribute to one of the following support types: