How to connect salesforce from azure data factory using OAUTH2

Question

How to connect salesforce from azure data factory using OAUTH2

Madhavan Alagesan 11

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?

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-05-23T23:16:46.7566667+00:00

@Madhavan Alagesan Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-05-30T21:41:38.78+00:00

@Madhavan Alagesan We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

1 answer

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-05-23T23:16:46.7566667+00:00

@Madhavan Alagesan Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-05-30T21:41:38.78+00:00

@Madhavan Alagesan We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

Answer 1

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.

Share via

How to connect salesforce from azure data factory using OAUTH2

1 answer

Your answer