Azure SSIS IR Installation (PowerShell)

To use the component with the Azure SSIS Integration Runtime, the component must be installed and configured on the corresponding Azure nodes. The actual installation and licensing of the component takes place via a batch file, which is automatically executed when the Azure SSIS IR is started.

The batch file or the location of the batch file must be defined when creating the Azure SSIS IR.

The following script explains the complete creation of a Data Factory with Azure SSIS IR instance via PowerShell.

First, we declare various variables for the PowerShell script. Please note that you must define all values <VARIABLE VALUE> with your data.

The following script logs you in to your defined subscription, creates a Data Factory V2 and an Azure SSIS IR and then starts the Azure SSIS IR.

The batch file to be executed by the Azure SSIS IR during the boot process contains various SQLPhonetics.NET specific settings. If you want to use another component in Azure SSIS IR, refer to the corresponding manufacturer-specific parameters.

The batch file first runs the installer of SQLPhonetics.NET via msiexec. To do this, the MSI file together with the batch file must be on the same blob storage that you previously defined using the SetupScriptContainerSasUri parameter.

Then the license system of the SQLPhonetics.NET component is called. The license ID and password you received when you purchased the component are transferred here as parameters. As an additional parameter, you must pass the name of a blob container and the connection string to a blob storage to the component. On this container the license system stores the license of the component for your created Azure SSIS IR. If you use several nodes or stop and restart the component several times, the existing license is accessed.

Make sure that the number of licenses used corresponds to the maximum size of your Azure SSIS IR.