Azure-SSIS Integration Runtime 上内置和预安装的组件Built-in and preinstalled components on Azure-SSIS Integration Runtime

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

本文列出了 Azure 数据工厂 (ADF) 中 Azure-SSIS Integration Runtime 上的所有内置和预安装组件,例如客户端、驱动程序、提供程序、连接管理器、数据源/目标/转换以及任务。This article lists all built-in and preinstalled components, such as clients, drivers, providers, connection managers, data sources/destinations/transformations, and tasks on SSIS Integration Runtime (IR) in Azure Data Factory (ADF). 若要在 ADF 中预配 SSIS IR,请按照预配 Azure-SSIS IR 中的说明操作。To provision SSIS IR in ADF, follow the instructions in Provision Azure-SSIS IR.

Azure-SSIS IR 上内置和预安装的客户端、驱动程序和提供程序Built-in and preinstalled clients, drivers, and providers on Azure-SSIS IR

类型Type 名称 - 版本 - 平台Name - Version - Platform
内置的客户端/驱动程序/提供程序Built-in clients/drivers/providers Access 数据库引擎 2016 可再发行组件 - RTM - X64Access Database Engine 2016 Redistributable - RTM - X64

Microsoft 分析管理对象 - 15.0.1000.81 - X64Microsoft Analysis Management Objects - 15.0.1000.81 - X64

Microsoft Analysis Services OLE DB 提供程序 - 15.0.1000.81 - X64Microsoft Analysis Services OLEDB Provider - 15.0.1000.81 - X64

Microsoft SQL Server 2012 本机客户端 - 11.4.7462.6 - X64Microsoft SQL Server 2012 Native Client - 11.4.7462.6 - X64

Microsoft ODBC Driver 13 for SQL Server - 14.0.900.902 - X64Microsoft ODBC Driver 13 for SQL Server - 14.0.900.902 - X64

Microsoft OLEDB Driver 18 for SQL Server - 18.1.0.0 - X64Microsoft OLEDB Driver 18 for SQL Server - 18.1.0.0 - X64

Microsoft OLEDB Provider for DB2 - 6.0 - X64Microsoft OLEDB Provider for DB2 - 6.0 - X64

SharePoint Online 客户端组件 SDK - 15.4711.1001 - X64SharePoint Online Client Components SDK - 15.4711.1001 - X64

Azure-SSIS IR 上内置和预安装的组件Built-in and preinstalled connection managers on Azure-SSIS IR

类型Type 名称Name
内置连接管理器Built-in connection managers ADO 连接管理器ADO Connection Manager

ADO.NET 连接管理器ADO.NET Connection Manager

Analysis Services 连接管理器Analysis Services Connection Manager

Excel 连接管理器Excel Connection Manager

文件连接管理器File Connection Manager

平面文件连接管理器Flat File Connection Manager

FTP 连接管理器FTP Connection Manager

Hadoop 连接管理器Hadoop Connection Manager

HTTP 连接管理器HTTP Connection Manager

MSMQ 连接管理器MSMQ Connection Manager

多文件连接管理器Multiple Files Connection Manager

多平面文件连接管理器Multiple Flat Files Connection Manager

ODBC 连接管理器ODBC Connection Manager

OLEDB 连接管理器OLEDB Connection Manager

SAP BW 连接管理器 (Enterprise Edition)SAP BW Connection Manager (Enterprise Edition)

SMO 连接管理器SMO Connection Manager

SMTP 连接管理器SMTP Connection Manager

SQL Server Compact Edition 连接管理器SQL Server Compact Edition Connection Manager

WMI 连接管理器WMI Connection Manager
预安装的连接管理器( Azure 功能包Preinstalled connection managers (Azure Feature Pack) Azure HDInsight 连接管理器Azure HDInsight Connection Manager

Azure 资源管理器连接管理器Azure Resource Manager Connection Manager

Azure 存储连接管理器Azure Storage Connection Manager

Azure 订阅连接管理器Azure Subscription Connection Manager

Azure-SSIS IR 上内置和预安装的数据源Built-in and preinstalled data sources on Azure-SSIS IR

类型Type 名称Name
内置数据源Built-in data sources ADO.NET 源ADO.NET Source

CDC 源 (Enterprise Edition)CDC Source (Enterprise Edition)

Excel 源Excel Source

平面文件源Flat File Source

HDFS 文件源HDFS File Source

OData 源OData Source

ODBC 源ODBC Source

OLEDB 源OLEDB Source

原始文件源Raw File Source

SAP BW 源 (Enterprise Edition)SAP BW Source (Enterprise Edition)

XML 源XML Source
预安装的数据源( Azure 功能包 + Power Query 源Preinstalled data sources (Azure Feature Pack + Power Query Source) Azure Blob 源Azure Blob Source

灵活的文件源Flexible File Source

Power Query 源Power Query Source

Azure-SSIS IR 上内置和预安装的数据目标Built-in and preinstalled data destinations on Azure-SSIS IR

类型Type 名称Name
内置的数据目标Built-in data destinations ADO.NET 目标ADO.NET Destination

数据挖掘模型定型目标 (Enterprise Edition)Data Mining Model Training Destination (Enterprise Edition)

DataReader 目标DataReader Destination

数据流目标Data Streaming Destination

维度处理目标 (Enterprise Edition)Dimension Processing Destination (Enterprise Edition)

Excel 目标Excel Destination

平面文件目标Flat File Destination

HDFS 文件目标HDFS File Destination

ODBC 目标ODBC Destination

OLEDB 目标OLEDB Destination

分区处理目标 (Enterprise Edition)Partition Processing Destination (Enterprise Edition)

原始文件目标Raw File Destination

记录集目标Recordset Destination

SAP BW 目标 (Enterprise Edition)SAP BW Destination (Enterprise Edition)

SQL Server Compact Edition 目标SQL Server Compact Edition Destination

SQL Server 目标SQL Server Destination
预安装的数据目标( Azure 功能包Preinstalled data destinations (Azure Feature Pack) Azure Blob 目标Azure Blob Destination

灵活的文件目标Flexible File Destination

Azure-SSIS IR 上内置和预安装的数据转换Built-in and preinstalled data transformations on Azure-SSIS IR

类型Type 名称Name
内置审核转换Built-in auditing transformations 审核转换Audit Transformation

行计数转换Row Count Transformation
内置 BI 转换Built-in BI transformations 数据挖掘查询转换 (Enterprise Edition)Data Mining Query Transformation (Enterprise Edition)

DQS 清理转换DQS Cleansing Transformation

模糊分组转换 (Enterprise Edition)Fuzzy Grouping Transformation (Enterprise Edition)

模糊查找转换 (Enterprise Edition)Fuzzy Lookup Transformation (Enterprise Edition)

字词提取转换 (Enterprise Edition)Term Extraction Transformation (Enterprise Edition)

字词查找转换 (Enterprise Edition)Term Lookup Transformation (Enterprise Edition)
内置的行转换Built-in row transformations 字符映射转换Character Map Transformation

复制列转换Copy Column Transformation

数据转换Data Conversion Transformation

派生列转换Derived Column Transformation

导出列转换Export Column Transformation

导入列转换Import Column Transformation

OLE DB 命令转换OLE DB Command Transformation

脚本组件Script Component
内置的行集转换Built-in rowset transformations 聚合转换Aggregate Transformation

百分比抽样转换Percentage Sampling Transformation

透视转换Pivot Transformation

行抽样转换Row Sampling Transformation

排序转换Sort Transformation

逆透视转换Unpivot Transformation
内置的拆分和联接转换Built-in split and join transformations 平衡数据分发器转换Balanced Data Distributor Transformation

缓存转换Cache Transform

CDC 拆分器 (Enterprise Edition)CDC Splitter (Enterprise Edition)

有条件拆分转换Conditional Split Transformation

查找转换Lookup Transformation

合并联接转换Merge Join Transformation

合并转换Merge Transformation

多播转换Multicast Transformation

渐变维度转换Slowly Changing Dimension Transformation

Union All 转换Union All Transformation

Azure-SSIS IR 上内置和预安装的任务Built-in and preinstalled tasks on Azure-SSIS IR

类型Type 名称Name
内置的 Analysis Services 任务Built-in Analysis Services tasks Analysis Services 执行 DDL 任务Analysis Services Execute DDL Task

Analysis Services 处理任务Analysis Services Processing Task

数据挖掘查询任务Data Mining Query Task
内置的数据流任务Built-in data flow tasks 数据流任务Data Flow Task
内置的数据准备任务Built-in data preparation tasks CDC 控制任务 (Enterprise Edition)CDC Control Task (Enterprise Edition)

“检查数据库完整性”任务Check Database Integrity Task

数据事件探查任务Data Profiling Task

文件系统任务File System Task

FTP 任务FTP Task

Hadoop 文件系统任务Hadoop File System Task

Hadoop Hive 任务Hadoop Hive Task

Hadoop Pig 任务Hadoop Pig Task

Web 服务任务Web Service Task

XML 任务XML Task
内置的维护任务Built-in maintenance tasks 备份数据库任务Back Up Database Task

执行 T-SQL 语句任务Execute T-SQL Statement Task

“清除历史记录”任务History Cleanup Task

“清除维护”任务Maintenance Cleanup Task

“通知操作员”任务Notify Operator Task

“重新生成索引”任务Rebuild Index Task

“重新组织索引”任务Reorganize Index Task

选择要传输的对象Select Objects to Transfer

收缩数据库任务Shrink Database Task

传输数据库任务Transfer Database Task

传输错误消息任务Transfer Error Messages Task

传输作业任务Transfer Jobs Task

传输登录名任务Transfer Logins Task

传输主存储过程任务Transfer Master Stored Procedures Task

传输 SQL Server 对象任务Transfer SQL Server Objects Task

“更新统计信息”任务Update Statistics Task
内置的脚本任务Built-in scripting tasks 脚本任务Script Task
内置的 SQL Server 任务Built-in SQL Server tasks 大容量插入任务Bulk Insert Task

执行 SQL 任务Execute SQL Task
内置的工作流任务Built-in workflow tasks 执行包任务Execute Package Task

执行进程任务Execute Process Task

“执行 SQL Server 代理作业”任务Execute SQL Server Agent Job Task

表达式任务Expression Task

消息队列任务Message Queue Task

发送邮件任务Send Mail Task

WMI 数据读取器任务WMI Data Reader Task

WMI 事件观察器任务WMI Event Watcher Task
预安装的任务( Azure 功能包Preinstalled tasks (Azure Feature Pack) Azure Blob 下载任务Azure Blob Download Task

Azure blob 上传任务Azure Blob Upload Task

Azure Data Lake Store 文件系统任务Azure Data Lake Store File System Task

Azure HDInsight 创建群集任务Azure HDInsight Create Cluster Task

Azure HDInsight 删除群集任务Azure HDInsight Delete Cluster Task

Azure HDInsight Hive 任务Azure HDInsight Hive Task

Azure HDInsight Pig 任务Azure HDInsight Pig Task

Azure SQL Azure Synapse Analytics 上传任务Azure SQL Azure Synapse Analytics Upload Task

灵活的文件任务Flexible File Task

后续步骤Next steps

若要在 SSIS IR 上安装其他自定义/开放源代码/第三方组件,请按照自定义 Azure-SSIS IR中的说明操作。To install additional custom/Open Source/3rd party components on your SSIS IR, follow the instructions in Customize Azure-SSIS IR.