Xtract IS for Azure

This section shows how to set up Xtract IS on an Azure SSIS Integration Runtime environment.

About Xtract IS for Azure

SSIS packages that contain Xtract IS components can be run on an Azure SSIS Integration Runtime (IR). Instead of deploying the developed packages to an on-prem SSIS server, the packages are deployed to an Azure SSIS-IR to be scheduled and run in the Azure cloud. In this scenario Xtract IS is licensed per Azure SSIS-IR using the Azure SSIS-IR Cluster ID. This license model is distributed as "Xtract IS for Azure".

How it works:

Development of SSIS Packages
- Install Xtract IS on an on-prem Visual Studio/SSDT environment, see Xtract IS - Installation.
- Develop SSIS packages with Xtract IS and deploy them to an Azure SSIS-IR.
Running SSIS Packages
- Install Xtract IS on an Azure SSIS-IR, see Install Xtract IS For Azure.
- Schedule and run the deployed SSIS packages in the Azure cloud.

Prerequisites

Azure-SSIS Integration Runtime (IR), based on Microsoft's Azure Data Factory v2 (ADFv2)
The SAP system needs to be accessible from the Azure SSIS-IR, e.g., through a VPN tunnel or a self-hosted Integration Runtime (SHIR), see Microsoft Documentation: Configure a self-hosted IR as a proxy for an Azure SSIS-IR in Azure Data Factory.
When creating the SSIS packages, make sure to use the correct SQL Server Data Tools (SSDT) for your SQL Server Integration Services (SSIS) version, see Microsoft Documentation: Download SQL Server Data Tools (SSDT) for Visual Studio for details.

Setup an Azure SSIS-IR Environment

Refer to the Microsoft documentation to set up the Azure-SSIS Integration Runtime environment:

Once the environment runs, develop a simple SSIS package that does NOT contain any Xtract IS components and deploy and run the package on the Azure SSIS-IR. If the SSIS package runs is successfully, proceed to set up Xtract IS for Azure on the Azure SSIS-IR.

Note

By default Azure automatically updates the Microsoft integration runtime. To avoid possible compatibility issues with Xtract IS for Azure, disable automatic updates.

Install Xtract IS for Azure

Follow the steps below to create an Azure Storage container for Xtract IS and add the container to an Azure SSIS-IR:

Follow the instructions in the Microsoft Documentation: Standard Custom Setup to set up 3rd party extensibility for Azure SSIS-IR. Only the part of the Azure storage container setup and the creation of a Shared Access Signature is relevant.
Copy the following files provided in the customer portal into the Azure storage container:
- XtractISSetup.exe
- main.cmd
- XtractISLicense.json (license file provided after purchasing Xtract IS for Azure)
Add Azure Storage Container to SSIS-IR:
- When provisioning the Azure SSIS-IR via the Azure Portal UI, enter the Azure Storage container's SAS URI in the Custom setup container SAS URI field.
- When provisioning the Azure SSIS-IR via PowerShell populate the parameter -SetupScriptContainerSasUri with the Azure Storage container's SAS URI.
Start the Integration Runtime. During the startup of the Integration Runtime the main.cmd is executed, which triggers an unattended installation of Xtract IS for Azure on the SSIS-IR.

The startup process of the Azure SSIS-IR might take up to 20 minutes.

Recommendation

A regular update of the software is crucial for stable performance. Check the changelog for updates. A newer version can be installed over the older version.

Last update: October 21, 2024