This template creates a data factory pipeline with Copy and HDInsight Hive activities.
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 |
---|---|
storageAccountResourceGroupName | The resource group that contains your Azure storage account that contains the input/output data. |
storageAccountName | Name of the Azure storage account that contains the input/output data. |
storageAccountKey | Key for the Azure storage account. |
blobContainer | Name of the blob container in the Azure Storage account. |
inputBlobFolder | The folder in the blob container that has the input file. |
inputBlobName | Name of the input file/blob. |
ftpHost | Name or IP address of FTP server. |
ftpUser | User account that has access to the FTP server. |
ftpPassword | Password for the user account that has access to the FTP server. |
ftpFolderName | The folder in FTP that has the input file. |
ftpFileName | Name of the input file in FTP. |
outputBlobFolder | The folder in the blob container that will hold the transformed data. |
hiveScriptFolder | The folder in the blob container that contains the Hive query file. |
hiveScriptFile | Name of the hive query (HQL) file. |
sqlServerName | Name of the Azure SQL Server that will hold the output/copied data. |
sqlDatabaseName | 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-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/201-data-factory-ftp-hive-blob/azuredeploy.jsonInstalace a konfigurace Azure PowerShell
Příkazový řádek
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/201-data-factory-ftp-hive-blob/azuredeploy.jsonInstalace a konfigurace rozhraní Azure Cross-Platform Command-Line Interface