Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,379 questions
[BUG]Error while connecting to salesforce marketing cloud via ADF linked service
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 38%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vanama, Sai Shantan
10
Reputation points
Hi, I am trying to create a linked service in Azure Data Factory for Sales Force Marketing Cloud. I have necessary clientid, client secret and subdomain(28 character key) to connect to salesforce marketing cloud. But when I test my connection on the new linked service I am seeing following error. The value of the property '' is invalid: 'The remote name could not be resolved: ''. We did required setting in the sales force as well, Could you please help me with this problem ASAP. Thank you
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache 20,356 Reputation points2024-01-29T18:03:07.8466667+00:00 Hello @Vanama, Sai Shantan Is it still failing to connect ? What about the "Salesforce" Connector,? Wanted to check if this connectivity if failing for all types? Similar issue: https://github.com/MicrosoftDocs/azure-docs/issues/119266 I have reached out to the internal ADF team to check on this issue!!! thanks for your patience!
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 70%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Serrano, Carlos 0 Reputation points2024-01-30T13:28:59.1666667+00:00 I'm having same problem with Marketing Cloud.
The Salesforce Sales cloud works well for me. Please advice about Marketing Cloud solution or possible workaround -
QuantumCache 20,356 Reputation points
2024-01-30T17:47:31.9333333+00:00 Hello all, Apologies for the inconvenience caused! There is an active issue going on with the Salesforce Connector and the team is looking into it. Please try to use the legacy connector if possible until the issue is resolved!!! Thanks for your understanding!!! @Serrano, Carlos, @Vanama, Sai Shantan Please create a support ticket if you have a Support plan, or do let us know if you need any help regarding the support ticket creation?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 88%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Amit Ambure 0 Reputation points2024-01-31T12:23:43.0166667+00:00 Hi Satish, Is the Legacy connector decommissioned already, I dont see Salesforce (Legacy) connector when i try to create new linked service. Please support.
-
QuantumCache 20,356 Reputation points
2024-01-31T15:03:18.9466667+00:00 @Amit Ambure Oh my apologies for confusion. Please use the temporary workaround to access the creation of legacy Salesforce connector
(Recommended) You can use Power Shell command to generate legacy Salesforce linked service and pipelines. https://learn.microsoft.com/en-us/powershell/module/az.datafactory/new-azdatafactorylinkedservice?view=azps-11.2.0
From the UI by adding "&feature.enableSalesforceV2=false" in the end of the ADF url.
Or you can also edit the json as shown by
-
QuantumCache 20,356 Reputation points
2024-01-31T15:06:13.26+00:00 @Amit Ambure Please send an email to [azcommunity@microsoft.com] with the below details, so that we can work offline on this matter. with onetime free support ticket. Your Email Subject : Attn Satish Boddu Your Email Body content must include the below: Thread URL: Link to this thread. Your Azure Subscription ID: <This is must to be provided to us>
-
QuantumCache 20,356 Reputation points
2024-01-31T15:14:45.72+00:00 Hello all,
Please send us an email and we will help with the onetime free support ticket. -
Serrano, Carlos 0 Reputation points
2024-01-31T21:46:21.8833333+00:00 For the traditional Salesforce in the Synapse context, you can comeback to the Legacy configuration editing the Link Service JSON directly.
In the new configuration type = SalesforceV2; while in the Legacy it is not included the V2{ "name": "SFDC_LINKSRV_ID", "type": "Microsoft.Synapse/workspaces/linkedservices", "properties": { "description": "...", "annotations": [], "type": "Salesforce", "typeProperties": { "environmentUrl": "https://<yourdomain>.my.salesforce.com", "username": "<your_user>", "apiVersion": "58.0", "encryptedCredential": "<You will need to update the pwd from the UI later>" }, "connectVia": { "referenceName": "AutoResolveIntegrationRuntime", "type": "IntegrationRuntimeReference" } } }To return to legacy Marketing Cloud connector you may n need to change Authentication Type from "Enhanced sts OAuth 2.0" to "OAuth 2.0":
-
Serrano, Carlos 0 Reputation points
2024-01-31T22:21:20.6333333+00:00 to be deleted
-
QuantumCache 20,356 Reputation points
2024-02-01T03:46:35.0266667+00:00 Hello Serrano, Carlos,@Amit Ambure @Vanama, Sai Shantan Please send an email to azcommunity@microsoft.com with the below details, so that we can work offline on this matter with a one time free support ticket. Your Email Subject : Attn Satish Boddu Your Email Body content must include the below: Thread URL: Link to this thread. Your Azure Subscription ID: <This is must to be provided to us>
-
Vanama, Sai Shantan 10 Reputation points
2024-02-01T13:43:02.84+00:00 Hi Sathish, Sent an email please look into this ASAP. THanks
-
QuantumCache 20,356 Reputation points
2024-02-01T17:37:46.5266667+00:00 Thank you! Please submit the Support ticket as soon as possible as per my Email instructions.
-
QuantumCache 20,356 Reputation points
2024-02-05T18:43:46.13+00:00 @Vanama, Sai Shantan
Serrano, Carlos,@Amit Ambure Hello all, The Salesforce Connector can be verified now, please confirm the same from your side. Thanks for your patience and cooperation in this matter.Similar Thread:
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 37%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SushilChoudhary 0 Reputation points2024-02-05T21:06:40.3733333+00:00 @Satish Boddu Salesforce connector is still failing for us with the same validation error. We are in Eastern US region. Can you please confirm that fix was published and available to all geographic locations ?
-
QuantumCache 20,356 Reputation points
2024-02-06T03:43:14.1533333+00:00 @SushilChoudhary Thanks for reporting the issue, please stay tuned on this thread. The fix might be rolled to all regions, thanks for your patience! We are monitoring the connector, will get back to you!
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 69%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gary Cogburn 0 Reputation points2024-02-08T18:41:54.4366667+00:00 What is the latest update on this? Has the fix been rolled to all regions? I ran into this issue today.
-
QuantumCache 20,356 Reputation points
2024-02-08T21:58:10.9433333+00:00 @Gary Cogburn Thanks for your patience on this issue, the technical team is still working on open issue. Please stay tuned for updates on this thread. If you have support plan, then please open a support ticket or send an email to us and we will work with you...!
Sign in to comment
Sign in to answer