¿Qué es el tiempo de ejecución de integración autohospedado de Azure?

What is azure self-hosted integration runtime?

The integration runtime (IR) is the compute infrastructure that Azure Data Factory and Synapse pipelines use to provide data-integration capabilities across different network environments. A self-hosted integration runtime can run copy activities between a cloud data store and a data store in a private network.

The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory and Azure Synapse pipelines to provide the following data integration capabilities across different network environments: Data Flow: Execute a Data Flow in managed Azure compute environment.

On the Connections pane of Manage hub, switch to the Integration runtimes page and select Refresh. You can edit/reconfigure your Azure-SSIS IR by selecting its name.

In the ADF blade, click on Author & Monitor button.

1. That will open a separate tab for the Azure Data Factory UI.
2. From the Template Gallery, select Copy data from on-premise SQL Server to SQL Azure.
3. That will open the panel for setting up the pipeline.
4. Create A Linked Service.
5. Click Next.
6. Let’s select Express setup.

Azure Data Factory (ADF) is a Microsoft Azure PaaS solution for data transformation and load. ADF supports data movement between many on premises and cloud data sources.

Benefits

• Reduce operational costs and reduce the burden of managing infrastructure that you have when you run SSIS on-premises or on Azure virtual machines.
• Increase high availability with the ability to specify multiple nodes per cluster, as well as the high availability features of Azure and of Azure SQL Database.

If you already have a gateway installed on your computer to serve a Power BI scenario, install a separate self-hosted integration runtime for Data Factory on another machine. Use a self-hosted integration runtime to support data integration within an Azure virtual network.

In the Connect via Integration Runtime, select New. The Integration Runtime (IR) is the compute infrastructure used by Azure Factory to provide data integration capabilities across different network environments. Azure Integration Runtime can be used to connect to data stores and compute services in public network with public accessible endpoints.

Several communication channels are required between Azure Data Factory and the customer virtual network, as shown in the following table: A control plane, required by Data Factory authoring and monitoring. Required by the self-hosted integration runtime to connect to the Data Factory service.

On-premises data access is supported by joining Azure-SSIS IR to a Virtual Network that is connected to your on-premises network. Azure-SSIS IR compute resource and scaling Azure-SSIS IR is a fully managed cluster of Azure VMs dedicated to run your SSIS packages.