Create a Data Factory, copy from Salesforce to Blob
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
Save files to C:\ADFGetStarted folder.
Enter correct values for parameters in azuredeploy.parameters.json.
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