Join an Azure-SSIS integration runtime to a virtual network
You must join Azure-SSIS integration runtime (IR) to an Azure virtual network (VNet) if one of the following conditions is true:
- You are hosting the SSIS Catalog database on a SQL Server Managed Instance (private preview) that is part of a VNet.
You want to connect to on-premises data stores from SSIS packages running on an Azure-SSIS integration runtime.
Azure Data Factory version 2 (Preview) lets you join your Azure-SSIS integration runtime to a classic VNet. Currently, Azure Resource Manager VNet is not supported yet. However, you can work it around as shown in the following section.
This article applies to version 2 of Data Factory, which is currently in preview. If you are using version 1 of the Data Factory service, which is generally available (GA), see Data Factory version 1 documentation.
If SSIS packages access only public cloud data stores, you don't need to join Azure-SSIS IR to a VNet. If SSIS packages access on-premises data stores, you must join Azure-SSIS IR to a VNet that is connected to the on-premises network. If the SSIS Catalog is hosted in Azure SQL Database that is not in the VNet, you need to open appropriate ports. If the SSIS Catalog is hosted in Azure SQL Managed Instance that is in a classic VNet, you can join Azure-SSIS IR to the same classic VNet (or) a different classic VNet that has a class-to-classic VNet connection with the one that has the Azure SQL Managed Instance. The following sections provide more details.
Access on-premises data stores
If your SSIS packages access on-premises data stores, join your Azure-SSIS integration runtime to a VNet that is connected to your on-premises network. Here are a few important points to note:
- If there is no existing VNet connected to your on-premises network, first create a classic VNet for your Azure-SSIS integration runtime to join. Then, configure a site-to-site VPN gateway connection/ExpressRoute connection from that VNet to your on-premises network.
- If there is an existing classic VNet connected to your on-premises network in the same location as your Azure-SSIS integration runtime, you can join your Azure-SSIS integration runtime to it.
- If there is an existing classic VNet connected to your on-premises network in a different location from your Azure-SSIS Integration Runtime, you can first create a classic VNet for your Azure-SSIS Integration Runtime to join. Then, configure a classic-to-classic VNet connection.
- If there is an existing Azure Resource Manager VNet connected to your on-premises network, first create a classic VNet for your Azure-SSIS integration runtime to join. Then, configure a classic-to-Azure Resource Manager VNet connection.
Domain Name Services server
If you need to use your own Domain Name Services (DNS) server in a VNet joined by your Azure-SSIS integration runtime, follow guidance to ensure that the nodes of your Azure-SSIS integration runtime in VNet can resolve Azure endpoints.
Network Security Group
If you need to implement Network Security Group (NSG) in a VNet joined by your Azure-SSIS Integration Runtime, allow inbound/outbound traffics through the following ports:
|Ports||Direction||Transport Protocol||Purpose||Inbound Source/Outbound Destination|
|Inbound||TCP||Azure services use these ports to communicate with the nodes of your Azure-SSIS integration runtime in VNet.||Internet|
|443||Outbound||TCP||The nodes of your Azure-SSIS integration runtime in VNet use this port to access Azure services, for example, Azure Storage, Event Hub, etc.||INTERNET|
|Outbound||TCP||The nodes of your Azure-SSIS integration runtime in VNet use these ports to access SSISDB hosted by your Azure SQL Database server (not applicable to SSISDB hosted by Azure SQL Managed Instance).||Internet|
Script to configure VNet
You can use the guided PowerShell script from this article to provision an Azure-SSIS integration runtime in a VNet. The script automatically configures VNet permissions and settings so that you can join you Azure-SSIS integration runtime to the VNet.
Use portal to configure VNet
Running the script is the easiest way to configure VNet. If you do not have access to configure that VNet/the automatic configuration fails, the owner of that VNet/you can try to configure them manually in the following steps:
Find the resource ID for your Azure VNet.
- Log in to Azure portal.
- Click More services. Filter for and select Virtual networks (classic).
- Filter for and select your virtual network in the list.
In the Virtual network (classic) page, select Properties.
- Click the copy button for the RESOURCE ID to copy the resource ID for the classic network to the clipboard. Save the ID from the clipboard in OneNote or a file.
Click Subnets on the left menu, and ensure that the number of available addresses is greater than the nodes in your Azure-SSIS integration runtime.
Join MicrosoftAzureBatch to Classic Virtual Machine Contributor role for the VNet.
Click Access control (IAM) on the left menu, and click Add in the toolbar.
In Add permissions page, select Classic Virtual Machine Contributor for Role. Type MicrosoftAzureBatch in the Select text box, and then select MicrosoftAzureBatch from the list of search results.
Click Save to save the settings and to close the page.
Confirm that you see MicrosoftAzureBatch in the list of contributors.
Verify that Azure Batch provider is registered in the Azure subscription that has the VNet or register the Azure Batch provider. If you already have an Azure Batch account in your subscription, then your subscription is registered for Azure Batch.
- In Azure portal, click Subscriptions on the left menu.
- Select your subscription.
Click Resource providers on the left, and confirm that
Microsoft.Batchis a registered provider.
If you don't see
Microsoft.Batchis in the list, to register it, create an empty Azure Batch account in your subscription. You can delete it later.
For more information about Azure-SSIS runtime, see the following topics:
- Azure-SSIS Integration Runtime. This article provides conceptual information about integration runtimes in general including the Azure-SSIS IR.
- Tutorial: deploy SSIS packages to Azure. This article provides step-by-step instructions to create an Azure-SSIS IR and uses an Azure SQL database to host the SSIS catalog.
- How to: Create an Azure-SSIS integration runtime. This article expands on the tutorial and provides instructions on using Azure SQL Managed Instance (private preview) and joining the IR to a VNet.
- Monitor an Azure-SSIS IR. This article shows you how to retrieve information about an Azure-SSIS IR and descriptions of statuses in the returned information.
- Manage an Azure-SSIS IR. This article shows you how to stop, start, or remove an Azure-SSIS IR. It also shows you how to scale out your Azure-SSIS IR by adding more nodes to the IR.