solution-templates-introduction.md

title	description	ms.service	ms.subservice	ms.topic	ms.author	author	ms.custom	ms.date
Overview of templates	Learn how to use a pre-defined template to get started quickly with Azure Data Factory.	data-factory	tutorials	conceptual	susabat	ssabat	seo-lt-2019	09/09/2021

Templates

[!INCLUDEappliesto-adf-asa-md]

Templates are predefined Azure Data Factory pipelines that allow you to get started quickly with Data Factory. Templates are useful when you're new to Data Factory and want to get started quickly. These templates reduce the development time for building data integration projects thereby improving developer productivity.

Create Data Factory pipelines from templates

You can get started creating a Data Factory pipeline from a template in the following two ways:

1. Select Pipeline templates in the Discover more section of the Data Factory home page to open the template gallery.

   :::image type="content" source="media/doc-common-process/home-page-pipeline-templates-tile.png" alt-text="Screenshot showing how to open the template gallery from the Data Factory home page.":::

2. On the Author tab in Resource Explorer, select +, then select Pipeline from template to open the template gallery.

   :::image type="content" source="media/solution-templates-introduction/templates-introduction-image-2.png" alt-text="Screenshot showing how to open the template gallery from the Author tab.":::

Template Gallery

:::image type="content" source="media/solution-templates-introduction/templates-introduction-image-3.png" alt-text="Screenshot showing the Template gallery page.":::

Out of the box Data Factory templates

Data Factory uses Azure Resource Manager templates for saving data factory pipeline templates. You can see all the Resource Manager templates, along with the manifest file used for out of the box Data Factory templates, in the official Azure Data Factory GitHub repo. The predefined templates provided by Microsoft include but are not limited to the following items:

• Copy templates:

  • Bulk copy from Database

  • Copy new files by LastModifiedDate

  • Copy multiple file containers between file-based stores

  • Move files

  • Delta copy from Database

  • Copy from <source> to <destination>

    • From Amazon S3 to Azure Data Lake Store Gen 2

    • From Google Big Query to Azure Data Lake Store Gen 2

    • From HDF to Azure Data Lake Store Gen 2

    • From Netezza to Azure Data Lake Store Gen 1

    • From SQL Server on premises to Azure SQL Database

    • From SQL Server on premises to Azure Synapse Analytics

    • From Oracle on premises to Azure Synapse Analytics

• SSIS templates

  • Schedule Azure-SSIS Integration Runtime to execute SSIS packages

• Transform templates

  • ETL with Azure Databricks

My Templates

You can also save a pipeline as a template by selecting Save as template on the Pipeline tab.

:::image type="content" source="media/solution-templates-introduction/templates-introduction-image-4.png" alt-text="Screenshot showing how to save a pipeline as a template.":::

After checking the My templates box in the Template gallery page, you can view pipelines saved as templates in the right pane of this page.

:::image type="content" source="media/solution-templates-introduction/templates-introduction-image-5.png" alt-text="Screenshot showing the My templates pane.":::

Note

To use the My Templates feature, you have to enable GIT integration. Both Azure DevOps GIT and GitHub are supported.