Edit

Share via


Connector overview

Data Factory in Microsoft Fabric lets you easily connect to many types of data stores using built-in connectors. Use these connectors to bring in or transform data with Dataflow Gen2, data pipelines, or Copy job. Just select the connector you need to get started.

Prerequisites

Before you set up a connection, make sure you have the following:

Supported connectors in Fabric

Fabric supports these connectors in Dataflow Gen2, data 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) Data 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 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 ✓/−
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 ✓/−
Dataflows ✓/−
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 ✓/−
HDInsight Interactive Query ✓/−
Hexagon PPM Smart API ✓/−
Hive LLAP ✓/−
HTTP ✓/✓
IBM Db2 database ✓/− ✓/✓
IBM Netezza ✓/−
Impala ✓/−
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 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 ✓/−
PDF ✓/−
Planview Enterprise Architecture ✓/−
Planview IdeaPlace ✓/−
Planview OKR (Beta) ✓/−
Planview Portfolios ✓/−
Planview ProjectPlace ✓/−
PostgreSQL database ✓/− ✓/✓ ✓/−
Power BI dataflows (Legacy) ✓/−
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 HANA database ✓/− ✓/✓ ✓/−
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) ✓/−