The CData ODBC Driver for Shopify models the Shopify API as relational views, and stored procedures.

To use REST Data Model, simply set Schema to REST.

Tables

Tables are tables that can be modified, such as Orders, Products.

Views

Views are tables that cannot be modified, such as Events, Patouts and Reports. Typically, read-only model data is shown as views.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. Use these interfaces to search, update, and modify information in the data source.