Prerequisites

To connect Salesforce Commerce Cloud to Fivetran, you need:

• A Salesforce Commerce Cloud account
• Administrator permissions
• Access to the following authorization scopes for Salesforce Commerce Cloud's Admin API:
  • sfcc.products
  • sfcc.promotions
  • sfcc.customerlists
  • sfcc.catalogs
  • sfcc.gift-certificates
  • sfcc.source-codes
  • sfcc.orders
• Separate API client applications to sync tables supported through Salesforce Commerce Cloud API and Open Commerce API (OCAPI) respectively.

Setup Instructions

1. Log in to your Salesforce Commerce Cloud account.
2. On the left navigation menu, click API Client.
3. In the API Clients page, do the following:
   1. Click Add API Client.
   2. Enter a Display Name for the API Client.
   3. 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.
4. Go to the Organizations section and do the following:
   1. Click Add.
   2. Select one or more organizations.
   3. Click Add.
5. Go to the Roles section and do the following:
   1. Click Add.
   2. Find the Salesforce Commerce API category and select the Salesforce Commerce API.
   3. Click Add.
   4. Click the filter button.
   5. Select an organization.
   6. Enter the name for each instance you want to access with the API client.
   7. Select each instance and click Add.
6. In the Allowed Scopes field, enter the authenticated access scopes provided in the Prerequisites section.
   1. NOTE: You must enter each scope in a separate line.
7. In the Token Endpoint Auth Method drop-down menu, select client_secret_post.
8. In the Access Token Format drop-down menu, select JWT.
9. Click Save.
10. Make a note of the new API Client ID. You will need it to configure Fivetran.
11. Go to Administration > Site Development > Salesforce Commerce API Settings.
12. Make a note of the Organization ID and Short Code. You will need them to configure Fivetran.
13. Go to Administration > Sites > Manage Sites.
14. Make a note of the Site ID. You will need it to configure Fivetran.
15. Go to Administration > Sites > Customer Lists.
16. Make a note of the Customer List ID. You will need it to configure Fivetran.
17. OPTIONAL: Create Open Commerce API client (You must create a new API client to sync tables supported through Open Commerce API (OCAPI). A client ID used for Salesforce Commerce APIs (SCAPI) cannot be used for making OCAPI calls.)
    1. On the left navigation menu, click API Client.
    2. In the API Clients page, do the following:
       1. Click Add API Client.
       2. Enter a Display Name for the API Client.
       3. Enter your Password and then Confirm Password for the new client.
       4. Make a note of the password (client secret). You will need it to configure Fivetran.
    3. Go to the Organizations section and do the following:
       1. Click Add.
       2. Select one or more organizations.
       3. Click Add.
    4. Skip the Roles section.
    5. In the Token Endpoint Auth Method drop-down menu, select client_secret_post.
    6. In the Access Token Format drop-down menu, select JWT.
    7. Click Save.
    8. Make a note of the new API Client ID. You will need it to configure Fivetran.
    9. Go to Administration > Site Development > Open Commerce API Settings.
    10. In the Select Type drop-down menu, select Data.
    11. In the Select Context drop-down menu, select Global.
    12. In the editor, add the code to assign permissions to your API client to access to your required OCAPI endpoints.
    13. Go to Administration > Sites > Manage Sites.
    14. Go to Manage Business Manager site.
    15. Go to Hostnames tab and Make a note of Hostname. You will need it to configure Fivetran.
    16. Go to Administration > Site Development > Custom Object Types.
    17. Make a note of the object types you need to sync through Fivetran.
18. Go back to Fivetran
    1. In the connector setup form, enter the Destination schema name of your choice.
    2. Enter the Client ID and Client Secret you created.
    3. Enter your Organization ID and the Short Code you found.
    4. Enter the Site ID you found.
    5. Enter the Customer List ID you found.
    6. To sync Open commerce API endpoints, set the Sync OCAPI Endpoints toggle to ON, and specify the following:
       1. Enter the OCAPI Client ID and OCAPI Client Secret you created.
       2. Enter the OCAPI Hostname you found.
       3. (Optional) Enter a comma-separated List of Custom Object Types you found.
19. Click Save & Test. Fivetran will take it from here and sync your Salesforce Commerce Cloud data.