Nota
L-aċċess għal din il-paġna jeħtieġ l-awtorizzazzjoni. Tista’ tipprova tidħol jew tibdel id-direttorji.
L-aċċess għal din il-paġna jeħtieġ l-awtorizzazzjoni. Tista’ tipprova tibdel id-direttorji.
Data Factory in Microsoft Fabric connects to many types of data stores using built-in connectors. These connectors help you bring in or transform data with Dataflow Gen2, pipelines, or Copy job. Select the connector you need to get started.
Prerequisites
Before setting up a connection, ensure you have:
- A Microsoft Fabric tenant account with an active subscription. Create an account for free.
- A Microsoft Fabric-enabled workspace. Create a workspace.
Supported connectors in Fabric
Fabric supports these connectors in Dataflow Gen2, pipelines, and Copy job. Select a data store to see what it can do and how to set it up.
| Connector | Dataflow Gen2 (source/destination) | Pipeline (copy activity source/destination) | Copy job (source/destination) |
|---|---|---|---|
| Access | ✓/− | ||
| Acterys: Model Automation & Planning (Beta) | ✓/− | ||
| Actian (Beta) | ✓/− | ||
| Active Directory | ✓/− | ||
| Adobe Analytics | ✓/− | ||
| ADPAnalytics (Beta) | ✓/− | ||
| Amazon Athena | ✓/− | ||
| Amazon OpenSearch Service (Beta) | ✓/− | ||
| Amazon RDS For Oracle | ✓/− | ✓/− | |
| Amazon RDS for SQL Server | ✓/− | ✓/− | |
| Amazon Redshift | ✓/− | ✓/− | |
| Amazon S3 | ✓/✓ | ✓/✓ | |
| Amazon S3 Compatible | ✓/✓ | ✓/✓ | |
| Anaplan | ✓/− | ||
| Asana | ✓/− | ||
| Assemble Views | ✓/− | ||
| AtScale cubes | ✓/− | ||
| Autodesk Construction Cloud | ✓/− | ||
| Automation Anywhere | ✓/− | ||
| Automy Analytics | ✓/− | ||
| Azure AI Search | −/✓ | −/✓ | |
| Azure Analysis Services | ✓/− | ||
| Azure Blobs | ✓/− | ✓/✓ | ✓/✓ |
| Azure Cosmos DB for MongoDB | ✓/✓ | ✓/✓ | |
| Azure Cosmos DB for MongoDB vCore (Beta) | ✓/− | ||
| Azure Cosmos DB v2 | ✓/− | ✓/✓ | ✓/✓ |
| Azure Cost Management | ✓/− | ||
| Azure Data Explorer (Kusto) | ✓/✓ | ✓/✓ | ✓/✓ |
| Azure Data Lake Storage Gen2 | ✓/− | ✓/✓ | ✓/✓ |
| Azure Database for MySQL | ✓/✓ | ✓/✓ | |
| Azure Database for PostgreSQL | ✓/✓ | ✓/✓ | |
| Azure Databricks | ✓/− | ✓/✓ | |
| Azure Files | ✓/✓ | ✓/✓ | |
| Azure HDInsight (HDFS) | ✓/− | ||
| Azure HDInsight Spark | ✓/− | ||
| Azure Resource Graph | ✓/− | ||
| Azure SQL database | ✓/✓ | ✓/✓ | ✓/✓ |
| Azure SQL Managed Instance | ✓/✓ | ✓/✓ | |
| Azure Synapse Analytics (SQL DW) | ✓/- | ✓/✓ | ✓/✓ |
| Azure Synapse Analytics workspace (Beta) | ✓/− | ||
| Azure Tables | ✓/− | ✓/✓ | ✓/- |
| BI Connector | ✓/− | ||
| BitSight Security Ratings | ✓/− | ||
| Bloomberg Data and Analytics | ✓/− | ||
| BQE CORE | ✓/− | ||
| BuildingConnected & Trade Tapp | ✓/− | ||
| Cassandra | ✓/− | ✓/− | |
| CData Connect Cloud | ✓/− | ||
| Celonis EMS | ✓/− | ||
| Cherwell (Beta) | ✓/− | ||
| ClickHouse | ✓/− | ||
| CloudBluePSA (Beta) | ✓/− | ||
| Cognite Data Fusion (OData) | ✓/− | ||
| Cognite Data Fusion (Rest API) (Beta) | ✓/− | ||
| Common Data Service (legacy) | ✓/− | ||
| Data Virtuality LDW | ✓/− | ||
| Databricks | ✓/− | ||
| Dataflow | ✓/− | ||
| Datamarts (Beta) | ✓/− | ||
| Dataverse | ✓/− | ✓/✓ | ✓/✓ |
| Delta Sharing | ✓/− | ||
| Denodo | ✓/− | ||
| Dremio Cloud | ✓/− | ||
| Dremio Software | ✓/− | ||
| Dynamics 365 Business Central | ✓/− | ||
| Dynamics 365 Customer Insights (Beta) | ✓/− | ||
| Dynamics AX | ✓/− | ✓/− | |
| Dynamics CRM | ✓/✓ | ✓/✓ | |
| Dynatrace Grail DQL (Beta) | ✓/− | ||
| Eduframe (Beta) | ✓/− | ||
| Emigo Data Source | ✓/− | ||
| Entersoft Business Suite | ✓/− | ||
| EQuIS | ✓/− | ||
| eWay-CRM | ✓/− | ||
| Exact Online Premium (Beta) | ✓/− | ||
| Exasol | ✓/− | ||
| Excel workbook | ✓/− | ||
| Fabric Data Warehouse | ✓/✓ | ✓/✓ | ✓/✓ |
| Fabric KQL Database | ✓/✓ | ✓/✓ | |
| Fabric Lakehouse | ✓/✓ | ✓/✓ | ✓/✓ |
| Fabric SQL database (Beta) | ✓/✓ | ✓/✓ | ✓/✓ |
| FactSet Analytics | ✓/− | ||
| FactSet RMS (Beta) | ✓/− | ||
| FHIR | ✓/− | ||
| Folder | ✓/− | ✓/✓ | ✓/✓ |
| FTP | ✓/− | ✓/− | |
| Funnel | ✓/− | ||
| Google Analytics | ✓/− | ||
| Google BigQuery | ✓/− | ✓/− | ✓/− |
| Google BigQuery (Microsoft Entra ID) | ✓/− | ||
| Google Cloud Storage | ✓/✓ | ✓/✓ | |
| Google Sheets | ✓/− | ||
| Greenplum for Pipeline | ✓/− | ✓/− | |
| Hadoop Distributed File System (Hdfs) | ✓/− | ✓/− | |
| HDInsight Interactive Query | ✓/− | ||
| Hexagon PPM Smart API | ✓/− | ||
| Hive LLAP | ✓/− | ||
| HTTP | ✓/− | ✓/− | |
| IBM Db2 database | ✓/− | ✓/− | ✓/− |
| IBM Netezza | ✓/− | ||
| Impala | ✓/− | ||
| Informix For Pipeline | ✓/✓ | ✓/✓ | |
| Indexima | ✓/− | ||
| Industrial App Store | ✓/− | ||
| InformationGrid | ✓/− | ||
| InterSystems Health Insight | ✓/− | ||
| Intune Data Warehouse (Beta) | ✓/− | ||
| inwink (Beta) | ✓/− | ||
| Jamf Pro | ✓/− | ||
| Jethro (Beta) | ✓/− | ||
| JSON | ✓/− | ||
| Kognitwin | ✓/− | ||
| KX kdb Insights Enterprise (Beta) | ✓/− | ||
| Kyligence | ✓/− | ||
| Kyvos ODBC (Beta) | ✓/− | ||
| LEAP (Beta) | ✓/− | ||
| Linkar PICK Style / MultiValue Databases (Beta) | ✓/− | ||
| LinkedIn Learning | ✓/− | ||
| MariaDB | ✓/− | ✓/− | ✓/− |
| MarkLogic | ✓/− | ||
| Microsoft 365 | ✓/− | ||
| Microsoft Access | ✓/✓ | ✓/✓ | |
| Microsoft Azure Data Manager for Energy | ✓/− | ||
| Microsoft Exchange Online | ✓/− | ||
| Strategy for Power BI | ✓/− | ||
| MongoDB Atlas for Pipelines | ✓/✓ | ✓/✓ | |
| MongoDB Atlas SQL | ✓/− | ||
| MongoDB for Pipeline | ✓/✓ | ✓/✓ | |
| MySQL database | ✓/− | ✓/− | ✓/− |
| OData | ✓/− | ✓/− | ✓/− |
| Odbc | ✓/− | ✓/✓ | ✓/✓ |
| OneStream | ✓/− | ||
| OpenSearch Project (Beta) | ✓/− | ||
| Oracle Cloud Storage | ✓/− | ✓/− | |
| Oracle database | ✓/− | ✓/✓ | ✓/✓ |
| Palantir Foundry Datasets | ✓/− | ||
| Parquet | ✓/− | ||
| Paxata | ✓/− | ||
| ✓/− | |||
| Planview Enterprise Architecture | ✓/− | ||
| Planview IdeaPlace | ✓/− | ||
| Planview OKR (Beta) | ✓/− | ||
| Planview Portfolios | ✓/− | ||
| Planview ProjectPlace | ✓/− | ||
| PostgreSQL database | ✓/− | ✓/− | ✓/− |
| Power BI dataflows (Legacy) | ✓/− | ||
| Presto | ✓/− | ✓/− | |
| Product Insights (Beta) | ✓/− | ||
| Profisee | ✓/− | ||
| QubolePresto (Beta) | ✓/− | ||
| Quickbase | ✓/− | ||
| REST | ✓/✓ | ✓/✓ | |
| Roamler (Beta) | ✓/− | ||
| Salesforce objects | ✓/− | ✓/✓ | ✓/✓ |
| Salesforce reports | ✓/− | ||
| Salesforce Service Cloud | ✓/✓ | ✓/✓ | |
| Samsara | ✓/− | ||
| SAP BW Application Server | ✓/− | ||
| SAP BW Message Server | ✓/− | ||
| SAP BW Open Hub Application Server | ✓/− | ✓/− | |
| SAP BW Open Hub Message Server | ✓/− | ✓/− | |
| SAP HANA database | ✓/− | ✓/− | ✓/− |
| SAP Table Application Server | ✓/− | ✓/− | |
| SAP Table Message Server | ✓/− | ✓/− | |
| ServiceNow | ✓/− | ✓/− | |
| SFTP | ✓/✓ | ✓/✓ | |
| SharePoint folder | ✓/✓ | ||
| SharePoint list | ✓/− | ||
| SharePoint Online list | ✓/− | ✓/− | ✓/− |
| Shortcuts Business Insights (Beta) | ✓/− | ||
| SingleStore Direct Query Connector | ✓/− | ||
| SIS-CC SDMX (Beta) | ✓/− | ||
| Siteimprove | ✓/− | ||
| Smartsheet | ✓/− | ||
| Snowflake | ✓/− | ✓/✓ | ✓/✓ |
| SoftOne BI (Beta) | ✓/− | ||
| SolarWinds Service Desk | ✓/− | ||
| Solver | ✓/− | ||
| Spark | ✓/− | ||
| SQL Server database | ✓/− | ✓/✓ | ✓/✓ |
| Starburst | ✓/− | ||
| Starburst secured by Entra ID | ✓/− | ||
| SumTotal | ✓/− | ||
| Supermetrics | ✓/− | ||
| SurveryMonkey | ✓/− | ||
| Sybase database | ✓/− | ||
| TeamDesk (Beta) | ✓/− | ||
| Tenforce (Smart)List | ✓/− | ||
| Teradata database | ✓/− | ✓/✓ | |
| Text/CSV | ✓/− | ||
| TIBCO(R) Data Virtualization | ✓/− | ||
| Topcon Aptix Insights | ✓/− | ||
| Usercube (Beta) | ✓/− | ||
| Vena | ✓/− | ||
| Vertica | ✓/− | ✓/− | ✓/− |
| Vessel Insight | ✓/− | ||
| Viva Insights | ✓/− | ||
| Warehouse | ✓/− | ||
| Web API | ✓/− | ||
| Web page | ✓/− | ||
| Webtrends Analytics (Beta) | ✓/− | ||
| Windsor | ✓/− | ||
| Witivio (Beta) | ✓/− | ||
| Wolters Kluwer CCH Tagetik | ✓/− | ||
| Wrike (Beta) | ✓/− | ||
| XML | ✓/− | ||
| Zendesk | ✓/− | ||
| Zoho Creator | ✓/− | ||
| Zucchetti HR Infinity (Beta) | ✓/− |
Support TLS 1.3
Transport Layer Security (TLS) is a widely adopted security protocol that's designed to secure connections and communications between servers and clients. The following connectors support TLS 1.3 for Data Factory:
| Connector | Dataflow Gen2 | Copy activity | Copy job |
|---|---|---|---|
| Amazon RDS for SQL Server | ✓ | ✓ | |
| Amazon RDS for SQL Server | ✓ | ✓ | |
| Azure Blobs | ✓ | ✓ | |
| Azure Data Explorer (Kusto) | ✓ | ✓ | |
| Azure Database for PostgreSQL (version 2.0) | ✓ | ✓ | |
| Azure Files | ✓ | ✓ | |
| Azure SQL Database | ✓ | ✓ | |
| Azure SQL Managed Instance | ✓ | ✓ | |
| Azure Synapse Analytics (SQL DW) | ✓ | ✓ | |
| Azure Tables | ✓ | ✓ | |
| IBM Db2 database | ✓ | ✓ | |
| Oracle database | ✓ | ✓ | |
| PostgreSQL database | ✓ | ✓ | |
| Snowflake | ✓ | ✓ | |
| SQL Server database | ✓ | ✓ |