Skip to content

Latest commit

 

History

History
35 lines (27 loc) · 2.1 KB

README.md

File metadata and controls

35 lines (27 loc) · 2.1 KB

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.