Create a Data Factory, Copy from Blob to SQL with Sproc

Sharon Lo 提供
上次更新时间: 2016/10/10

This template creates a data factory pipeline for a copy activity from Azure Blob into an Azure SQL Database while invoking a stored procedure

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

参数

参数名 说明
storageAccountName Name of the Azure storage account that contains the data to be copied.
storageAccountKey Key for the Azure storage account.
sourceBlobContainer Name of the blob container in the Azure Storage account.
sourceBlobName Name of the blob in the container that has the data to be copied to Azure SQL Database table
sqlServerName Name of the Azure SQL Server that will hold the output/copied data.
sqlDatabaseName Name of Azure SQL Database in Azure SQL server copying data to.
sqlUserID Username for access to Azure SQL Server.
sqlPassword Password for the user to Azure SQL Server.
sqlTargetTable Table in the Azure SQL Database that will hold the copied data.
sqlWriterTableType Specify a table type name to be used in the stored procedure. Copy activity makes the data being moved available in a temp table with this table type.
sqlWriterStoredProcedureName Name of the stored procedure that upserts (updates/inserts) data into the target table.

使用模板

PowerShell
New-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/101-data-factory-blob-to-sql-copy-stored-proc/azuredeploy.json
安装和配置 Azure PowerShell
命令行
azure config mode arm
azure group deployment create <my-resource-group> <my-deployment-name> --template-uri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/101-data-factory-blob-to-sql-copy-stored-proc/azuredeploy.json
安装和配置 Azure 跨平台命令行界面