Error when trying to copy from Salesforce to an Azure table using Data Factory

Adalberto García Espinosa 86 Reputation points
2020-11-27T13:34:40.347+00:00

Hi,

I'm trying to copy a table from Salesforce using the Azure Data Factory connector and I'm receiving this error. I'm not using the token. I included the IP addresses in Salesforce's whitelist. Connection test passed.

ErrorCode=SalesforceOdbcPropertyInsufficientToRead,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Odbc properties insufficient to read: Invalid URI: The hostname could not be parsed.,Source=Microsoft.DataTransfer.Runtime.SalesforceConnector,'

Any idea what could be happening?

Thanks

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,905 questions
{count} votes

Accepted answer
  1. HarithaMaddi-MSFT 10,136 Reputation points
    2020-11-30T14:09:41.257+00:00

    Hi @Adalberto García Espinosa ,

    I got an update from Product team that the value of "environmentUrl" property specified when creating Salesforce linked service is invalid. They can see from the logs that the exception indicating malformed URI was thrown. Please double check its validity by referencing this document.

    Please let us know if it helps in resolving the issue.

    -----

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

0 additional answers

Sort by: Most helpful