Skip to content

connector-troubleshoot-salesforce.md

Latest commit

 

History

History
72 lines (52 loc) · 4.61 KB

connector-troubleshoot-salesforce.md

File metadata and controls

72 lines (52 loc) · 4.61 KB
title Troubleshoot the Salesforce and Salesforce Service Cloud connectors
titleSuffix Azure Data Factory & Azure Synapse
description Learn how to troubleshoot issues with the Salesforce and Salesforce Service Cloud connectors in Azure Data Factory and Azure Synapse Analytics.
author jianleishen
ms.subservice data-movement
ms.topic troubleshooting
ms.date 03/04/2024
ms.author jianleishen
ms.custom
has-adal-ref
synapse
sfi-image-nochange

Troubleshoot the Salesforce and Salesforce Service Cloud connectors in Azure Data Factory and Azure Synapse

[!INCLUDEappliesto-adf-asa-md]

This article provides suggestions to troubleshoot common problems with the Salesforce and Salesforce Service Cloud connectors in Azure Data Factory and Azure Synapse.

Error code: SalesforceOauth2ClientCredentialFailure

  • Cause: You encounter this error code as you don't complete the Salesforce Connected App configuration.

  • Recommendation:
    To configure your Salesforce Connected App, follow these steps:

    1. Create your connected app, and complete its basic information and OAuth settings for the connected app.

      1. Configure the Connected App Name, API Name and Contact Email.
      2. Select Enable OAuth Settings.
      3. Callback url can be random as Client Credential Flow don't need callback, for example: https://login.salesforce.com/services/oauth2/callback
      4. Setup OAuth access token scope, it's better to set up "Full access" for Azure Data Factory in case of permission issue.
        If you want to keep the mini scope, at least the "Manage user data via APIs (api)" should be added.
        If you don't set proper scope, you may get following similar message like: Unauthorized, This session is not valid for use with the REST API
      5. Select Enable Client Credentials Flow.

      :::image type="content" source="media/connector-salesforce/configure-basic-information.png" alt-text="Screenshot of configuring basic information for the Salesforce connector app.":::

    2. Get Client ID and Secret through Manage Consumer Details.

      :::image type="content" source="media/connector-salesforce/manage-consumer-details.png" alt-text="Screenshot of the manage consumer details.":::

    3. Copy the client ID and secret to a txt file for Azure Data Factory linked service.

      :::image type="content" source="media/connector-salesforce/client-id-secret.png" alt-text="Screenshot of the Client ID and Secret.":::

    4. Create a user who has the API Only User permission.

      1. Set up a permission set which only has API only permission. :::image type="content" source="media/connector-salesforce/set-up-a-permission.png" alt-text="Screenshot of setting system permissions.":::
      2. Specify the API Enabled and Api Only User. :::image type="content" source="media/connector-salesforce/system-permissions.png" alt-text="Screenshot of the system permissions.":::

    5. Create a new user and link the permission set in the user detail page: Permission Set Assignments. :::image type="content" source="media/connector-salesforce/permission-set-assignments.png" alt-text="Screenshot of the permission set assignments.":::

    6. From the connected app detail page, click Manage, click Edit Policies. For Run As, select an execution user who has the API Only User permission. For Timeout Value, you can select a proper value or remain default None.

      :::image type="content" source="media/connector-salesforce/connected-app-detail.png" alt-text="Screenshot of the connected app detail.":::

      :::image type="content" source="media/connector-salesforce/edit-policies.png" alt-text="Screenshot of the edit policies.":::

Related content

For more troubleshooting help, try these resources: