Tables

The connector models the data in BigCommerce as a list of tables in a relational database that can be queried using standard SQL statements.

CData Tableau Connector for BigCommerce Tables


Name	Description
Brands	Gets the collection of brands.
Categories	Returns Product Categories.
CategoryTrees	Returns a list of category trees.
ChannelListings	Returns a list of all Channel Listings for a specific channel.
Channels	Manages and lists BigCommerce sales channels, supporting SELECT, INSERT, and UPDATE channel records.
Coupons	test Create,list,update or delete coupons.
Currencies	Returns data from Currencies table.
CustomerAddresses	Returns a list of Customer Addresses. Returns the addresses belonging to a customer.
Customers	Returns data from Customers table.
Locales	Retrieves a list of locales for the store.
OrderItems	Returns Items ordered for every order.
Orders	Returns data from the Orders table.
OrderShipments	Returns shipments and their corresponding orders.
PriceListRecords	Returns a collection of price list records.
PriceLists	Returns a collection of price records.
ProductBasicInformationLocales	Overrides the basic information for the product in a channel locale.
ProductCustomFieldsLocales	List of product custom fields with locale overrides.
ProductImageLocales	List of product images overrides.
ProductImages	Returns images registered for products.
ProductMetafields	Returns a list of Product Metafields.
ProductModifierOptionsLocales	List of product modifiers with locale overrides.
ProductOptions	Returns data from Products table.
ProductOptionValues	Returns data from Products table.
ProductPreOrderSettingsLocales	Overrides for the product in a channel locale.
ProductReviews	Returns reviews registered for products.
Products	Returns data from products table.
ProductSeoInformationLocales	Overrides for the product in a channel locale.
ProductStoreFrontLocales	Overrides for the product in a channel locale.
ProductUrlLocales	Overrides for the product in a channel locale.
ProductVariants	Returns data from Products table.
SharedProductModifierOptionsLocale	List of shared product modifiers with locale overrides.
ShippingMethods	Lists all shipping methods.
ShippingZones	Lists all shipping zones.