Now thisAzure-SSIS Integration Runtime (IR)is inPublic Previewas part of Azure Synapse Analytics. In Azure Data Factory, this runtime is already GA – Generally Available.
What does this mean for Azure customer?
Now customer can lift and shift their existing SSIS workload to synapse by creating an Azure-SSIS IR to execute SSIS packages natively using Execute SSIS Package activity in Azure Synapse pipeline. So we can lift and shift existing on-premise SSIS packages (which were previously running on premise SQL server) to Azure cloud & execute there.
In Azure Data Factory, this runtime is already Generally Available as shown in below image
What is Integration Runtime (IR)?
As a native compute of Azure, it is used to execute or dispatch activities by Azure Data Factory and Azure Synapse pipelines for following data integration capabilities across different network environments:
- Data Flow: data transformation and sink to destination
- Data movement: Copy data across data stores in a public or private networks
- Activity dispatch: Dispatch and monitor transformation activities like Azure Databricks, Azure HDInsight etc
- SSIS package execution: Natively execute SQL Server Integration Services (SSIS) packages
What is Azure-SSIS Integration Runtime (IR)?
“The Azure-SSIS IR is a fully managed cluster of Azure VMs dedicated to run your SSIS packages.”
We can use Azure-SSIS Integration Runtime (IR) to execute SSIS package activity using Execute SSIS Package activity in Azure Synapse Analytics pipeline.
“The Azure-SSIS IR can be provisioned in either public network or private network. On-premises data access is supported by joining Azure-SSIS IR to a virtual network that is connected to your on-premises network.”
How to manage cost & scale the compute?
We can scale up the power of the compute by specifying node size and scale it out by specifying the number of nodes in the cluster. You can manage the cost of running your Azure-SSIS Integration Runtime by stopping and starting it as your requirements demand.
What are deployment model to deploy SSIS Package in Azure?
Deployment Model supported by An Azure-SSIS IR in Azure Synapse Analytics :
- Project Deployment Model : to Run packages deployed into SSIS catalog (SSISDB) hosted by Azure SQL Database server/Managed Instance
- Package Deployment Model: Running packages deployed into Azure Files
Please note:
- Deployment target as SSIS in Azure Synapse Analytics is not available currently.
- To deploy SSIS project to SSIS IR in Azure Synapse Analytics, in the Select Deployment Target step, choose SSIS in Azure Data Factory instead.
Thanks for reading; Please feel free to share your query/thought in the comment section below.