Data Factory to Salesforce using JWT

Question

Data Factory to Salesforce using JWT

Ryan Abbey 0

Hi All,

We've been set with the requirement of authenticating with Salesforce via JWT. For the most part, this is set up and we can get an access token returned, however, how do we access Salesforce once we have the token? Does it have to be through a HTTP request? I can't see an option within the Salesforce linked service/dataset/copy/lookup to provide the token so fearing it all has to be done via HTTP, please someone save me!

Thanks

1 answer

Your answer

Answer 1

Amira Bedhiafi 33,071 Volunteer Moderator

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

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.

https://learn.microsoft.com/en-us/answers/questions/1289264/how-to-connect-salesforce-from-azure-data-factory

Ryan Abbey 0 Reputation points

2024-05-02T21:30:26.25+00:00

Is this different from "Salesforce OAuth 2.0"?

However, doesn't completely resolve my question... other than to imply we can't use the Salesforce linked service. As we're having to go this JWT approach, does that mean we will need to make all requests to Salesforce via API calls? Is there a better option?
Amira Bedhiafi 33,071 Reputation points Volunteer Moderator

2024-05-02T21:36:54.71+00:00

Your screenshot doesn't give information.

If I go back to re-analyze your question, once you have the access token, you're correct that you typically need to use HTTP requests to interact with Salesforce. This is because the access token serves as a bearer token in the HTTP Authorization header to authenticate your requests.

In ADF, when you want to use a connection that isn't directly supported through the ADF UI you will indeed need to manage the connection through HTTP requests.
Ryan Abbey 0 Reputation points

2024-05-02T22:54:18.5833333+00:00

The screenshot was from the Salesforce linked service configuration... the only option is to use "OAuth 2.0" - is that different from "Salesforce OAuth 2.0"?

Other than that, thanks for the response
Harishga 6,000 Reputation points Microsoft External Staff

2024-05-06T08:21:38.9433333+00:00

Hi Ryan Abbey
You will need to use a custom activity in Azure Data Factory to make API requests to Salesforce using the access token obtained via JWT authentication.

To do this, you can use the Web activity in Azure Data Factory to make HTTP requests to the Salesforce REST API. You can pass the access token obtained via JWT authentication in the Authorization header of the HTTP request.

Share via

Data Factory to Salesforce using JWT

1 answer

Your answer