自定义 Azure-SSIS 集成运行时的安装Customize setup for the Azure-SSIS integration runtime

Azure-SSIS 集成运行时的自定义安装界面提供了一个界面,用于在预配或重新配置 Azure-SSIS IR 期间添加自己的安装步骤。The custom setup interface for the Azure-SSIS Integration Runtime provides an interface to add your own setup steps during the provisioning or reconfiguration of your Azure-SSIS IR.

使用自定义安装程序可以更改默认的操作配置或环境(例如,用于启动其他 Windows 服务,或保存访问凭据以便进行文件共享),或者在 Azure-SSIS IR 的每个节点上安装其他组件(例如程序集、驱动程序或扩展)。Custom setup lets you alter the default operating configuration or environment (for example, to start additional Windows services or persist access credentials for file shares) or install additional components (for example, assemblies, drivers, or extensions) on each node of your Azure-SSIS IR.

可以通过两种方法在 Azure-SSIS IR 上执行自定义安装:无需脚本的快速自定义安装和使用脚本的标准自定义安装。There are two ways to do custom setups on your Azure-SSIS IR: express custom setups without scripts and standard custom setups with scripts.

通过快速自定义安装,可运行一些常见的系统配置/Windows 命令,或安装一些受欢迎/推荐的其他组件,而无需使用任何脚本。With express custom setups, you can run some common system configurations/Windows commands or install some popular/recommended additional components without using any scripts.

通过标准自定义安装,你需准备一个脚本及其关联的文件,并将其全部上传到 Azure 存储帐户中的 Blob 容器。With standard custom setups, you need to prepare a script and its associated files, and upload them all together into a blob container in your Azure Storage account. 然后预配或重新配置 Azure-SSIS IR 时,为容器提供共享访问签名 (SAS) 统一资源标识符 (URI)。You then provide a Shared Access Signature (SAS) Uniform Resource Identifier (URI) for your container when you provision or reconfigure your Azure-SSIS IR. 然后,Azure-SSIS IR 的每个节点将从该容器下载该脚本及其关联的文件,并使用提升的特权运行自定义安装。Each node of your Azure-SSIS IR will then download the script and its associated files from your container and run your custom setup with elevated privileges. 自定义安装完成后,每个节点会将标准执行输出和其他日志上传到容器中。When your custom setup is finished, each node will upload the standard output of execution and other logs into your container.

无论使用快速还是标准自定义安装,都可安装免费(无许可证)和付费(带许可证)的组件。You can install both free/unlicensed and paid/licensed components with express/standard custom setups. 如果你是 ISV,请参阅有关如何为 Azure-SSIS IR 开发付费或带许可证的组件的文档。If you're an ISV, see our documentation on how to develop paid or licensed components for Azure-SSIS IR.

Important

Azure-SSIS IR 的 v2 系列节点不适用于自定义设置,因此请改用 v3 系列节点。The v2-series nodes of Azure-SSIS IR are not suitable for custom setup, so please use the v3-series nodes instead. 如果已使用 v2 系列节点,请尽快改为使用 v3 系列节点。If you already use the v2-series nodes, please switch to use the v3-series nodes as soon as possible.

当前限制Current limitations

以下限制仅适用于标准自定义安装:The following limitations applies only to standard custom setups:

  • 如果想要在脚本中使用 gacutil.exe 将程序集安装到全局程序集缓存 (GAC) 中,则需要在自定义安装过程中提供 gacutil.exe,或使用下面公共预览版容器中提供的副本。If you want to use gacutil.exe in your script to install assemblies in the Global Assembly Cache (GAC), you need to provide gacutil.exe as part of your custom setup, or use the copy provided in our Public Preview container below.

  • 如果要在脚本中引用子文件夹,msiexec.exe 不支持使用 .\ 表示法引用根文件夹。If you want to reference a subfolder in your script, msiexec.exe does not support the .\ notation to reference the root folder. 请使用类似 msiexec /i "MySubfolder\MyInstallerx64.msi" ... 的命令,而不要使用 msiexec /i ".\MySubfolder\MyInstallerx64.msi" ...Use a command like msiexec /i "MySubfolder\MyInstallerx64.msi" ... instead of msiexec /i ".\MySubfolder\MyInstallerx64.msi" ....

  • Azure-SSIS IR 当前不支持管理共享(即 Windows 自动创建的隐藏的网络共享)。Administrative shares, i.e. hidden network shares automatically created by Windows, are currently not supported on the Azure-SSIS IR.

  • Azure-SSIS IR 不支持 IBM iSeries Access ODBC 驱动程序。IBM iSeries Access ODBC Driver is not supported on the Azure-SSIS IR. 在自定义安装过程中,你可能会看到安装错误。You may see installation errors during your custom setup. 请联系 IBM 支持获取帮助。Please contact IBM support for assistance.

先决条件Prerequisites

Note

本文进行了更新,以便使用新的 Azure PowerShell Az 模块。This article has been updated to use the new Azure PowerShell Az module. 你仍然可以使用 AzureRM 模块,至少在 2020 年 12 月之前,它将继续接收 bug 修补程序。You can still use the AzureRM module, which will continue to receive bug fixes until at least December 2020. 若要详细了解新的 Az 模块和 AzureRM 兼容性,请参阅新 Azure Powershell Az 模块简介To learn more about the new Az module and AzureRM compatibility, see Introducing the new Azure PowerShell Az module. 有关 Az 模块安装说明,请参阅安装 Azure PowerShellFor Az module installation instructions, see Install Azure PowerShell.

若要自定义 Azure-SSIS IR,需要做好以下准备:To customize your Azure-SSIS IR, you need the following things:

说明Instructions

  1. 如果要通过 PowerShell 预配或重新配置 Azure-SSIS IR,请下载并安装 Azure PowerShellIf you want to provision or reconfigure your Azure-SSIS IR with PowerShell, download and install Azure PowerShell. 对于快速自定义安装,请跳到步骤 4。For express custom setups, skip to step 4.

  2. 准备自定义安装脚本及其关联的文件(例如 .bat、.cmd、.exe、.dll、.msi 或 .ps1 文件)。Prepare your custom setup script and its associated files (for example, .bat, .cmd, .exe, .dll, .msi, or .ps1 files).

    1. 必须创建一个名为 main.cmd 的脚本文件,即自定义安装程序的入口点。You must have a script file named main.cmd, which is the entry point of your custom setup.

    2. 需要确保脚本可以在无提示的情况下执行,建议先在本地计算机上测试脚本。You need to make sure the script can be executed silently, it is recommended to test the script on local machine first.

    3. 如果想要将其他工具(例如 msiexec.exe)生成的其他日志上传到容器,请在脚本中指定预定义的环境变量 CUSTOM_SETUP_SCRIPT_LOG_DIR 作为日志文件夹(例如 msiexec /i xxx.msi /quiet /lv %CUSTOM_SETUP_SCRIPT_LOG_DIR%\install.log)。If you want additional logs generated by other tools (for example, msiexec.exe) to be uploaded into your container, specify the predefined environment variable, CUSTOM_SETUP_SCRIPT_LOG_DIR as the log folder in your scripts (for example, msiexec /i xxx.msi /quiet /lv %CUSTOM_SETUP_SCRIPT_LOG_DIR%\install.log).

  3. 下载、安装并启动 Azure 存储资源管理器Download, install, and launch Azure Storage Explorer.

    1. 在“(本地和附加)”下面,右键单击“存储帐户”并选择“连接到 Azure 存储”。 Under (Local and Attached), right-select Storage Accounts and select Connect to Azure storage.

      连接到 Azure 存储

    2. 选择“使用存储帐户名和密钥”并选择“下一步”。 Select Use a storage account name and key and select Next.

      使用存储帐户名称和密钥

    3. 输入 Azure 存储帐户名和密钥,并依次选择“下一步”、“连接”。 Enter your Azure Storage account name and key, select Next, and then select Connect.

      提供存储帐户名和密钥

    4. 在已连接的 Azure 存储帐户下面,右键单击“Blob 容器”,选择“创建 Blob 容器”,并为新容器命名。 Under your connected Azure Storage account, right-click on Blob Containers, select Create Blob Container, and name the new container.

      创建 Blob 容器

    5. 选择新容器并上传自定义安装脚本及其关联的文件。Select the new container and upload your custom setup script and its associated files. 请务必将 main.cmd 上传到容器的顶级目录,而不要上传到任何文件夹中。Make sure that you upload main.cmd at the top level of your container, not in any folder. 另请确保你的容器仅包含所需的自定义安装文件,以便稍后将它们下载到 Azure-SSIS IR 时不会花费较长的时间。Please also ensure that your container contains only the necessary custom setup files, so downloading them onto your Azure-SSIS IR later will not take a long time. 自定义安装的最大期限目前设置为 45 分钟(以后将超时),这包括从容器下载所有文件并将其安装在 Azure-SSIS IR 上的时间。The maximum period for custom setup is currently set at 45 minutes before it times out and this includes the time to download all files from your container and install them on Azure-SSIS IR. 如果需要延长期限,请提交支持票证。If a longer period is needed, please raise a support ticket.

      将文件上传到 Blob 容器

    6. 右键单击容器,并选择“获取共享访问签名”。 Right-click the container and select Get Shared Access Signature.

      获取容器的共享访问签名

    7. 为容器创建一个过期时间足够长且具有读取 + 写入 + 列出权限的 SAS URI。Create the SAS URI for your container with a sufficiently long expiry time and with read + write + list permissions. 每当将 Azure-SSIS IR 的任何节点重置映像/重启时,都需要使用该 SAS URI 来下载并运行自定义安装脚本及其关联文件。You need the SAS URI to download and run your custom setup script and its associated files whenever any node of your Azure-SSIS IR is reimaged/restarted. 需要拥有写入权限才能上传安装执行日志。You need write permission to upload setup execution logs.

      Important

      请确保在 Azure-SSIS IR 的整个生命周期内(从创建到删除),尤其是在此期间你经常停止并启动 Azure-SSIS IR 时,SAS URI 不会过期,并且自定义安装资源始终可用。Please ensure that the SAS URI does not expire and custom setup resources are always available during the whole lifecycle of your Azure-SSIS IR, from creation to deletion, especially if you regularly stop and start your Azure-SSIS IR during this period.

      生成容器的共享访问签名

    8. 复制并保存容器的 SAS URI。Copy and save the SAS URI of your container.

      复制并保存共享访问签名

  4. 使用数据工厂 UI 预配或重新配置 Azure-SSIS IR 时,可以在集成运行时安装面板的“高级设置”部分中选择“使用其他系统配置/组件安装来自定义 Azure-SSIS Integration Runtime”复选框来添加/删除自定义安装 。When you provision or reconfigure your Azure-SSIS IR with Data Factory UI, you can add/remove custom setups by selecting the Customize your Azure-SSIS Integration Runtime with additional system configurations/component installations check box on the Advanced Settings section of integration runtime setup panel.

    如果要添加标准自定义安装,请在“自定义安装容器 SAS URI”字段中输入容器的 SAS URI 。If you want to add standard custom setups, enter the SAS URI of your container in the Custom setup container SAS URI field.

    如果要添加快速自定义安装,请选择“新建”以打开“添加快速自定义安装”面板,然后在“快速自定义安装类型”下拉菜单中选择任意类型 :If you want to add express custom setups, select New to open the Add express custom setup panel and then select any types under the Express custom setup type dropdown menu:

    1. 如果选择“运行 cmdkey 命令”类型,则可以在 Azure-SSIS IR 上保存你的文件共享/Azure 文件存储的访问凭据,方法是在“/Add”、“/User”和“/Pass”字段中分别输入目标计算机/域名、帐户名/用户名和帐户密钥/密码 。If you select the Run cmdkey command type, you can persist access credentials for your file shares/Azure Files on Azure-SSIS IR by entering your targeted computer/domain name, account name/username, and account key/password in the /Add, /User, and /Pass fields, respectively. 这类似于在本地计算机上运行 Windows cmdkey 命令。This is similar to running Windows cmdkey command on your local machine.

    2. 如果选择“添加环境变量”类型,则可分别在“变量名”和“变量值”中输入环境变量名称和值,添加要在 Azure-SSIS IR 上运行的包中使用的 Windows 环境变量 。If you select the Add environment variable type, you can add Windows environment variables to use in your packages that run on Azure-SSIS IR by entering your environment variable name and value in the Variable name and Variable value fields, respectively. 这类似于在本地计算机上运行 Windows set 命令。This is similar to running Windows set command on your local machine.

    3. 如果选择“安装有许可证的组件”类型,可以在“组件名”下拉菜单中选择来自我们 ISV 合作伙伴的任何集成组件 :If you select the Install licensed component type, you can then select any integrated components from our ISV partners under the Component name dropdown menu:

      1. 如果选择“SentryOne 的任务工厂”组件,可通过在“许可证密钥”字段中输入从 SentryOne 购买的产品许可证密钥,在 Azure-SSIS IR 上安装 SentryOne 提供的任务工厂组件套件 。If you select the SentryOne's Task Factory component, you can install the Task Factory suite of components from SentryOne on your Azure-SSIS IR by entering the product license key that you purchased from them in the License key field. 当前的集成版本是 2019.4.3 。The current integrated version is 2019.4.3.

      2. 如果选择“oh22 的 HEDDA.IO”组件,可在购买 oh22 服务后,在 Azure-SSIS IR 上安装 oh22 的 HEDDA.IO 数据质量/清理组件 。If you select the oh22's HEDDA.IO component, you can install the HEDDA.IO data quality/cleansing component from oh22 on your Azure-SSIS IR after purchasing their service. 当前的集成版本是 1.0.13 。The current integrated version is 1.0.13.

      3. 如果选择“oh22 的 SQLPhonetics.NET”组件,可通过在“许可证密钥”字段中输入从 oh22 购买的产品许可证密钥,在 Azure-SSIS IR 上安装 oh22 的 SQLPhonetics.NET 数据质量/匹配组件 。If you select the oh22's SQLPhonetics.NET component, you can install the SQLPhonetics.NET data quality/matching component from oh22 on your Azure-SSIS IR by entering the product license key that you purchased from them in the License key field. 当前的集成版本是 1.0.43 。The current integrated version is 1.0.43.

    添加的快速自定义安装将显示在“高级设置”部分 。Your added express custom setups will appear on the Advanced Settings section. 若要删除它们,可以选中其复选框,然后选择“删除” 。To remove them, you can select their check boxes and then select Delete.

    包含自定义安装的高级设置

    使用 PowerShell 预配或重新配置 Azure-SSIS IR 时,可以在启动 Azure-SSIS IR 之前,运行 Set-AzDataFactoryV2IntegrationRuntime cmdlet 来添加/删除自定义安装。When you provision or reconfigure your Azure-SSIS IR with PowerShell, you can add/remove custom setups by running the Set-AzDataFactoryV2IntegrationRuntime cmdlet before you start your Azure-SSIS IR.

    对于标准自定义安装,可以提供容器的 SAS URI 作为 SetupScriptContainerSasUri 参数的值。For standard custom setups, you can provide the SAS URI of your container as the value for SetupScriptContainerSasUri parameter. 例如:For example:

    Set-AzDataFactoryV2IntegrationRuntime -DataFactoryName $MyDataFactoryName `
                                          -Name $MyAzureSsisIrName `
                                          -ResourceGroupName $MyResourceGroupName `
                                          -SetupScriptContainerSasUri $MySetupScriptContainerSasUri
    
    Start-AzDataFactoryV2IntegrationRuntime -DataFactoryName $MyDataFactoryName `
                                            -Name $MyAzureSsisIrName `
                                            -ResourceGroupName $MyResourceGroupName
    

    完成标准自定义安装并启动 Azure-SSIS IR 之后,可在存储容器的 main.cmd.log 文件夹中找到 main.cmd 的标准输出和其他执行日志。After your standard custom setup finishes and your Azure-SSIS IR starts, you can find the standard output of main.cmd and other execution logs in the main.cmd.log folder of your storage container.

  5. 若要查看标准自定义安装的某些示例,请使用 Azure 存储资源管理器连接到我们的公共预览版容器。To see some samples of standard custom setups, connect to our Public Preview container with Azure Storage Explorer.

    1. 在“(本地和附加)”下面,右键单击“存储帐户”,并依次选择“连接到 Azure 存储”、“使用连接字符串或共享访问签名 URI”、“下一步”。 Under (Local and Attached), right-click Storage Accounts, select Connect to Azure storage, select Use a connection string or a shared access signature URI, and then select Next.

      使用共享访问签名连接到 Azure 存储

    2. 选择“使用 SAS URI”并输入公共预览版容器的以下 SAS URI。 Select Use a SAS URI and enter the following SAS URI for the Public Preview container. 依次选择“下一步”、“连接” 。Select Next, and then select Connect.

      https://ssisazurefileshare.blob.core.chinacloudapi.cn/publicpreview?sp=rl&st=2018-04-08T14%3A10%3A00Z&se=2020-04-10T14%3A10%3A00Z&sv=2017-04-17&sig=mFxBSnaYoIlMmWfxu9iMlgKIvydn85moOnOch6%2F%2BheE%3D&sr=c

      提供容器的共享访问签名

    3. 选择已连接的公共预览版容器,并双击 CustomSetupScript 文件夹。Select the connected Public Preview container and double-click the CustomSetupScript folder. 此文件夹包含以下项:In this folder are the following items:

      1. 一个 Sample 文件夹,其中包含用于在 Azure-SSIS IR 的每个节点上安装基本任务的自定义安装程序。A Sample folder, which contains a custom setup to install a basic task on each node of your Azure-SSIS IR. 该任务不会执行任何操作,而是休眠几秒。The task does nothing but sleep for a few seconds. 该文件夹还包含 gacutil 文件夹,其整个内容(gacutil.exegacutil.exe.config1033\gacutlrc.dll)都可以按原样复制到容器中。The folder also contains a gacutil folder, the whole content of which (gacutil.exe, gacutil.exe.config, and 1033\gacutlrc.dll) can be copied as is into your container.

      2. 一个 UserScenarios 文件夹,其中包含实际用户方案中的多个自定义安装示例。A UserScenarios folder, which contains several custom setup samples from real user scenarios.

      公共预览版容器的内容

    4. 双击 UserScenarios 文件夹以查找以下项:Double-click the UserScenarios folder to find the following items:

      1. 一个 .NET FRAMEWORK 3.5 文件夹,其中包含用于在 Azure-SSIS IR 的每个节点上安装自定义组件可能需要的 .NET Framework 早期版本的自定义安装程序。A .NET FRAMEWORK 3.5 folder, which contains a custom setup to install an earlier version of the .NET Framework that might be required for custom components on each node of your Azure-SSIS IR.

      2. 一个 BCP 文件夹,其中包含用于在 Azure-SSIS IR 的每个节点上安装 SQL Server 命令行实用工具 (MsSqlCmdLnUtils.msi)(包括批量复制程序 (bcp))的自定义安装程序。A BCP folder, which contains a custom setup to install SQL Server command-line utilities (MsSqlCmdLnUtils.msi), including the bulk copy program (bcp), on each node of your Azure-SSIS IR.

      3. 一个 EXCEL 文件夹,其中包含用于安装 C# 程序集/库的自定义安装脚本 (main.cmd),安装后可在“脚本任务”中使用该脚本来动态读取/写入 Azure-SSIS IR 每个节点上的 Excel 文件。An EXCEL folder, which contains a custom setup script (main.cmd) to install C# assemblies/libraries that you can use in Script Tasks to dynamically read/write Excel files on each node of your Azure-SSIS IR. 首先,请在此处下载 ExcelDataReader.dll,并在此处下载 DocumentFormat.OpenXml.dll,然后将它们连同 main.cmd 一起上传到容器中。First, download ExcelDataReader.dll from here and DocumentFormat.OpenXml.dll from here, then upload them all together with main.cmd into your container. 另外,如果只想使用标准的 Excel 连接管理器/源/目标,则所需的 Access 可再发行程序包已预先安装在 Azure-SSIS IR 上,因此无需任何自定义安装。Alternatively, if you just want to use the standard Excel Connection Manager/Source/Destination, the required Access Redistributable is already preinstalled on your Azure-SSIS IR, so you don't need any custom setup.

      4. 一个 MYSQL ODBC 文件夹,其中包含用于在 Azure-SSIS IR 的每个节点上安装 MySQL ODBC 驱动程序的自定义安装脚本 (main.cmd)。A MYSQL ODBC folder, which contains a custom setup script (main.cmd) to install the MySQL ODBC drivers on each node of your Azure-SSIS IR. 通过此安装,可使用 ODBC 连接管理器/源/目标连接到 MySQL 服务器。This setup lets you use the ODBC Connection Manager/Source/Destination to connect to MySQL server. 首先,从 MySQL 下载最新的 64 位和 32 位版本的 MySQL ODBC 驱动程序安装程序(例如 mysql-connector-odbc-8.0.13-winx64.msimysql-connector-odbc-8.0.13-win32.msi),然后将它们连同 main.cmd 一起上传到容器中。First, download the latest 64-bit and 32-bit versions of MySQL ODBC driver installers - for example, mysql-connector-odbc-8.0.13-winx64.msi and mysql-connector-odbc-8.0.13-win32.msi - from MySQL, then upload them all together with main.cmd into your container.

      5. 一个 ORACLE ENTERPRISE 文件夹,其中包含用于在 Azure-SSIS IR 企业版的每个节点上安装 Oracle 连接器和 OCI 驱动程序的自定义安装脚本 (main.cmd) 和无提示安装配置文件 (client.rsp)。An ORACLE ENTERPRISE folder, which contains a custom setup script (main.cmd) and silent install config file (client.rsp) to install the Oracle connectors and OCI driver on each node of your Azure-SSIS IR Enterprise Edition. 通过此安装程序,可使用 Oracle 连接管理器/源/目标连接到 Oracle 服务器。This setup lets you use the Oracle Connection Manager/Source/Destination to connect to Oracle server. 首先,从 Microsoft 下载中心下载适用于 Oracle 的 Microsoft 连接器 v5.0 (AttunitySSISOraAdaptersSetup.msiAttunitySSISOraAdaptersSetup64.msi),并从 Oracle 下载最新的 Oracle 客户端,例如 winx64_12102_client.zip,然后将它们连同 main.cmdclient.rsp 一起上传到你的容器中。First, download Microsoft Connectors v5.0 for Oracle (AttunitySSISOraAdaptersSetup.msi and AttunitySSISOraAdaptersSetup64.msi) from Microsoft Download Center and the latest Oracle client - for example, winx64_12102_client.zip - from Oracle, then upload them all together with main.cmd and client.rsp into your container. 如果使用 TNS 连接到 Oracle,则还需要下载 tnsnames.ora,对其进行编辑,然后将其上传到容器,以便在安装期间将其复制到 Oracle 安装文件夹中。If you use TNS to connect to Oracle, you also need to download tnsnames.ora, edit it, and upload it into your container, so it can be copied into the Oracle installation folder during setup.

      6. 一个 ORACLE STANDARD ADO.NET 文件夹,其中包含用于在 Azure-SSIS IR 的每个节点上安装 Oracle ODP.NET 驱动程序的自定义安装脚本 (main.cmd)。An ORACLE STANDARD ADO.NET folder, which contains a custom setup script (main.cmd) to install the Oracle ODP.NET driver on each node of your Azure-SSIS IR. 通过此安装程序,可使用 ADO.NET 连接管理器/源/目标连接到 Oracle 服务器。This setup lets you use the ADO.NET Connection Manager/Source/Destination to connect to Oracle server. 首先,从 Oracle 下载最新的 Oracle ODP.NET 驱动程序(例如 ODP.NET_Managed_ODAC122cR1.zip),然后将其与 main.cmd 一起上传到容器中。First, download the latest Oracle ODP.NET driver - for example, ODP.NET_Managed_ODAC122cR1.zip - from Oracle, then upload it together with main.cmd into your container.

      7. 一个 ORACLE STANDARD ODBC 文件夹,其中包含用于在 Azure-SSIS IR 的每个节点上安装 Oracle ODBC 驱动程序并配置 DSN 的自定义安装脚本 (main.cmd)。An ORACLE STANDARD ODBC folder, which contains a custom setup script (main.cmd) to install the Oracle ODBC driver and configure DSN on each node of your Azure-SSIS IR. 此安装程序允许你使用 ODBC 连接管理器/源/目标或 Power Query 连接管理器/源以及 ODBC 数据源种类来连接到 Oracle 服务器。This setup lets you use the ODBC Connection Manager/Source/Destination or Power Query Connection Manager/Source with ODBC data source kind to connect to Oracle server. 首先,下载最新的 Oracle Instant Client(基本包或基本精简包)和 ODBC 包 - 例如,从此处下载 64 位包(基本包:instantclient-basic-windows.x64-18.3.0.0.0dbru.zip,基本精简包:instantclient-basiclite-windows.x64-18.3.0.0.0dbru.zip,ODBC 包:instantclient-odbc-windows.x64-18.3.0.0.0dbru.zip)或者从此处下载 32 位包(基本包:instantclient-basic-nt-18.3.0.0.0dbru.zip,基本精简包:instantclient-basiclite-nt-18.3.0.0.0dbru.zip,ODBC 包:instantclient-odbc-nt-18.3.0.0.0dbru.zip),然后将它们连同 main.cmd 一起上传到容器中。First, download the latest Oracle Instant Client (Basic Package or Basic Lite Package) and ODBC Package - for example, the 64-bit packages from here (Basic Package: instantclient-basic-windows.x64-18.3.0.0.0dbru.zip, Basic Lite Package: instantclient-basiclite-windows.x64-18.3.0.0.0dbru.zip, ODBC Package: instantclient-odbc-windows.x64-18.3.0.0.0dbru.zip) or the 32-bit packages from here (Basic Package: instantclient-basic-nt-18.3.0.0.0dbru.zip, Basic Lite Package: instantclient-basiclite-nt-18.3.0.0.0dbru.zip, ODBC Package: instantclient-odbc-nt-18.3.0.0.0dbru.zip), then upload them all together with main.cmd into your container.

      8. 一个 ORACLE STANDARD OLEDB 文件夹,其中包含用于在 Azure-SSIS IR 的每个节点上安装 Oracle OLEDB 驱动程序的自定义安装脚本 (main.cmd)。An ORACLE STANDARD OLEDB folder, which contains a custom setup script (main.cmd) to install the Oracle OLEDB driver on each node of your Azure-SSIS IR. 通过此安装程序,可使用 OLEDB 连接管理器/源/目标连接到 Oracle 服务器。This setup lets you use the OLEDB Connection Manager/Source/Destination to connect to Oracle server. 首先,从 Oracle 下载最新的 Oracle OLEDB 驱动程序(例如 ODAC122010Xcopy_x64.zip),然后将其与 main.cmd 一起上传到容器中。First, download the latest Oracle OLEDB driver - for example, ODAC122010Xcopy_x64.zip - from Oracle, then upload it together with main.cmd into your container.

      9. 一个 POSTGRESQL ODBC 文件夹,其中包含用于在 Azure-SSIS IR 的每个节点上安装 PostgreSQL ODBC 驱动程序的自定义安装脚本 (main.cmd)。A POSTGRESQL ODBC folder, which contains a custom setup script (main.cmd) to install the PostgreSQL ODBC drivers on each node of your Azure-SSIS IR. 通过此安装,可使用 ODBC 连接管理器/源/目标连接到 PostgreSQL 服务器。This setup lets you use the ODBC Connection Manager/Source/Destination to connect to PostgreSQL server. 首先,从 PostgreSQL 下载最新的 64 位和 32 位版本的 PostgreSQL ODBC 驱动程序安装程序(例如 psqlodbc_x64.msipsqlodbc_x86.msi),然后将它们连同 main.cmd 一起上传到容器中。First, download the latest 64-bit and 32-bit versions of PostgreSQL ODBC driver installers - for example, psqlodbc_x64.msi and psqlodbc_x86.msi - from PostgreSQL, then upload them all together with main.cmd into your container.

      10. 一个 SAP BW 文件夹,其中包含用于在 Azure-SSIS IR 企业版的每个节点上安装 SAP .NET 连接器程序集 (librfc32.dll) 的自定义安装脚本 (main.cmd)。A SAP BW folder, which contains a custom setup script (main.cmd) to install the SAP .NET connector assembly (librfc32.dll) on each node of your Azure-SSIS IR Enterprise Edition. 通过此安装程序,可使用 SAP BW 连接管理器/源/目标连接到 SAP BW 服务器。This setup lets you use the SAP BW Connection Manager/Source/Destination to connect to SAP BW server. 首先,将 64 位或 32 位版本的 librfc32.dll 连同 main.cmd 一起从 SAP 安装文件夹上传到容器中。First, upload the 64-bit or the 32-bit version of librfc32.dll from the SAP installation folder together with main.cmd into your container. 然后,该脚本会在安装期间将 SAP 程序集复制到 %windir%\SysWow64%windir%\System32 文件夹中。The script then copies the SAP assembly into the %windir%\SysWow64 or %windir%\System32 folder during setup.

      11. 一个 STORAGE 文件夹,其中包含用于在 Azure-SSIS IR 的每个节点上安装 Azure PowerShell 的自定义安装程序。A STORAGE folder, which contains a custom setup to install Azure PowerShell on each node of your Azure-SSIS IR. 此安装程序允许部署并运行 SSIS 包,以便运行 PowerShell 脚本来操作 Azure 存储帐户This setup lets you deploy and run SSIS packages that run PowerShell scripts to manipulate your Azure Storage account. main.cmd、示例 AzurePowerShell.msi(或使用最新版本)和 storage.ps1 复制到容器。Copy main.cmd, a sample AzurePowerShell.msi (or use the latest version), and storage.ps1 to your container. 使用 PowerShell.dtsx 作为包的模板。Use PowerShell.dtsx as a template for your packages. 包模板中合并了 Azure Blob 下载任务(包括可修改 PowerShell 脚本形式的 storage.ps1)和执行进程任务(在每个节点上执行脚本)。The package template combines an Azure Blob Download Task, which downloads storage.ps1 as a modifiable PowerShell script, and an Execute Process Task that executes the script on each node.

      12. 一个 TERADATA 文件夹,其中包含自定义安装脚本 (main.cmd)、其关联的文件 (install.cmd) 和安装程序包 (.msi)。A TERADATA folder, which contains a custom setup script (main.cmd), its associated file (install.cmd), and installer packages (.msi). 这些文件将在 Azure-SSIS IR 企业版的每个节点上安装 Teradata 连接器、TPT API 和 ODBC 驱动程序。These files install the Teradata connectors, TPT API, and ODBC driver on each node of your Azure-SSIS IR Enterprise Edition. 通过此安装程序,可使用 Teradata 连接管理器/源/目标连接到 Teradata 服务器。This setup lets you use the Teradata Connection Manager/Source/Destination to connect to Teradata server. 首先,从 Teradata 下载 Teradata 工具和实用工具 15.x zip 文件(例如 TeradataToolsAndUtilitiesBase__windows_indep.15.10.22.00.zip),然后将其连同上述 .cmd.msi 文件一起上传到容器中。First, download the Teradata Tools and Utilities 15.x zip file (for example, TeradataToolsAndUtilitiesBase__windows_indep.15.10.22.00.zip) from Teradata, then upload it together with the above .cmd and .msi files into your container.

      13. 一个 ZULU OPENJDK 文件夹,其中包含用于在 Azure-SSIS IR 的每个节点上安装 Zulu OpenJDK 的自定义安装脚本 (main.cmd) 和 PowerShell 文件 (install_openjdk.ps1)。A ZULU OPENJDK folder, which contains a custom setup script (main.cmd) and PowerShell file (install_openjdk.ps1) to install Zulu OpenJDK on each node of your Azure-SSIS IR. 借助此安装,可使用 Azure Data Lake Store/Flexible File 连接器来处理 ORC/Parquet 文件,有关详细信息,请参阅此处This setup lets you use Azure Data Lake Store/Flexible File connectors to process ORC/Parquet files, see here for more info. 首先,在此处下载最新的 Zulu OpenJDK(例如 zulu8.33.0.1-jdk8.0.192-win_x64.zip),然后将其与 main.cmdinstall_openjdk.ps1 一起上传到容器中。First, download the latest Zulu OpenJDK - for example, zulu8.33.0.1-jdk8.0.192-win_x64.zip - from here, then upload it together with main.cmd and install_openjdk.ps1 into your container.

      用户方案文件夹中的文件夹

    5. 若要试用这些自定义安装示例,请将选定文件夹中的内容复制并粘贴到容器中。To try these custom setup samples, copy and paste the content from selected folder into your container.

      使用数据工厂 UI 预配或重新配置 Azure-SSIS IR 时,可以在“高级设置”部分上选择“使用其他系统配置/组件安装来自定义 Azure-SSIS Integration Runtime”复选框并在“自定义安装容器 SAS URI”字段中输入容器的 SAS URI 。When you provision or reconfigure your Azure-SSIS IR with Data Factory UI, select the Customize your Azure-SSIS Integration Runtime with additional system configurations/component installations check box on the Advanced Settings section and enter the SAS URI of your container in the Custom setup container SAS URI field.

      使用 PowerShell 预配或重新配置 Azure-SSIS IR 时,请运行 Set-AzDataFactoryV2IntegrationRuntime cmdlet 并指定容器的 SAS URI 作为 SetupScriptContainerSasUri 参数的值。When you provision or reconfigure your Azure-SSIS IR with PowerShell, run the Set-AzDataFactoryV2IntegrationRuntime cmdlet with the SAS URI of your container as the value for SetupScriptContainerSasUri parameter.

后续步骤Next steps