Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Tip
For more detailed copy job feature availability, see supported features by connector for Copy job.
| 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 | โ/โ | ||
| Dataverse | โ/โ | โ/โ | โ/โ |
| Delta Sharing | โ/โ | ||
| Denodo | โ/โ | ||
| Dremio Cloud | โ/โ | ||
| Dremio Software | โ/โ | ||
| Dynamics 365 Business Central | โ/โ | ||
| Dynamics 365 Customer Insights (Beta) | โ/โ | ||
| Dynamics 365 | โ/โ | โ/โ | |
| 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 | โ/โ | ||
| MicroStrategy 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 | โ/โ | ||
| SurveyMonkey | โ/โ | ||
| 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) | โ/โ |
TLS 1.3 support
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 | โ | โ | |
| 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 | โ | โ |
