This template creates a data factory of version 2 with a pipeline that copies data from a folder in an Azure Blob Storage to a table in an Azure SQL database.
Here are a few important points about the template:
- The prerequisites for this template are mentioned in the Quickstart: Create a data factory by using Azure PowerShell article.
When you deploy this Azure Resource Manager template, a data factory of version 2 is created with the following entities:
- Azure Storage linked service
- Azure SQL Database linked service
- Azure Blob input datasets
- Azure SQL Datbase output dataset
- Pipeline with a copy activity
- Click the Deployment succeeded message.
- Click Go to resource group.
- Search for *datafactory that's created.
The following sections provide steps for running and monitoring the pipeline. For more information, see Quickstart: Create a data factory by using Azure PowerShell.
After you deploy the template, to run and monitor the pipeline, do the following steps:
-
Download runmonitor.ps1 to a folder on your machine.
-
Launch Azure PowerShell.
-
Run the following command to log in to Azure.
Login-AzureRmAccount
-
Switch to the folder where you copied the script file.
-
Run the following command to log in to Azure after specifying the names of your Azure resource group and the data factory.
.\runmonitor.ps1 -resourceGroupName "<name of your resource group>" -DataFactoryName "<name of your data factory>"