How to connect salesforce from azure data factory using OAUTH2

Madhavan Alagesan 11 Reputation points
2023-05-22T05:56:52.7766667+00:00

How to connect salesforce from azure data factory using OAUTH2.

SSO enabled at salesforce side and also used to connect salesforce from azure data factory using username and password. Now we are advised to use OAUTH in order to connect to salesforce from azure data factory but not seeing any option in linked services.

Any idea how to connect salesforce using OAUTH from ADF?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,652 questions
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
    2023-05-22T15:52:01.3733333+00:00

    Hi @Madhavan Alagesan ,

    Welcome to Microsoft Q&A forum and thanks for reaching out here.

    The current ADF salesforce connector only supports username and password properties for authentication.

    User's image

    Salesforce OAuth 2.0 is not supported in current ADF Salesforce connector.
    Here is an already logged feature request from other user in IDEAS forum. Please feel free to up-vote and comment on it to help increase the priority of it. Salesforce Connector in ADF - support OAuth2.0 To work around you may explore custom activity in ADF which will be helpful for scenarios where the service isn't supported natively. Please note this requires you to write your own custom code and call it from this activity.

    Hope this helps.


    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.