The Azure Quickstart templates are currently available in English
This template creates a data factory pipeline for a copy activity from Azure Blob into an Azure SQL Database
Tuto šablonu Azure Resource Manageru (ARM) vytvořil člen komunity a ne Microsoft. Licenci na každou šablonu ARM vám na základě licenční smlouvy uděluje její vlastník, ne Microsoft. Za šablony ARM poskytované a licencované členy komunity nenese Microsoft žádnou odpovědnost ani neprověřuje jejich zabezpečení, kompatibilitu nebo výkon. Šablony ARM komunity nejsou podporované v rámci žádné služby nebo programu podpory Microsoftu a jsou dostupné TAK JAK JSOU, bez jakékoliv záruky.
Parametry
Název parametru | Popis |
---|---|
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. |
databaseName | Name of the Azure SQL Database in the Azure SQL server. |
sqlServerUserName | Name of the user that has access to the Azure SQL server. |
sqlServerPassword | Password for the user. |
targetSQLTable | Table in the Azure SQL Database that will hold the copied data. |
Použití šablony
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 deploymentInstalace a konfigurace Azure PowerShell
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-data-factory-blob-to-sql-copy/azuredeploy.json
Příkazový řádek
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 deploymentInstalace a konfigurace rozhraní Azure Cross-Platform Command-Line Interface
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-data-factory-blob-to-sql-copy/azuredeploy.json