IFS Analysis Models - Azure Artifact setup - SSIS Integration Runtime

General

The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the following data integration capabilities: 1. SSIS package execution: Natively execute SQL Server Integration Services (SSIS) packages in a managed Azure compute environment. https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

Configuring SSIS Integration Runtime

Note 1: Pre-requisites: • Azure Data Factory • SQL Server and Database • Storage Account and SAS Token

Note 2: Please familiaries yourself with the Microsoft documentation re the cost of the SSIS-IR to understand the charges you may receive by leaving the SSIS-IR running

Navigate to Integration Runtimes in Azure Data Factory and click “New”

Create an “Azure-SSIS” runtime

Select the node size, Edition/License type for your installation

Note: for first installations we suggest the base settings as shown below to save costs

Select the Database Sever Endpoint and enter the Database Credentials

Enter the SAS URI create and stored when creating the Storage Account Also set the VNET/Subnet alread created

Further Microsoft Documentation

• https://docs.microsoft.com/en-us/azure/data-factory/tutorial-deploy-ssis-packages-azure • https://docs.microsoft.com/en-us/azure/data-factory/create-azure-ssis-integration-runtime • https://docs.microsoft.com/en-us/azure/data-factory/how-to-configure-azure-ssis-ir-custom-setup • https://docs.microsoft.com/en-us/azure/data-factory/join-azure-ssis-integration-runtime-virtual-network#access-to-data-sources-protected-by-ip-firewall-rule