How to Transfer Data from Azure SQL server to Salesforce FSC by using ADF and Bulk api or bulk api 2.0

Question

Hi All,

I have requirement where I need to transfer historic data from SQL server to Salesforce FSC or org. Can any one help me about steps to be followed for historic data load inside salesforce. I tried steps given by Microsoft documentation -

https://learn.microsoft.com/en-us/azure/data-factory/connector-salesforce-service-cloud?source=recommendations&tabs=data-factory

but i got below error while creating linked services for salesforce.

Answer 1

Hi @Vipul Narsing

Thank you for reaching out to the community forum with your query.

Based on the error message "The remote name could not be resolved" indicates an issue with resolving the hostname customization-drive.my.salesforce.com. Here are some troubleshooting steps you can follow:

1. Double-check the Salesforce instance URL: Ensure you've entered the correct Salesforce instance URL in the Azure Data Factory (ADF) linked service configuration. It should be in the format https://<your_salesforce_domain>.my.salesforce.com.
2. Verify DNS resolution: Make sure your Azure Integration Runtime (AIR) can resolve the Salesforce instance hostname. You can test this by pinging the hostname from the AIR environment.
3. Check network connectivity: Ensure there are no firewall restrictions or network security groups (NSGs) blocking communication between the AIR and Salesforce.
4. Review Salesforce permissions: Verify that the Salesforce user you're using for authentication has the necessary permissions to perform bulk data loads.

I hope this helps! Let me know if you have any further questions or concerns.