linked service issue in adf

Question

Hi team,

earlier i have linked service connection between salesforce and adf. microsoft given hint to upgrade salesforce(legacy) to new version using new linked service. i am trying to connect salesforce using Client ID& Client secret as Oauth 2.0 client credential authentication. But test connection was failed with below error.

Unable to establish connection to the Salesforce environment using provided client id and client secret, please verify the details. Error message: {"error":"invalid_grant","error_description":"no client credentials user enabled"}

as per salesforce team, they gave correct credentails of client ID & client secret. Please advice what is the issue with this linked service.

we are unable to found the root cause of this. Is there anything from azure side or salesforce side. Please advice

Thanks

Answer 1

Hi @Ram Babu

Thanks for the question and using MS Q&A platform.

It seems like you are having trouble creating a new linked service for Salesforce in Azure Data Factory. It seems that the client credentials you provided are not enabled. This error message is coming from Salesforce, so it's likely that the issue is on their side.

To resolve this issue, please follow the steps below:

• Make sure that you have created a connected app in Salesforce and obtained the client ID and client secret. If you have not done so, please follow the instructions in this Salesforce documentation to create a connected app.

• In Azure Data Factory, create a new linked service for Salesforce.
• Configure the service details, test the connection, and create the new linked service.Enter the client ID and client secret that you obtained from Salesforce in the corresponding fields and save the linked service and test the connection.

• The following properties are supported for the Salesforce linked service.

For more details, refer to Copy data from and to Salesforce using Azure Data Factory or Azure Synapse Analytics.

If you are still unable to establish a connection, please double-check that the client ID and client secret are correct and that the connected app has the necessary permissions to access the Salesforce environment. If you continue to experience issues, please let me know and I will do my best to assist you further.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Hi I am facing the same issue tried putting the correct client id and secret but still giving the same error