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

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

Tables

Tables are tables that can be modified.

Views

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

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Using Bulk API

When UseBulkApi is set to True CData ODBC Driver for Shopify performs Shopify Bulk Operations. This option offers better performance when you need to select or export a lot of data from Shopify.