Connector overview

Data Factory connects to many types of data stores by using built-in connectors. These connectors help you bring in or transform data by using dataflow Gen2, pipelines, or copy jobs. Select the connector you need to get started.

Prerequisites

Before setting up a connection, ensure you have:

Supported connectors in Fabric

Fabric supports these connectors in dataflow Gen2, pipelines, and copy jobs. 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 HorizonDB Database ✓/-
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 ✓/✓ ✓/✓ ✓/✓
KQL database in Fabric ✓/✓ ✓/✓
Lakehouse in Fabric ✓/✓ ✓/✓ ✓/✓
SQL database in Fabric (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 ✓/−
PDF ✓/−
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 DirectQuery 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 ✓ ✓

Related content

  • Last updated on