Loading
Get Started with B2C Commerce
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Ingest B2C Commerce Domain Data Using the Apache Iceberg Connector

            You are here:

            1. Salesforce Help
            2. Docs
            3. B2C Commerce for Merchandisers and Administrators

            Ingest B2C Commerce Domain Data Using the Apache Iceberg Connector

            Set up the Apache Iceberg File Federation connection to ingest B2C Commerce domain data—including products, orders, customer profiles, and custom attributes for products and customer profiles—into Data 360.

            Required Editions

            Available in: B2C Commerce
            User Permissions Needed
            To create a connection: System Admin profile or Data Cloud Architect permission set

            Before you set up the Apache Iceberg connection, complete these prerequisite steps:

            Data is automatically available only from live production instances. For more information about non-production instances, see Using Non-Production B2C Commerce Environments with Data 360.

            The Apache Iceberg File Federation connector enables you to ingest all B2C Commerce domain data into Data 360. This includes:

            • Products (goods products, master products, bundles)
            • Product catalogs and categories
            • Sales orders and order details
            • Customer profiles
            • Custom attributes for products and customer profiles

            After you set up the connection, you must manually map the source objects to Data Model Objects (DMOs). For information about the available source objects and their mappings, see B2C Commerce Domain Data Mappings. For detailed information about the source table schemas, see B2C Commerce Lakehouse Schema Reference.

            1. In Data 360, click Setup, and select Data Cloud Setup.
            2. Under External Integrations, select Other Connectors.
            3. Click New.
            4. On the Source tab, select Apache Iceberg File Federation and click Next.
            5. Enter a connection name and connection API name.
            6. Enter the authentication details.

              B2C Commerce data store's REST catalog supports storage credential vending, so select Storage Type as CATALOG_PROVIDED.

              For REST Catalog, in the Client Access Token field, enter the Base64 encoded value of {tenant_id}:{account_manager_client_id}:{account_manager_client_secret}.

              To obtain these values:

              • tenant_id: The tenant ID is part of your B2C Commerce organization ID. The organization ID has the format f_ecom_{tenant_id}. For example, if your organization ID is f_ecom_zzzz_001, the tenant ID is zzzz_001.
              • account_manager_client_id: The Client ID generated when you create an API client in Account Manager.
              • account_manager_client_secret: The password you set when creating the API client in Account Manager.

              The Account Manager client must have the Salesforce Commerce API role. When you assign this role, use the instance filter to find and add your production B2C Commerce instance.

              For information about creating an Account Manager API client, see Add an API Client in B2C Commerce. When performing the steps in that topic to set up an API client for the Iceberg connector, perform step 9 (assigning the Salesforce Commerce API role with instance filters) because it is required for the Iceberg connector. Do not perform steps 10 and 11 (Default Scopes and OpenID Connect settings) because they don't apply to this connector.

            7. Enter the Connection Details.

              For Catalog Endpoint, enter the Data Cloud accessible HTTPS URL of the Apache Iceberg REST catalog:

              • Production: https://iceberg-catalog.analytics.commercecloud.salesforce.com
              • Non-production: https://iceberg-catalog.stg.analytics.commercecloud.salesforce.com

              Leave the optional Warehouse field blank.

            8. To review your configuration, click Test Connection.
            9. Click Save.
              After the connector details are accepted, the connection is created and listed under Connectors. You can now create data streams and map your B2C Commerce data to DMOs.

            After setting up the connection, create data streams for the B2C Commerce objects you want to ingest. For information about creating data streams and mapping source objects to DMOs, see Create an Apache Iceberg File Federation Data Stream.

            • B2C Commerce Domain Data Mappings
              When ingesting B2C Commerce domain data using the Apache Iceberg connector, you must manually map these source objects to Data Model Objects (DMOs) in Data 360.
            • B2C Commerce Lakehouse Schema Reference
              The B2C Commerce Data Lakehouse stores product catalog, customer, and sales order data in entity tables that use the ccdl_ prefix.

            See Also

             
            Loading
            Salesforce Help | Article