The CData SSIS Components for WordPress models WordPress data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures.

Tables

The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, describe the schema exposed through the WordPress.com API. The available data depends on your account credentials and access level.

Commonly used tables include:

Table	Description
Categories	Create, update, list, and delete the Categories for the WordPressOnline website.
Comments	Query the comments data.
Media	Get a list of items in the media library.
NavigationMenus	List, update, create, and delete NavigationMenus of the WordPressOnline website.
Posts	Create, update, list, and delete the Posts for the WordPressOnline website.
PublicizeConnection	List all publicizeconnections that the current user has set up and update and delete specified publicize connection.
Tags	Create, update, list, and delete the Tags for the WordPressOnline website.
TaxonomyTerms	Create, update, list, and delete the Taxonomy Terms for the WordPressOnline website.
Users	List the Users of the WordPressOnline website.
CommentLikes	Get the likes information for a comment.
CommentLikeStatus	Get the like status for a comment of the WordPressOnline website.
Follows	List a site's followers in reverse chronological order.
Insights	Query the list of stats/metrics/insights that the current user has access to.
PostTypes	List the PostTypes for the WordPressOnline website.
RecentComments	Get a list of recent comments on a post.
SharingButtons	List and update all the sharing buttons for a site.
SitePostViews	Query the SitePostViews in Wordpress.
SitePublicizeConnection	Query a list of publicize connections that are associated with the specified site.
SiteStats	Query the SiteStats in Wordpress.
SiteStatsSummary	Query the SiteStatsSummary in Wordpress.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including creating and uploading media and managing OAuth tokens.