Data Model
Overview
This section shows the available API objects and provides more information on executing SQL to BigCommerce APIs.
Key Features
- The component models BigCommerce categories, customers, and orders as relational tables and views, allowing you to write SQL to query BigCommerce data.
- Stored procedures allow you to execute operations to BigCommerce, including downloading and uploading objects.
- Live connectivity to these objects means any changes to your BigCommerce account are immediately reflected when using the component.
Views
Pre-defined Tables and Views are available for read or write access to data from BigCommerce.
Stored Procedures
The component allows you to list your BigCommerce objects and download/upload data to them via Stored Procedures.
System Tables
System Tables contains information about the objects and resources belonging to your database.