Create a Data Factory, copy from Salesforce to Blob

Azure Public Test Date Azure Public Test Result

Azure US Gov Last Test Date Azure US Gov Last Test Result

Best Practice Check Cred Scan Check 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.

Deploy To Azure Deploy To Azure US Gov Visualize

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.

Tags: Microsoft.DataFactory/factories, linkedservices, Salesforce, AzureStorage, datasets, RelationalTable, AzureBlob, DateTime, TextFormat, pipelines, Copy, RelationalSource, BlobSink