The CData SSIS Components for WordPress models WordPress data as an easy-to-use SQL database with tables, views, and stored procedures.

The component exposes two schemas:

• See WordPress Data Model for the available entities in the WordPress API.
• See WordPressOnline Data Model for the available entities in the WordPress Online API.

Stored Procedures

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

Using Query Processing

The component offloads as much of the SELECT statement processing as possible to the WordPress APIs and then processes the rest of the query within the component. For details about specific API limitations and requirements, see the WordPress Data Model and WordPressOnline Data Model sections.