Skip to content

Execute SSIS Packages between Cloud Data Stores and a Private Network Data Storage

The following article describes a secure data integration approach to execute SSIS packages that access an SAP source system located in a private network (domain).

To perform data integration securely in a private network environment without a direct line-of-sight from the public cloud environment, you can install a self-hosted IR in your on-premises environment behind a firewall, or inside a virtual private network. The self-hosted integration runtime only makes outbound HTTP-based connections to the internet. The Xtract Connection (SAP connection) with the property ConnectByProxy = True is used to implement access to the local network using the Self-Hosted Integration Runtime (SHIR).

Prerequisites

The following prerequisites are mostly based on the official Microsoft documentation for using Azure integration runtime (IR) as well as Self-Hosted Integration Runtime (SHIR).

  • Download and install the latest version of self-hosted IR and the additional drivers and runtime on your on-premises machine or Azure virtual machine (VM).
  • Create an SSIS package on a development environment (Visual Studio) and execute it successfully.
  • Publish the SSIS project to an SSIS in Azure Data Factory (ADF).

Step-by-Step Instructions

  1. Configure and start the Azure Data Factory IR with the necessary files to run the Xtract IS for Azure extension in ADF.
  2. Download and install the SHIR on the local Windows server (on-prem), see Microsoft Integration Runtime.
  3. Register the Integration Runtime (Self-hosted), see Configure a self-hosted IR via UI.

  4. If applicable: Enable SSIS package execution on self-hosted IR node using the following cmd command: 

    C:\Program Files\Microsoft Integration Runtime\5.0\Shared>dmgcmd -eesp

  5. Execute the XtractISSetup.exe file to install Xtraxt IS and use Xtract IS Data Flow Tasks.

  6. If your SSIS package uses one of the following components, download and install the relevant drivers:

Note

If the Integration Runtime (Self-hosted) node encouters errors during execution, error logs are provided using the Windows Event Viewer.

Last update: October 21, 2024
Written by: Fabian Steffan, Maia Reichert-Baisch