Overview

This section shows the available API objects and provides more information on executing SQL to BigCommerce APIs.

Key Features

• The connector 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 connector.

Views

Pre-defined Tables and Views are available for read or write access to data from BigCommerce.

Stored Procedures

The connector 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.