Edit

Configure Azure-SSIS integration runtime to join a virtual network

  • Article

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Tip

Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!

This tutorial provides minimum steps via Azure portal/Azure Data Factory (ADF) UI to configure your Azure-SQL Server Integration Services (SSIS) integration runtime (IR) to join a virtual network with express injection method. The steps include:

  1. Configure a virtual network for express injection method via Azure portal.
  2. Join your Azure-SSIS IR to the virtual network with express injection method via ADF UI

Prerequisites

The following virtual network configurations aren't covered in this tutorial:

  • If you use a static public IP address for Azure-SSIS IR.
  • If you use your own domain name system (DNS) server.
  • If you use a network security group (NSG).
  • If you use user-defined routes (UDRs).

If you want to perform these optional steps, see the Express virtual network injection method article.

Configure a virtual network

Use Azure portal to configure a virtual network before you try to join your Azure-SSIS IR to it.

  1. Start Microsoft Edge or Google Chrome. Currently, only these web browsers support ADF UI.

  2. Sign in to the Azure portal.

  3. Select More services. Filter for and select Virtual networks.

  4. Filter for and select your virtual network in the list.

  5. On the left-hand-side menu, select Subnets:

  6. Make sure that Microsoft.Batch is a registered resource provider in Azure subscription that has the virtual network for your Azure-SSIS IR to join. For detailed instructions, see the Register Azure Batch as a resource provider section.

Join Azure-SSIS IR to the virtual network

After you've configured a virtual network, you can join your Azure-SSIS IR to the virtual network:

  1. Start Microsoft Edge or Google Chrome. Currently, only these web browsers support ADF UI.

  2. In Azure portal, on the left-hand-side menu, select Data factories. If you don't see Data factories on the menu, select More services, and then in the INTELLIGENCE + ANALYTICS section, select Data factories.

    List of data factories

  3. Select your ADF with Azure-SSIS IR in the list. You see the home page for your ADF. Select the Open Azure Data Factory Studio tile. You see ADF UI on a separate tab.

    Data factory home page

  4. In ADF UI, switch to the Edit tab, select Connections, and switch to the Integration Runtimes tab.

    "Integration runtimes" tab

  5. If your Azure-SSIS IR is running, in the Integration Runtimes list, in the Actions column, select the Stop button for your Azure-SSIS IR. You can't edit your Azure-SSIS IR until you stop it.

    Stop the IR

  6. In the Integration Runtimes list, in the Actions column, select your Azure-SSIS IR to edit it.

  7. On the Integration runtime setup pane, advance through the General settings and Deployment settings pages by selecting the Next button.

  8. On the Advanced settings page, complete the following steps.

    Advanced settings for express virtual network injection

    1. Select the Select a VNet for your Azure-SSIS Integration Runtime to join, allow ADF to create certain network resources, and optionally bring your own static public IP addresses check box.

    2. For Subscription, select the Azure subscription that has your virtual network.

    3. For Location, the same location of your integration runtime is selected.

    4. For Type, select the type of your virtual network: Azure Resource Manager Virtual Network/classic virtual network. We recommend that you select Azure Resource Manager Virtual Network, because classic virtual network will be deprecated soon.

    5. For VNet Name, select the name of your virtual network. It should be the same one used to configure a virtual network service endpoint/private endpoint for your Azure SQL Database server that hosts SSISDB. Or it should be the same one joined by your Azure SQL Managed Instance that hosts SSISDB. Or it should be the same one connected to your on-premises network.

    6. For Subnet Name, select the name of subnet for your virtual network. It should be the same one used to configure a virtual network service endpoint for your Azure SQL Database server that hosts SSISDB. Or it should be a different subnet from the one joined by your Azure SQL Managed Instance that hosts SSISDB.

    7. For VNet injection method, select Express for express virtual network injection.

    8. Select VNet Validation. If the validation is successful, select Continue.

  9. On the Summary page, review all settings for your Azure-SSIS IR and then select Update.

  10. Start your Azure-SSIS IR by selecting the Start button in Actions column for your Azure-SSIS IR. It takes about 5 minutes to start your Azure-SSIS IR that joins a virtual network with express injection method.

Related content

For more information about Azure-SSIS IR, see the following articles:

  • Azure-SSIS IR. This article provides general conceptual information about IRs, including Azure-SSIS IR.
  • Tutorial: Deploy SSIS packages to Azure. This tutorial provides step-by-step instructions to create your Azure-SSIS IR. It uses Azure SQL Database server to host SSISDB.
  • Create an Azure-SSIS IR. This article expands on the tutorial. It provides instructions on using Azure SQL Database server configured with a virtual network service endpoint/IP firewall rule/private endpoint or Azure SQL Managed Instance that joins a virtual network to host SSISDB. It shows you how to join your Azure-SSIS IR to a virtual network.
  • Monitor an Azure-SSIS IR. This article shows you how to retrieve and understand information about your Azure-SSIS IR.
  • Manage an Azure-SSIS IR. This article shows you how to stop, start, or delete your Azure-SSIS IR. It also shows you how to scale out your Azure-SSIS IR by adding more nodes.