Data Factory 通过内置连接器连接多种类型的数据存储。 这些连接器可帮助你使用 Gen2 数据流、管道或复制作业来引入或转换数据。 选择需要开始使用的连接器。
Prerequisites
在设置连接之前,请确保具备:
Fabric 中支持的连接器
Fabric 在数据流 Gen2、管道和复制作业中支持这些连接器。 选择一个数据存储以看看它的功能以及如何设置。
小窍门
有关更详细的复制作业功能可用性,请参阅 复制作业的连接器支持的功能。
| Connector | Dataflow Gen2 (源/目标) | 管道 (复制活动源/目标) | 复制作业 (源/目标) |
|---|---|---|---|
| Access | ✓/− | ||
| Acterys:模型自动化和规划(Beta 版) | ✓/− | ||
| Actian (Beta) | ✓/− | ||
| Active Directory | ✓/− | ||
| Adobe Analytics | ✓/− | ||
| ADPAnalytics(测试版) | ✓/− | ||
| Amazon Athena | ✓/− | ||
| Amazon OpenSearch 服务(测试版) | ✓/− | ||
| 适用于 Oracle 的 Amazon RDS | ✓/− | ✓/− | |
| SQL Server 版 Amazon RDS | ✓/− | ✓/− | |
| Amazon Redshift | ✓/− | ✓/− | |
| Amazon S3 | ✓/✓(预览) | ✓/✓ | ✓/✓ |
| 兼容 Amazon S3 | ✓/✓ | ✓/✓ | |
| Anaplan | ✓/− | ||
| Asana | ✓/− | ||
| 组合视图 | ✓/− | ||
| AtScale 多维数据集 | ✓/− | ||
| Autodesk Construction Cloud | ✓/− | ||
| 自动化无处不在 | ✓/− | ||
| Automy Analytics | ✓/− | ||
| Azure AI 搜索 | −/✓ | −/✓ | |
| Azure Analysis Services | ✓/− | ||
| Azure Blobs | ✓/− | ✓/✓ | ✓/✓ |
| Azure Cosmos DB for MongoDB | ✓/✓ | ✓/✓ | |
| Azure Cosmos DB for MongoDB vCore (Beta) | ✓/− | ||
| Azure Cosmos DB v2 | ✓/− | ✓/✓ | ✓/✓ |
| Azure 成本管理 | ✓/− | ||
| Azure 数据资源管理器 (Kusto) | ✓/✓ | ✓/✓ | ✓/✓ |
| Azure Data Lake Storage Gen2 | ✓/− | ✓/✓ | ✓/✓ |
| Azure Database for MySQL | ✓/✓ | ✓/✓ | |
| Azure Database for PostgreSQL | ✓/- | ✓/✓ | ✓/✓ |
| Azure Databricks | ✓/− | ✓/✓ | |
| Azure 文件共享 | ✓/✓ | ✓/✓ | |
| Azure HDInsight (HDFS) | ✓/− | ||
| Azure HDInsight Spark | ✓/- | ||
| Azure HorizonDB Database | ✓/- | ||
| Azure Resource Graph | ✓/− | ||
| Azure SQL 数据库 | ✓/✓ | ✓/✓ | ✓/✓ |
| Azure SQL 托管实例 | ✓/✓ | ✓/✓ | |
| Azure Synapse Analytics (SQL DW) | ✓/- | ✓/✓ | ✓/✓ |
| Azure Synapse Analytics 工作区(Beta) | ✓/− | ||
| Azure Tables | ✓/− | ✓/✓ | ✓/- |
| BI 连接器 | ✓/− | ||
| BitSight 安全评级 | ✓/− | ||
| Bloomberg Data and Analytics | ✓/− | ||
| BQE CORE | ✓/− | ||
| BuildingConnected 与 Trade Tapp | ✓/− | ||
| Cassandra | ✓/− | ✓/− | |
| CData Connect Cloud | ✓/− | ||
| Celonis EMS | ✓/− | ||
| 切尔威尔 (Beta) | ✓/− | ||
| ClickHouse | ✓/− | ||
| CloudBluePSA(测试版) | ✓/− | ||
| Cognite Data Fusion (OData) | ✓/− | ||
| Cognite Data Fusion(Rest API)(测试版) | ✓/− | ||
| 通用数据服务(遗留) | ✓/− | ||
| 数据虚拟化 LDW | ✓/− | ||
| Databricks | ✓/− | ||
| 数据流 | ✓/− | ||
| Dataverse | ✓/− | ✓/✓ | ✓/✓ |
| Delta共享 | ✓/− | ||
| Denodo | ✓/− | ||
| 德雷米欧云 | ✓/− | ||
| Dremio 软件 | ✓/− | ||
| Dynamics 365 Business Central | ✓/− | ||
| Dynamics 365 Customer Insights (Beta) | ✓/− | ||
| Dynamics 365 | ✓/✓ | ✓/✓ | |
| Dynamics AX | ✓/− | ✓/− | |
| Dynamics CRM | ✓/✓ | ✓/✓ | |
| Dynatrace Grail DQL(测试版) | ✓/− | ||
| Eduframe(测试版) | ✓/− | ||
| Emigo 数据源 | ✓/− | ||
| Entersoft 商务套件 | ✓/− | ||
| EQuIS | ✓/− | ||
| eWay-CRM | ✓/− | ||
| Exact Online Premium(测试版) | ✓/− | ||
| Exasol | ✓/− | ||
| Excel 工作簿 | ✓/− | ||
| Fabric Data Warehouse | ✓/✓ | ✓/✓ | ✓/✓ |
| Fabric 中的 KQL 数据库 | ✓/✓ | ✓/✓ | |
| Fabric 中的湖畔小屋 | ✓/✓ | ✓/✓ | ✓/✓ |
| Fabric 中的 SQL 数据库(测试版) | ✓/✓ | ✓/✓ | ✓/✓ |
| FactSet 分析平台 | ✓/− | ||
| FactSet RMS (Beta) | ✓/− | ||
| FHIR | ✓/− | ||
| 文件夹 | ✓/− | ✓/✓ | ✓/✓ |
| FTP | ✓/− | ✓/− | |
| 漏斗 | ✓/− | ||
| Google Analytics | ✓/− | ||
| Google BigQuery | ✓/✓(预览中的目的地) | ✓/✓ | ✓/✓ |
| Google BigQuery(Microsoft Entra ID) | ✓/− | ||
| 谷歌云存储 | ✓/✓ | ✓/✓ | |
| Google 表格 | ✓/− | ||
| Greenplum 用于管道 | ✓/− | ✓/− | |
| HDFS (Hadoop 分布式文件系统) | ✓/− | ✓/− | |
| HDInsight 交互式查询 | ✓/− | ||
| 六边形 PPM 智能 API | ✓/− | ||
| 蜂巢LLAP | ✓/− | ||
| HTTP | ✓/− | ✓/− | |
| IBM Db2 数据库 | ✓/− | ✓/− | ✓/− |
| IBM Netezza | ✓/− | ||
| Impala | ✓/− | ||
| Informix 适用于管道 | ✓/✓ | ✓/✓ | |
| Indexima | ✓/− | ||
| 工业应用商店 | ✓/− | ||
| InformationGrid | ✓/− | ||
| InterSystems 健康洞察 | ✓/− | ||
| Intune 数据仓库(Beta 版) | ✓/− | ||
| inwink(测试版) | ✓/− | ||
| Jamf Pro (设备管理软件) | ✓/− | ||
| 杰赫罗 (Beta) | ✓/− | ||
| JSON | ✓/− | ||
| Kognitwin | ✓/− | ||
| KX kdb Insights Enterprise(测试版) | ✓/− | ||
| Kyligence | ✓/− | ||
| Kyvos ODBC(测试版) | ✓/− | ||
| LEAP(测试版) | ✓/− | ||
| Linkar PICK 样式/多值数据库 (Beta) | ✓/− | ||
| 领英 学习 | ✓/− | ||
| MariaDB | ✓/− | ✓/− | ✓/− |
| MarkLogic | ✓/− | ||
| Microsoft 365 | ✓/− | ||
| Microsoft Access | ✓/✓ | ✓/✓ | |
| Microsoft Azure能源数据管理器 | ✓/− | ||
| Microsoft Exchange Online | ✓/− | ||
| Power BI 的 MicroStrategy | ✓/− | ||
| MongoDB 管道图集 | ✓/✓ | ✓/✓ | |
| MongoDB Atlas SQL | ✓/− | ||
| MongoDB for Pipeline | ✓/✓ | ✓/✓ | |
| MySQL 数据库 | ✓/− | ✓/✓ | ✓/✓ |
| OData | ✓/− | ✓/− | ✓/− |
| Odbc | ✓/− | ✓/✓ | ✓/✓ |
| OneStream | ✓/− | ||
| OpenSearch Project(测试版) | ✓/− | ||
| Oracle 云存储 | ✓/− | ✓/− | |
| Oracle 数据库 | ✓/− | ✓/✓ | ✓/✓ |
| Palantir Foundry 数据集 | ✓/− | ||
| 拼花地板 | ✓/− | ||
| Paxata | ✓/− | ||
| ✓/− | |||
| Planview 企业体系结构 | ✓/− | ||
| Planview IdeaPlace (计划视图创意广场) | ✓/− | ||
| Planview OKR(测试版) | ✓/− | ||
| Planview 产品组合 | ✓/− | ||
| Planview ProjectPlace | ✓/− | ||
| PostgreSQL 数据库 | ✓/✓ | ✓/✓ | ✓/✓ |
| Power BI 数据流(旧版) | ✓/− | ||
| 噗哧 | ✓/− | ✓/− | |
| 产品洞察(Beta 版) | ✓/− | ||
| Profisee | ✓/− | ||
| QubolePresto (Beta) | ✓/− | ||
| Quickbase | ✓/− | ||
| REST | ✓/✓ | ✓/✓ | |
| Roamler (Beta) | ✓/− | ||
| Salesforce 对象 | ✓/− | ✓/✓ | ✓/✓ |
| Salesforce 报告 | ✓/− | ||
| Salesforce Service Cloud | ✓/✓ | ✓/✓ | |
| 轮回 | ✓/− | ||
| SAP BW 应用服务器 | ✓/− | ||
| SAP BW 消息服务器 | ✓/− | ||
| SAP BW Open Hub 应用服务器 | ✓/− | ✓/− | |
| SAP BW Open Hub 消息服务器 | ✓/− | ✓/− | |
| SAP HANA数据库 | ✓/− | ✓/− | ✓/− |
| SAP Table Application Server | ✓/− | ✓/− | |
| SAP Table Message Server | ✓/− | ✓/− | |
| ServiceNow | ✓/− | ✓/− | |
| SFTP | ✓/✓ | ✓/✓ | |
| SharePoint 文件夹 | ✓/✓ | ||
| SharePoint list | ✓/− | ||
| SharePoint Online 列表 | ✓/− | ✓/− | ✓/− |
| 快捷方式 商业洞察 (Beta) | ✓/− | ||
| SingleStore DirectQuery 连接器 | ✓/− | ||
| SIS-CC SDMX(测试版) | ✓/− | ||
| Siteimprove | ✓/− | ||
| Smartsheet | ✓/− | ||
| Snowflake | ✓/− | ✓/✓ | ✓/✓ |
| SoftOne BI(测试版) | ✓/− | ||
| SolarWinds 服务台 | ✓/− | ||
| Solver | ✓/− | ||
| Spark | ✓/− | ||
| SQL Server 数据库 | ✓/− | ✓/✓ | ✓/✓ |
| Starburst | ✓/− | ||
| 由 Entra ID 保护的星爆 | ✓/− | ||
| SumTotal | ✓/− | ||
| Supermetrics | ✓/− | ||
| SurveyMonkey | ✓/− | ||
| Sybase 数据库 | ✓/− | ||
| TeamDesk (Beta) | ✓/− | ||
| Tenforce (Smart)List | ✓/− | ||
| Teradata 数据库 | ✓/− | ✓/✓ | ✓/✓ |
| 文本/CSV | ✓/− | ||
| TIBCO(R) Data Virtualization | ✓/− | ||
| Topcon Aptix 洞见 | ✓/− | ||
| Usercube(测试版) | ✓/− | ||
| Vena | ✓/− | ||
| Vertica | ✓/− | ✓/− | ✓/− |
| Vessel Insight | ✓/− | ||
| Viva Insights | ✓/− | ||
| Warehouse | ✓/− | ||
| 网络应用程序接口 | ✓/− | ||
| 网页 | ✓/− | ||
| Webtrends Analytics (Beta) | ✓/− | ||
| 温莎 | ✓/− | ||
| 威蒂维奥 (Beta) | ✓/− | ||
| Wolters Kluwer CCH Tagetik | ✓/− | ||
| Wrike (Beta) | ✓/− | ||
| XML | ✓/− | ||
| Zendesk | ✓/− | ||
| Zoho Creator(应用开发平台) | ✓/− | ||
| Zucchetti HR Infinity (Beta) | ✓/− |
TLS 1.3 支持
传输层安全性 (TLS) 是一种广泛采用的安全协议,旨在保护服务器和客户端之间的连接和通信。 以下连接器支持数据工厂的 TLS 1.3:
| Connector | 数据流 Gen2 | 复制活动 | 复制作业 |
|---|---|---|---|
| SQL Server 版 Amazon RDS | ✓ | ✓ | |
| Azure Blobs | ✓ | ✓ | |
| Azure 数据资源管理器 (Kusto) | ✓ | ✓ | |
| Azure Database for PostgreSQL (version 2.0) | ✓ | ✓ | |
| Azure 文件共享 | ✓ | ✓ | |
| Azure SQL 数据库 | ✓ | ✓ | |
| Azure SQL 托管实例 | ✓ | ✓ | |
| Azure Synapse Analytics (SQL DW) | ✓ | ✓ | |
| Azure Tables | ✓ | ✓ | |
| IBM Db2 数据库 | ✓ | ✓ | |
| Oracle 数据库 | ✓ | ✓ | |
| PostgreSQL 数据库 | ✓ | ✓ | |
| Snowflake | ✓ | ✓ | |
| SQL Server 数据库 | ✓ | ✓ |