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:

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.

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.

Go to Administration > Sites > Customer Lists.
Make a note of the Customer List ID. You will need it to configure Fivetran.

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.