Connect Salesforce Commerce to your Definite lakehouse in minutes.
Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.
Everything Salesforce Commerce exposes, modeled and queryable.
Extracts Salesforce Commerce Cloud (SFCC) data across product catalogs, categories, products and variants, prices, inventory lists and product inventory records, sites and locales, customers and addresses, orders, and order notes. This enables end-to-end commerce analysis including merchandising and catalog coverage, pricing and inventory reporting, site configuration and localization, customer segmentation, and order performance with items, payments, shipments, taxes, and notes.
Tables & streams
Master products with merchandising attributes, availability, and rich content used to analyze assortment coverage, product performance, and content completeness across sites and locales.
Sellable variants with variation attributes and relationships to master products, enabling size/color performance, option adoption, and variant-level availability and content analysis.
Per-product pricing (list/sale, min/max) across contexts; supports price compliance, markdown tracking, and competitive pricing analysis.
Inventory lists and per-product stock records indicating availability by list or location; used for out-of-stock rate, availability coverage, and backorder exposure reporting.
Product catalog containers with assignments and properties, enabling reporting by catalog and multi-catalog merchandising strategies.
Category taxonomy and metadata for browse/navigation analysis, supporting category performance, product coverage, and hierarchy-level KPIs.
Commerce storefronts with associated settings, enabling multi-site performance segmentation and cross-site merchandising comparison.
Locales enabled per site that drive language and currency contexts, supporting localized pricing, content coverage, and regional sales analysis.
Customer profiles and addresses for segmentation, geographic analysis, repeat purchase behavior, and cohort reporting.
Customer segments and their memberships used for VIP/wholesale targeting, eligibility, and group-based performance analytics.
Orders with headers, line items, payments, shipments, and taxes, powering GMV, AOV, conversion, fulfillment, and tax reporting with incremental windows.
Internal comments and annotations on orders that support audit trails, exception handling, and qualitative analysis of service issues.
Authenticates to Salesforce Commerce Cloud via OAuth 2.0 Client Credentials using your Client ID and Client Secret; the Order Notes stream uses a username/password-based OAuth flow with the same client credentials.
Requires a Salesforce Commerce account to connect.
Operational data, performance metrics, and business insights.
Three steps. One afternoon.
Authenticate Salesforce Commerce in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.
We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.
SQL, dashboards, or ask Fi in plain English. Your Salesforce Commerce data lives next to every other source — ready to join.
Build your own with the Definite SDK, or ask us — we add new connectors every week.
