Error while connecting to salesforce via ADF linked service

Question

Error while connecting to salesforce via ADF linked service

Imran Aslam 5

Hi, I am trying to create a linked service in Azure Data Factory for Sales Force. I have necessary clientid and client secret to connect to salesforce. But when I test my connection on the new linked service I am seeing following error on Environment url. Value should be in the form of https://<domainName>.my.salesforce.com Could you please help me with this problem ASAP. Thank you

1 answer

Your answer

Answer 1

Harishga 6,005 Microsoft External Staff

Hi @Imran Aslam
Welcome to Microsoft Q&A platform and thanks for posting your question here.

The error message indicates that the URL should be in the form of https://<domainName>.my.salesforce.com.

To resolve this issue, need to ensure that you have entered the correct domain name for your Salesforce instance. You can find this information in the Salesforce setup menu under Company Information.

Once you have confirmed your Salesforce domain name, update the environment URL in the linked service configuration to https://<domainName>.my.salesforce.com and test the connection again.

If the issue persists, you can refer to the official Azure documentation on creating a linked service for Salesforce. This documentation provides detailed information on how to create a linked service for Salesforce in Azure Data Factory.

Following up to see if the above answer was helpful. 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.

Harishga 6,005 Reputation points Microsoft External Staff

2024-02-06T04:31:41.4333333+00:00

Hi @Imran Aslam
Following up to see if the above answer was helpful. 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.
Imran Aslam 5 Reputation points

2024-02-06T09:22:36.71+00:00

Hi @Harishga Thank for your reply. I have URL for my test environment as per the below: I am using the same environment link in my Legacy SalesForce connector and everything work fine. But as you know recently Microsoft updated this ADF SalesForce connector and now we are facing this issue as its not taking any test environment URL as per below: any idea on this or its any bug from Mircosoft?? Thanks Imran
Harishga 6,005 Reputation points Microsoft External Staff

2024-02-06T11:28:51.6933333+00:00

Hi @Imran Aslam
We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.
Imran Aslam 5 Reputation points

2024-02-06T11:32:44.7533333+00:00

Thank you for your reply and waiting further your response. thanks Imran
Gary Cogburn 0 Reputation points

2024-02-08T18:36:22.69+00:00

Any updates on this question? Salesforce has the new format for test environment URLs that include .sandbox.my.salesforce.com
Harishga 6,005 Reputation points Microsoft External Staff

2024-02-09T11:52:48.0033333+00:00

Hi Gary Cogburn, Imran Aslam
It's possible that the error you're encountering is due to the sandbox environment not being supported. Would you be willing to try using a different environment to see if the error still occurs? This could help us determine the root cause of the issue and find a solution.
Imran Aslam 5 Reputation points

2024-02-09T11:58:02.74+00:00

Hi @Harishga I tried different format but it's not accepting any sandbox url address. Only accepting as domain name as per below:

Thanks Imran
Harishga 6,005 Reputation points Microsoft External Staff

2024-02-09T13:19:46.63+00:00

Gary Cogburn, Imran Aslam
My apologies for the confusion. I checked with my internal team, and at this moment, the sandbox does not accept it due to limitations. However, you can submit a feature request to the Azure Data Factory team via the Azure Data Factory feedback forum. The team regularly reviews the feedback and suggestions from the community to prioritize the features and improvements for future releases.

Share via

Error while connecting to salesforce via ADF linked service

1 answer

Your answer