The Azure Quickstart templates are currently available in English

Create a V2 data factory

Sreedhar Pelluru 提供
上次更新时间: 2018/2/15

This template creates a V2 data factory that copies data from an on-premises SQL Server to an Azure blob storage

此 Azure Resource Manager (ARM) 模板由社区的某个成员(而不是由 Microsoft)创建。每个 ARM 模板都根据其所有者(不是 Microsoft)的许可协议向你授予许可。Microsoft 不对由社区成员提供并授予许可的 ARM 模板负责,并且不针对安全性、兼容性和性能进行筛选。社区 ARM 模板不由任何 Microsoft 支持计划或服务提供支持,按“原样”提供,没有任何种类的担保。

参数

参数名 说明
dataFactoryName Name of the data factory. Must be globally unique.
dataFactoryLocation Location of the data factory.
onPremSqlServerConnectionString Connnection string for the on-premsies SQL Server database.
sqlTableName Name of the target table in the Azure SQL database.
azureStorageConnectionString Connection string for the Azure Storage account.
blobContainer Name of the blob container in the Azure Storage account.
outputBlobFolder The folder in the blob container to which the data is copied.

使用模板

PowerShell

New-AzResourceGroup -Name <resource-group-name> -Location <resource-group-location> #use this command when you need to create a new resource group for your deployment
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-data-factory-v2-onprem-sql-to-blob-copy/azuredeploy.json
安装和配置 Azure PowerShell

命令行

az group create --name <resource-group-name> --location <resource-group-location> #use this command when you need to create a new resource group for your deployment
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-data-factory-v2-onprem-sql-to-blob-copy/azuredeploy.json
安装和配置 Azure 跨平台命令行界面