Azure Data Factory to copy data from Salesforce to Azure Blobs

Update values for the following parameters in azuredeploy.parameters.json file.

• storageAccountName with name of your existing Azure storage account.
• storageAccountKey with key to your existing your Azure storage account.
• SfUserName with the username to your Salesforce account.
• SfPassword with password corresponding to the Salesforce account.
• SfSecurityToken with security token for accessing Salesforce account.
• SfTable with object in Salesforce that should be copied over.

When you deploy this Azure Resource Template, an Azure Data Factory instance is created with the following entities:

• Salesforce linked service
• Azure Storage linked service
• Salesforce dataset
• Azure Blob dataset
• Pipeline with a copy activity

The copy activity in the pipeline copies data from the Salesforce object to Azure Blob Storage.

Deploy using PowerShell

1. Save files to C:\ADFGetStarted folder.

2. Enter correct values for parameters in azuredeploy.parameters.json.

3. Run the following command:

   New-AzureRmResourceGroupDeployment -Name MyARMDeployment -ResourceGroupName ADFTutorialResourceGroup -TemplateFile C:\ADFGetStarted\azuredeploy.json -TemplateParameterFile C:\ADFGetStarted\azuredeploy.parameters.json

See Tutorial: Create a pipeline using Resource Manager Template article for a detailed walkthrough with step-by-step instructions.