I am creating a app on azure and I am using azure data factory as a data integration tool, in my app I want to retrieve data from salesforce using the access token that I generated, the access token was generated by asking the system admin in my app to add his client Id and app secret of a connected app that he creates for my app and then my app uses server-to-server oauth to generate this access token.

However when I configure the salesforce linked service in azure data factory, it asks me for username, password and optional security token as mentioned in this link

salesforce configuration from microsoft docs.

Is the username and password the same as client Id and app secret used to generate the access token ? and if no, how can I use them to integrate with salesforce or there is no way but using another flow.

note: I don't know what is the flow that used username password with security token.

I just don't want to rewrite my code just for this, so any help would be appreciated.

UPDATE: Microsoft uses username/password flow to generate the access token with salesforce, I don't know why they didn't use another flow because OAuth says that this flow is not recommended for security reasons.

CodePudding user response：

In this case, the username and password should be the credentials of a Salesforce User which will be the one that the system will use to establish the context user. It is common to create an "Integration User" for this purpose in Salesforce.

So basically, the username and password should be the credentials of an active Salesforce User.