Data Factory 透過內建連接器連接多種資料儲存裝置。 這些連接器可協助你使用 dataflow Gen2、管線或複製工作來匯入或轉換資料。 選取您需要開始使用的連接器。
Prerequisites
在設定連線之前,請確保您擁有:
Fabric 中支援的連接器
Fabric 支援這些連接器,用於資料流 Gen2、管線及複製工作。 選取數據存放區以查看它可以做什麼,以及如何設定它。
小提示
欲了解更詳細的複製工作功能可用性,請參閱 各連接器支援的功能(Copy job)。
| Connector | 資料流 Gen2 (來源/目的地) | 管線 (複製活動來源/目的地) | 複製工作 (來源/目的地) |
|---|---|---|---|
| Access | ✓/− | ||
| Acterys:模型自動化與規劃 (Beta) | ✓/− | ||
| Actian (測試版) | ✓/− | ||
| Active Directory | ✓/− | ||
| Adobe Analytics | ✓/− | ||
| ADPAnalytics(測試版) | ✓/− | ||
| Amazon Athena | ✓/− | ||
| Amazon OpenSearch 服務(測試版) | ✓/− | ||
| Amazon RDS for Oracle | ✓/− | ✓/− | |
| Amazon RDS for SQL Server | ✓/− | ✓/− | |
| Amazon Redshift | ✓/− | ✓/− | |
| Amazon S3 | ✓/✓(預覽) | ✓/✓ | ✓/✓ |
| 與 Amazon S3 相容 | ✓/✓ | ✓/✓ | |
| Anaplan | ✓/− | ||
| Asana | ✓/− | ||
| 組合檢視 | ✓/− | ||
| AtScale 立方體 | ✓/− | ||
| Autodesk Construction Cloud | ✓/− | ||
| 無處不在的自動化 | ✓/− | ||
| Automy Analytics | ✓/− | ||
| Azure AI 搜尋服務 | −/✓ | −/✓ | |
| Azure Analysis Services | ✓/− | ||
| Azure Blob | ✓/− | ✓/✓ | ✓/✓ |
| Azure Cosmos DB for MongoDB | ✓/✓ | ✓/✓ | |
| Azure Cosmos DB for MongoDB vCore (Beta) | ✓/− | ||
| Azure Cosmos DB v2 | ✓/− | ✓/✓ | ✓/✓ |
| Azure 成本管理 | ✓/− | ||
| Azure Data Explorer (Kusto) | ✓/✓ | ✓/✓ | ✓/✓ |
| Azure Data Lake Storage Gen2 | ✓/− | ✓/✓ | ✓/✓ |
| 適用於 MySQL 的 Azure 資料庫 | ✓/✓ | ✓/✓ | |
| 適用於 PostgreSQL 的 Azure 資料庫 | ✓/- | ✓/✓ | ✓/✓ |
| 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 安全評分 | ✓/− | ||
| 彭博數據與分析 | ✓/− | ||
| BQE CORE | ✓/− | ||
| BuildingConnected 與 Trade Tapp | ✓/− | ||
| Cassandra | ✓/− | ✓/− | |
| CData Connect Cloud | ✓/− | ||
| Celonis EMS | ✓/− | ||
| Cherwell(測試版) | ✓/− | ||
| ClickHouse | ✓/− | ||
| CloudBluePSA(測試版) | ✓/− | ||
| Cognite Data Fusion (OData) | ✓/− | ||
| Cognite Data Fusion(Rest API)(Beta) | ✓/− | ||
| Common Data Service(舊版) | ✓/− | ||
| 數據虛擬化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 (Beta) | ✓/− | ||
| Emigo 資料來源 | ✓/− | ||
| Entersoft 商務套件 | ✓/− | ||
| EQuIS | ✓/− | ||
| eWay-CRM | ✓/− | ||
| Exact Online Premium(測試版) | ✓/− | ||
| Exasol | ✓/− | ||
| Excel 活頁簿 | ✓/− | ||
| Fabric Data Warehouse | ✓/✓ | ✓/✓ | ✓/✓ |
| Fabric 中的 KQL 資料庫 | ✓/✓ | ✓/✓ | |
| Fabric 裡的 Lakehouse | ✓/✓ | ✓/✓ | ✓/✓ |
| Fabric 中的 SQL 資料庫(測試版) | ✓/✓ | ✓/✓ | ✓/✓ |
| FactSet 分析 | ✓/− | ||
| FactSet RMS (Beta) | ✓/− | ||
| FHIR | ✓/− | ||
| 資料夾 | ✓/− | ✓/✓ | ✓/✓ |
| FTP | ✓/− | ✓/− | |
| 漏斗 | ✓/− | ||
| Google Analytics | ✓/− | ||
| Google BigQuery | ✓/✓(預覽中的目的地) | ✓/✓ | ✓/✓ |
| Google BigQuery(Microsoft Entra ID) | ✓/− | ||
| Google 雲端儲存 | ✓/✓ | ✓/✓ | |
| Google 試算表 | ✓/− | ||
| Greenplum for Pipeline | ✓/− | ✓/− | |
| Hadoop 分散式檔案系統 (HDFS) | ✓/− | ✓/− | |
| HDInsight 互動式查詢 | ✓/− | ||
| 六邊形 PPM 智慧 API | ✓/− | ||
| Hive LLAP | ✓/− | ||
| HTTP | ✓/− | ✓/− | |
| IBM Db2 資料庫 | ✓/− | ✓/− | ✓/− |
| IBM Netezza | ✓/− | ||
| Impala | ✓/− | ||
| Informix For Pipeline | ✓/✓ | ✓/✓ | |
| Indexima | ✓/− | ||
| 工業應用程式商店 | ✓/− | ||
| InformationGrid | ✓/− | ||
| InterSystems Health Insight | ✓/− | ||
| Intune 資料倉儲 (Beta) | ✓/− | ||
| inwink(測試版) | ✓/− | ||
| Jamf 專業版 | ✓/− | ||
| 傑思羅(測試版) | ✓/− | ||
| JSON | ✓/− | ||
| Kognitwin | ✓/− | ||
| KX kdb Insights Enterprise(測試版) | ✓/− | ||
| Kyligence | ✓/− | ||
| Kyvos ODBC(測試版) | ✓/− | ||
| LEAP(Beta) | ✓/− | ||
| Linkar PICK Style / 多值資料庫(測試版) | ✓/− | ||
| LinkedIn Learning | ✓/− | ||
| MariaDB | ✓/− | ✓/− | ✓/− |
| MarkLogic | ✓/− | ||
| Microsoft 365 | ✓/− | ||
| Microsoft Access | ✓/✓ | ✓/✓ | |
| 適用於能源的 Microsoft Azure 資料管理員 | ✓/− | ||
| Microsoft Exchange Online | ✓/− | ||
| Power BI 的 MicroStrategy | ✓/− | ||
| MongoDB Atlas for Pipelines | ✓/✓ | ✓/✓ | |
| MongoDB Atlas SQL | ✓/− | ||
| MongoDB for Pipeline | ✓/✓ | ✓/✓ | |
| MySQL 資料庫 | ✓/− | ✓/✓ | ✓/✓ |
| OData | ✓/− | ✓/− | ✓/− |
| ODBC | ✓/− | ✓/✓ | ✓/✓ |
| OneStream | ✓/− | ||
| OpenSearch Project(測試版) | ✓/− | ||
| Oracle 雲端儲存 | ✓/− | ✓/− | |
| Oracle 資料庫 | ✓/− | ✓/✓ | ✓/✓ |
| Palantir Foundry 資料集 | ✓/− | ||
| 拼花地板 | ✓/− | ||
| Paxata | ✓/− | ||
| ✓/− | |||
| Planview 企業架構 | ✓/− | ||
| Planview 創意廣場 | ✓/− | ||
| Planview OKR(測試版) | ✓/− | ||
| Planview 投資組合 | ✓/− | ||
| Planview ProjectPlace | ✓/− | ||
| PostgreSQL 資料庫 | ✓/✓ | ✓/✓ | ✓/✓ |
| Power BI 資料流程 (舊版) | ✓/− | ||
| Presto | ✓/− | ✓/− | |
| Product Insights (測試版) | ✓/− | ||
| Profisee | ✓/− | ||
| QubolePresto(測試版) | ✓/− | ||
| Quickbase | ✓/− | ||
| REST | ✓/✓ | ✓/✓ | |
| 漫遊者 (測試版) | ✓/− | ||
| Salesforce 物件 | ✓/− | ✓/✓ | ✓/✓ |
| Salesforce 報告 | ✓/− | ||
| Salesforce Service Cloud | ✓/✓ | ✓/✓ | |
| Samsara | ✓/− | ||
| SAP BW 應用伺服器 | ✓/− | ||
| SAP BW 訊息伺服器 | ✓/− | ||
| SAP BW Open Hub 應用伺服器 | ✓/− | ✓/− | |
| SAP BW Open Hub 訊息伺服器 | ✓/− | ✓/− | |
| SAP Hana 資料庫 | ✓/− | ✓/− | ✓/− |
| SAP 資料表應用伺服器 | ✓/− | ✓/− | |
| SAP Table Message Server | ✓/− | ✓/− | |
| ServiceNow | ✓/− | ✓/− | |
| SFTP | ✓/✓ | ✓/✓ | |
| SharePoint 資料夾 | ✓/✓ | ||
| SharePoint list | ✓/− | ||
| SharePoint Online 清單 | ✓/− | ✓/− | ✓/− |
| Shortcuts 商業見解 搶鮮版 (Beta) | ✓/− | ||
| SingleStore DirectQuery 連接器 | ✓/− | ||
| SIS-CC SDMX(測試版) | ✓/− | ||
| Siteimprove | ✓/− | ||
| Smartsheet | ✓/− | ||
| Snowflake | ✓/− | ✓/✓ | ✓/✓ |
| SoftOne BI(測試版) | ✓/− | ||
| SolarWinds 服務台 | ✓/− | ||
| Solver | ✓/− | ||
| Spark | ✓/− | ||
| SQL Server 資料庫 | ✓/− | ✓/✓ | ✓/✓ |
| Starburst | ✓/− | ||
| 由 Entra 識別碼保護的星環 | ✓/− | ||
| SumTotal | ✓/− | ||
| Supermetrics | ✓/− | ||
| SurveyMonkey | ✓/− | ||
| Sybase 資料庫 | ✓/− | ||
| TeamDesk(測試版) | ✓/− | ||
| Tenforce (智慧型)清單 | ✓/− | ||
| Teradata 資料庫 | ✓/− | ✓/✓ | ✓/✓ |
| Text/CSV | ✓/− | ||
| TIBCO(R) Data Virtualization | ✓/− | ||
| Topcon Aptix 洞察 | ✓/− | ||
| Usercube(測試版) | ✓/− | ||
| Vena | ✓/− | ||
| Vertica | ✓/− | ✓/− | ✓/− |
| Vessel Insight | ✓/− | ||
| Viva Insights | ✓/− | ||
| Warehouse | ✓/− | ||
| 網路應用程式介面 | ✓/− | ||
| 網頁 | ✓/− | ||
| Webtrends 分析(測試版) | ✓/− | ||
| 溫莎 | ✓/− | ||
| Witivio (測試版) | ✓/− | ||
| Wolters Kluwer CCH Tagetik | ✓/− | ||
| Wrike(測試版) | ✓/− | ||
| XML | ✓/− | ||
| Zendesk | ✓/− | ||
| Zoho 創作者 | ✓/− | ||
| Zucchetti HR Infinity(測試版) | ✓/− |
TLS 1.3 支援
傳輸層安全性 (TLS) 是一種廣泛採用的安全性通訊協定,旨在保護伺服器和用戶端之間的連線和通訊。 以下連接器支援 TLS 1.3 for Data Factory:
| Connector | 數據流 Gen2 | 複製活動 | 複製作業 |
|---|---|---|---|
| Amazon RDS for SQL Server | ✓ | ✓ | |
| Azure Blob | ✓ | ✓ | |
| Azure Data Explorer (Kusto) | ✓ | ✓ | |
| 適用於 PostgreSQL 的 Azure 資料庫 (version 2.0) | ✓ | ✓ | |
| Azure 檔案儲存體 | ✓ | ✓ | |
| Azure SQL Database | ✓ | ✓ | |
| Azure SQL 受控執行個體 | ✓ | ✓ | |
| Azure Synapse Analytics (SQL DW) | ✓ | ✓ | |
| Azure Tables | ✓ | ✓ | |
| IBM Db2 資料庫 | ✓ | ✓ | |
| Oracle 資料庫 | ✓ | ✓ | |
| PostgreSQL 資料庫 | ✓ | ✓ | |
| Snowflake | ✓ | ✓ | |
| SQL Server 資料庫 | ✓ | ✓ |