预配 Azure-SSIS 集成运行时企业版Provision Enterprise Edition for the Azure-SSIS Integration Runtime

适用于: Azure 数据工厂 Azure Synapse Analytics

在 Azure-SSIS 集成运行时企业版中可以使用以下高级功能:The Enterprise Edition of the Azure-SSIS Integration Runtime lets you use the following advanced and premium features:

  • 变更数据捕获 (CDC) 组件Change Data Capture (CDC) components
  • Oracle、Teradata 和 SAP BW 连接器Oracle, Teradata, and SAP BW connectors
  • SQL Server Analysis Services (SSAS) 和 Azure Analysis Services (AAS) 连接器和转换SQL Server Analysis Services (SSAS) and Azure Analysis Services (AAS) connectors and transformations
  • 模糊分组和模糊查找转换Fuzzy Grouping and Fuzzy Lookup transformations
  • 字词提取和字词查找转换Term Extraction and Term Lookup transformations

上述某些功能需要安装附加的组件来自定义 Azure-SSIS IR。Some of these features require you to install additional components to customize the Azure-SSIS IR. 有关如何安装附加组件的详细信息,请参阅 Azure-SSIS 集成运行时的自定义安装For more info about how to install additional components, see Custom setup for the Azure-SSIS integration runtime.

企业功能Enterprise features

企业功能Enterprise Features 说明Descriptions
CDC 组件CDC components CDC 源、控制任务和拆分器转换已预装在 Azure-SSIS IR 企业版上。The CDC Source, Control Task, and Splitter Transformation are preinstalled on the Azure-SSIS IR Enterprise Edition. 若要连接到 Oracle,还需要在另一台计算机上安装 CDC 设计器和服务。To connect to Oracle, you also need to install the CDC Designer and Service on another computer.
Oracle 连接器Oracle connectors Oracle 连接管理器、源和目标已预装在 Azure-SSIS IR 企业版上。The Oracle Connection Manager, Source, and Destination are preinstalled on the Azure-SSIS IR Enterprise Edition. 还需要在 Azure-SSIS IR 上安装 Oracle 调用接口 (OCI) 驱动程序,并在必要时配置 Oracle 传输网络底层 (TNS)。You also need to install the Oracle Call Interface (OCI) driver, and if necessary configure the Oracle Transport Network Substrate (TNS), on the Azure-SSIS IR. 有关详细信息,请参阅 Azure-SSIS 集成运行时的自定义设置For more info, see Custom setup for the Azure-SSIS integration runtime.
Teradata 连接器Teradata connectors 需要在 Azure-SSIS IR 企业版上安装 Teradata 连接管理器、源、目标,以及 Teradata 并行传输程序 (TPT) API 和 Teradata ODBC 驱动程序。You need to install the Teradata Connection Manager, Source, and Destination, as well as the Teradata Parallel Transporter (TPT) API and Teradata ODBC driver, on the Azure-SSIS IR Enterprise Edition. 有关详细信息,请参阅 Azure-SSIS 集成运行时的自定义设置For more info, see Custom setup for the Azure-SSIS integration runtime.
SAP BW 连接器SAP BW connectors SAP BW 连接管理器、源和目标已预装在 Azure-SSIS IR 企业版上。The SAP BW Connection Manager, Source, and Destination are preinstalled on the Azure-SSIS IR Enterprise Edition. 还需要在 Azure-SSIS IR 上安装 SAP BW 驱动程序。You also need to install the SAP BW driver on the Azure-SSIS IR. 这些连接器支持 SAP BW 7.0 或更低版本。These connectors support SAP BW 7.0 or earlier versions. 若要连接到更高版本的 SAP BW 或其他 SAP 产品,可以从第三方 ISV 购买 SAP 连接器并将其安装在 Azure-SSIS IR 上。To connect to later versions of SAP BW or other SAP products, you can purchase and install SAP connectors from third-party ISVs on the Azure-SSIS IR. 有关如何安装附加组件的详细信息,请参阅 Azure-SSIS 集成运行时的自定义安装For more info about how to install additional components, see Custom setup for the Azure-SSIS integration runtime.
Analysis Services 组件Analysis Services components 数据挖掘模型定型目标、维度处理目标、分区处理目标以及数据挖掘查询转换已预装在 Azure-SSIS IR 企业版上。The Data Mining Model Training Destination, the Dimension Processing Destination, and the Partition Processing Destination, as well as the Data Mining Query Transformation, are preinstalled on the Azure-SSIS IR Enterprise Edition. 所有这些组件支持 SQL Server Analysis Services (SSAS),但只有分区处理目标支持 Azure Analysis Services (AAS)。All these components support SQL Server Analysis Services (SSAS), but only the Partition Processing Destination supports Azure Analysis Services (AAS). 若要连接到 SSAS,还需要在 SSISDB 中配置 Windows 身份验证凭据To connect to SSAS, you also need to configure Windows Authentication credentials in SSISDB. 除了这些组件以外,Analysis Services 执行 DDL 任务、Analysis Services 处理任务和数据挖掘查询任务也已预装在 Azure-SSIS IR 标准/企业版上。In addition to these components, the Analysis Services Execute DDL Task, the Analysis Services Processing Task, and the Data Mining Query Task are also preinstalled on the Azure-SSIS IR Standard/Enterprise Edition.
模糊分组和模糊查找转换Fuzzy Grouping and Fuzzy Lookup transformations 模糊分组和模糊查找转换已预装在 Azure-SSIS IR 企业版上。The Fuzzy Grouping and Fuzzy Lookup transformations are preinstalled on the Azure-SSIS IR Enterprise Edition. 这些组件支持使用 SQL Server 和 Azure SQL 数据库来存储参考数据。These components support both SQL Server and Azure SQL Database for storing reference data.
字词提取和字词查找转换Term Extraction and Term Lookup transformations 字词提取和字词查找转换已预装在 Azure-SSIS IR 企业版上。The Term Extraction and Term Lookup transformations are preinstalled on the Azure-SSIS IR Enterprise Edition. 这些组件支持使用 SQL Server 和 Azure SQL 数据库来存储参考数据。These components support both SQL Server and Azure SQL Database for storing reference data.

InstructionsInstructions

备注

本文进行了更新,以便使用新的 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.

  1. 下载和安装 Azure PowerShellDownload and install Azure PowerShell.

  2. 使用 PowerShell 预配或重新配置 Azure-SSIS IR 时,请在启动 Azure-SSIS IR 之前,先运行 Set-AzDataFactoryV2IntegrationRuntime 并指定 Enterprise 作为 Edition 参数的值。When you provision or reconfigure the Azure-SSIS IR with PowerShell, run Set-AzDataFactoryV2IntegrationRuntime with Enterprise as the value for the Edition parameter before you start the Azure-SSIS IR. 下面是一个示例脚本:Here is a sample script:

    $MyAzureSsisIrEdition = "Enterprise"
    
    Set-AzDataFactoryV2IntegrationRuntime -DataFactoryName $MyDataFactoryName
                                               -Name $MyAzureSsisIrName
                                               -ResourceGroupName $MyResourceGroupName
                                               -Edition $MyAzureSsisIrEdition
    
    Start-AzDataFactoryV2IntegrationRuntime -DataFactoryName $MyDataFactoryName
                                                 -Name $MyAzureSsisIrName
                                                 -ResourceGroupName $MyResourceGroupName
    

后续步骤Next steps