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

Question

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

Answer 1

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.