Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: got through the second portion and to the end

...

  • Incremental loading is only supported for Creation Date, not Modified Date
  • A large volume of data may cause low performance
  • In preview mode, the connector does not support generating the detailed data preview because of time restrictions on fetching the data preview.

An Inventory List with no product is still inserted as one record, the properties belong to the Product Inventory List and will be null.

About Incremental Data Loading  

...

Numbered Headings
start-numbering-with1
start-numbering-ath5
Navigate to the Salesforce Cloud Commerce UI and login. For example, Account Manager UI.


Select API Client.

Select Add API Client.

Type values for:
    • Display Name
    • Password
    • Confirm Password
Select Access Control to enable it.
In the Organizations area, select your organization.
In the Roles area, select Add.
Select the appropriate role. For example, Sandbox API User.

Select Add.
After the role is added, select all the sandboxes associated with it.

Select Add.
Scroll down to Open ID Connect.
Add Default Scopes:
    • mail
    • roles
    • tenantFilter
    • profile
Add Redirect URI. For example:

https://admin.us01.dx.commercecloud.salesforce.com/oauth2-redirect.html

 Scroll totheToken Endpoint Auth Methodsection.
Select client_secret_basic.
Select JWT for Access Token Format.

Select Save.

You are taken back to theAPI Clientscreen.



Write down or save in a secure location the API Client ID and Password.

These are used as Authentication credentials to integrate with your SFCC instance.

...


Enable the API Client to Access the Data API

These steps enable your API Client to

...

1. Go to Business Manager UI (be used with the Data API and Salesforce B2C Commerce Cloud connector.

Numbered Headings
start-numbering-ath5
Open Business Manager. For example:

https://{YOUR_INSTANCE_URL}.commercecloud.salesforce.com/on/demandware.store/Sites-Site/default/ViewApplication-DisplayWelcomePage

...

...

Select Administration.
Select Open Commerce API Settings.

Image Modified

...


Select Type as Data.

Image Modified

...

The configuration for Data API

...

appears.

Type or copy the following into the text field:
Code Block
{ "_v": "21.6", "clients": [ { "client_id": "your_api_client_id", "resources": [ { "methods": [ "get", "post", "put", "patch", "delete" ], "read_attributes": "(**)", "write_attributes": "(**)", "resource_id": "/**" } ] } ] }
For Select Context choose Global (organization-wide).

Image Modified

...

Select Save.
Wait for at least 3 minutes

...

.

Your API Client is ready to be used with Data

...

API and Salesforce B2C Commerce Cloud connector.

...

true
Page properties
hidden

Use the TD Console to Create Your Connection

...

Numbered Headings
start-numbering-with1
start-numbering-ath5
Open TD Console.
Navigate to Integrations Hub  Catalog.
Search for and select Salesforce B2C Commerce Cloud.

Choose Create Authentication.

The following dialog opens:

Enter


Type or select the required information:
ParameterDescription

API Client ID

Key which you got after create your application on Commerce Cloud's Account Manager Application.

API Client Password

The password for your API Client when you create on Commerce Cloud's Account Manager Application.

Base URI

URL for accessing your Business Manager Application. Example value https://xxxx.commercecloud.salesforce.com/

Enter
Type a name for your connection.

Select Continue.



Transfer Your Data to Treasure Data

...

Numbered Headings
start-numbering-with1
start-numbering-ath5

After creating the authenticated connection, you are automatically taken to Authentications.


Search for the connection you created. 

Select New Source.
Type a name for your Source in the Data Transfer field.

Select Next.

The Source Table dialog opens.

Edit the following parameters:

Parameters DescriptionDescription of Data Types
Data Type
*
The data objects that you want to ingest into Treasure Data:

Customers From List

The customer info from a specific customer list


Products

Product info of Salesforce Commerce Cloud account


Categories and Product Assignments

Product category info and products belong to each category


Inventory Lists and Product Inventories

Inventory list and product in each inventory list


StoresStore info, location, and inventory belongs to stores

CatalogsProduct catalog info and count of products for each catalog 
Customer List IDThe customer List ID you want to import customer information from
Incremental loadingSelect to ingest only newly created data since the previous ingestion.
Created FromThe specific time you would like to ingest the data (YYYYMMDDHH format).
Select Next.

The Data Settings page can be modified for your needs or you can skip the page.

Optionally, edit the following parameters:


Select Next.

*All Available Data Types

...

Target

...

Description

...

Customers From List

...

The customer info from a specific customer list

...

Products

...

Product info of Salesforce Commerce Cloud account

...

Categories and Product Assignments

...

Product category info and products belong to each category

...

Inventory Lists and Product Inventories

...

Inventory list and product in each inventory list

...

...

Data Preview 

Limitation 

...


Numbered Headings

Excerpt Include
Data Preview
Data Preview
nopaneltrue

...