Salesforce Commerce Cloud Setup Guide link
Updated November 16, 2023
Follow our setup guide to connect Salesforce Commerce Cloud to Fivetran.
Prerequisiteslink
To connect Salesforce Commerce Cloud to Fivetran, you need:
A Salesforce Commerce Cloud account
Administrator permissions
The following authenticated access scopes for Salesforce Commerce Cloud's Admin API:
sfcc.products
sfcc.promotions
sfcc.customerlists
sfcc.catalogs
sfcc.gift-certificates
sfcc.source-codes
sfcc.orders
Setup instructionslink
Create API Clientlink
Log in to your Salesforce Commerce Cloud account.
On the left navigation menu, click API Client.
In the API Clients page, do the following:
i. Click Add API Client.
ii. Enter a Display Name for the API Client.
iii. Enter your Password and then Confirm Password for the new client. Make a note of the password (client secret). You will need it to configure Fivetran.
Go to the Organizations section and do the following:
i. Click Add.
ii. Select one or more organizations.
iii. Click Add.
Go to the Roles section and do the following:
i. Click Add.
ii. Find the Salesforce Commerce API category and select the Salesforce Commerce API.
iii. Click Add.
iv. Click the filter button.
v. Select an organization.
vi. Enter the names for each instance you want to access with the API client.
vii. Select each instance and click Add.
In the Allowed Scopes field, enter the authenticated access scopes provided in the Prerequisites section.
NOTE: You must enter each scope in a separate line.
In the Token Endpoint Auth Method drop-down menu, select client_secret_post.
In the Access Token Format drop-down menu, select JWT.
Click Save.
Make a note of the new API Client ID. You will need it to configure Fivetran.
Find Organization ID and Short Code link
- Go to Administration > Site Development > Salesforce Commerce API Settings.
- Make a note of the Organization ID and Short Code. You will need them to configure Fivetran.
Find Site IDlink
- Go to Administration > Sites > Manage Site.
- Make a note of the Site ID. You will need it to configure Fivetran.
Find Customer List IDlink
- Go to Administration > Sites > Customer Lists.
- Make a note of the Customer List ID. You will need it to configure Fivetran.
Finish Fivetran configuration link
- In the connector setup form, enter the Destination schema name of your choice.
- Enter the Client ID and Client Secret you created in Step 1.
- Enter your Organization ID and the Short Code you found in Step 2.
- Enter the Site ID you found in Step 3.
- Enter the Customer List ID you found in Step 4.
- Click Save & Test. Fivetran will take it from here and sync your Salesforce Commerce Cloud data.
Related articleslink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration