This documentation provides an in-depth comparison of connector availability between Azure Data Factory (ADF) and Data Factory in Fabric. Connectors play a pivotal role in data integration, enabling the seamless flow of data between various data sources and destinations. Understanding the connector continuity between these two platforms is essential for planning your data workflows.
With Data Factory in Microsoft Fabric, pipelines provide connectivity to a rich set of data sources. See below for the lists of connectors available in Azure Data Factory and Data Factory in Fabric:
Azure connectors
| Connector Type |
ADF Source/Sink |
ADF Authentication |
ADF Other Settings |
Fabric Source/Destination |
Fabric Authentication |
Fabric Other Settings |
| Azure Blob Storage |
✓/✓ |
Anonymous |
Delete activity |
✓/✓ |
Anonymous |
Delete activity |
|
|
Account key |
Lookup activity |
|
Account key |
Lookup activity |
|
|
Shared Access Signature (SAS) |
Get Metadata activity |
|
Shared Access Signature (SAS) |
Get Metadata activity |
|
|
Service principal |
|
|
Service principal |
|
|
|
System-assigned managed identity |
|
|
|
|
|
|
User-assigned managed identity |
|
|
Workspace identity |
|
|
|
|
|
|
Organizational account |
|
| Azure AI Search index |
-/✓ |
Basic |
|
-/✓ |
Service admin key |
|
| Azure Cosmos DB for NoSQL |
✓/✓ |
Key |
|
✓/✓ |
Account key |
|
|
|
Service principal |
|
|
|
|
|
|
System-assigned managed identity |
|
|
|
|
|
|
User-assigned managed identity |
|
|
Workspace identity |
|
|
|
|
|
|
Organizational account |
|
| Azure Cosmos DB for MongoDB |
✓/✓ |
Basic |
|
✓/✓ |
Basic |
|
| Azure Data Explorer |
✓/✓ |
Service principal |
|
✓/✓ |
|
|
|
|
System-assigned managed identity |
|
|
|
|
|
|
User-assigned managed identity |
|
|
Workspace identity |
|
|
|
|
|
|
Organizational account |
|
| ADLS Gen2 |
✓/✓ |
Account key |
Delete activity |
✓/✓ |
Account key |
Delete activity |
|
|
Service principal |
Lookup activity |
|
Service principal |
Lookup activity |
|
|
Shared Access Signature (SAS) |
Get Metadata activity |
|
Shared Access Signature (SAS) |
Get Metadata activity |
|
|
System-assigned managed identity |
|
|
|
|
|
|
User-assigned managed identity |
|
|
Workspace identity |
|
|
|
|
|
|
Organizational account |
|
| Azure Database for MySQL |
✓/✓ |
Basic |
|
✓/✓ |
Basic |
|
| Azure Databricks Delta Lake |
✓/✓ |
Access token |
|
✓/✓ |
Personal Access Token |
|
|
|
System-assigned managed identity |
|
|
|
|
|
|
User-assigned managed identity |
|
|
|
|
| Azure File Storage |
✓/✓ |
Account key |
|
✓/✓ |
Account key |
|
|
|
Shared access signature |
|
|
|
|
|
|
System-assigned managed identity |
|
|
|
|
|
|
User-assigned managed identity |
|
|
|
|
| Azure Database for PostgreSQL |
✓/✓ |
Basic |
|
✓/✓ |
Basic |
|
|
|
System-assigned managed identity |
|
|
|
|
|
|
User-assigned managed identity |
|
|
|
|
|
|
Service principal |
|
|
|
|
| Azure Table Storage |
✓/✓ |
Account key |
|
✓/✓ |
Account key |
|
|
|
Shared access signature |
|
|
|
|
|
|
System-assigned managed identity |
|
|
|
|
|
|
User-assigned managed identity |
|
|
Workspace identity |
|
| Azure SQL Database |
✓/✓ |
SQL |
Lookup activity |
✓/✓ |
Basic |
Lookup activity |
|
|
Service principal |
Get Metadata activity |
|
Service principal |
Get Metadata activity |
|
|
System-assigned managed identity |
Script activity |
|
|
Script activity |
|
|
User-assigned managed identity |
Stored procedure activity |
|
Workspace identity |
Stored procedure activity |
|
|
|
|
|
Organizational account |
|
| Azure SQL Managed Instance |
✓/✓ |
SQL |
|
✓/✓ |
Basic |
|
|
|
Service principal |
|
|
Service principal |
|
|
|
System-assigned managed identity |
|
|
|
|
|
|
User-assigned managed identity |
|
|
|
|
|
|
|
|
|
Organizational account |
|
| Azure Synapse Analytics |
✓/✓ |
SQL |
|
✓/✓ |
Basic |
|
|
|
Service principal |
|
|
Service principal |
|
|
|
System-assigned managed identity |
|
|
|
|
|
|
User-assigned managed identity |
|
|
Workspace identity |
|
|
|
|
|
|
Organizational account |
|
| Azure File Storage |
✓/✓ |
Account key |
|
✓/✓ |
Account key |
|
|
|
Shared access signature |
|
|
|
|
|
|
System-assigned managed identity |
|
|
|
|
|
|
User-assigned managed identity |
|
|
|
|
Microsoft Fabric & data warehouse connectors
| Connector Type |
ADF Source/Sink |
ADF Authentication |
Fabric Source/Destination |
Fabric Authentication |
| Microsoft Fabric Lakehouse |
✓/✓ |
Service principal |
✓/✓ |
|
|
|
System-assigned managed identity |
|
|
|
|
User-assigned managed identity |
|
|
|
|
|
|
Organizational account |
| Microsoft Fabric Warehouse |
✓/✓ |
Service principal |
✓/✓ |
|
|
|
System-assigned managed identity |
|
|
|
|
User-assigned managed identity |
|
|
|
|
|
|
Organizational account |
| Fabric KQL |
N |
|
✓/✓ |
Organizational account |
Database connectors
| Connector Type |
ADF Source/Sink |
ADF Authentication |
Fabric Source/Destination |
Fabric Authentication |
| Amazon Redshift |
✓/- |
Basic |
✓/- |
Amazon Redshift |
| DB2 |
✓/- |
Basic |
✓/- |
Basic |
| Google Big Query |
✓/- |
UserAuthentication |
✓/- |
|
|
|
ServiceAuthentication |
|
Service Account Login |
| Greenplum |
✓/- |
Basic |
✓/- |
Basic |
| Hive |
✓/- |
Anonymous |
N |
|
|
|
UsernameAndPassword |
|
|
|
|
WindowsAzureHDInsightService |
|
|
| Impala |
✓/- |
Anonymous |
✓/- |
|
|
|
UsernameAndPassword |
|
|
| Informix |
✓/✓ |
Anonymous |
✓/✓ |
Anonymous |
|
|
Basic |
|
Basic |
| MariaDB |
✓/- |
Basic |
✓/- |
Basic |
| Microsoft Access |
✓/✓ |
Anonymous |
✓/✓ |
Anonymous |
|
|
Basic |
|
Basic |
| MySQL |
✓/- |
Basic |
✓/- |
Basic |
| Netezza |
✓/- |
Basic |
N |
|
| Oracle |
✓/✓ |
Basic |
✓/✓ |
Basic |
| Amazon RDS for Oracle |
✓/- |
Basic |
✓/− |
Basic |
| PostgreSQL |
✓/- |
Basic |
✓/- |
Basic |
| Presto |
✓/- |
Anonymous |
✓/- |
Anonymous |
|
|
LDAP |
|
LDAP |
| SAP BW Open Hub |
✓/- |
Basic |
✓/- |
Basic |
| SAP BW MDX |
✓/- |
Basic |
N |
|
| SAP HANA |
✓/✓ |
Basic |
✓/- |
Basic |
|
|
Windows |
|
Windows |
| SAP Table |
✓/- |
Basic |
✓/− |
Basic |
|
|
Secure Network Communications (SNC) |
|
|
| Snowflake |
✓/✓ |
Basic |
✓/✓ |
|
|
|
KeyPair |
|
|
|
|
|
|
Snowflake |
|
|
|
|
Microsoft Account |
|
|
|
|
Organizational account |
| Amazon RDS for SQL Server |
✓/- |
SQL |
✓/- |
Basic |
|
|
Windows |
|
|
| SQL Server |
✓/✓ |
SQL |
✓/✓ |
Basic |
|
|
Windows |
|
Windows (Only for on-premises gateway) |
|
|
|
|
Organizational account |
|
|
|
|
Service principal |
| Spark |
✓/- |
Anonymous |
N |
|
|
|
UsernameAndPassword |
|
|
|
|
WindowsAzureHDInsightService |
|
|
| Sybase |
✓/- |
Basic |
N |
|
|
|
Windows |
|
|
| Teradata |
✓/- |
Basic |
✓/✓ |
Basic |
|
|
Windows |
|
Windows |
|
|
LDAP |
|
|
| Vertica |
✓/- |
Basic |
✓/− |
Basic |
File connectors
| Connector Type |
ADF Source/Sink |
ADF Authentication |
Fabric Source/Destination |
Fabric Authentication |
| Amazon S3 |
✓/- |
Access key |
✓/✓ |
Access Key |
|
|
Temporary security credential |
|
|
| Amazon S3 Compatible |
✓/- |
Access key |
✓/✓ |
Access Key |
| File System |
✓/✓ |
Windows |
✓/✓ |
Windows |
| FTP |
✓/- |
Basic |
✓/- |
Basic |
|
|
Anonymous |
|
Anonymous |
| Google Cloud Storage |
✓/- |
Access key |
✓/✓ |
Basic |
| HDFS |
✓/- |
Windows |
✓/- |
|
|
|
Anonymous |
|
Anonymous |
| Oracle Cloud Storage |
✓/- |
Access key |
✓/- |
Access Key |
| SFTP |
✓/✓ |
Basic |
✓/✓ |
Basic |
|
|
SSH public key |
|
|
|
|
multifactor |
|
|
| Connector Type |
ADF Source/Sink |
Fabric Source/Destination |
| AVRO |
✓/✓ |
✓/✓ |
| Binary |
✓/✓ |
✓/✓ |
| Delimited Text |
✓/✓ |
✓/✓ |
| Excel |
✓/- |
✓/- |
| JSON |
✓/✓ |
✓/✓ |
| ORC |
✓/✓ |
✓/✓ |
| Parquet |
✓/✓ |
✓/✓ |
| XML |
✓/- |
✓/- |
NoSQL connectors
| Connector Type |
ADF Source/Sink |
ADF Authentication |
Fabric Source/Destination |
Fabric Authentication |
| Cassandra |
✓/- |
Anonymous |
✓/- |
Anonymous |
| MongoDB |
✓/✓ |
Basic |
✓/✓ |
Basic |
| MongoDB Atlas |
✓/✓ |
Basic |
✓/✓ |
Basic |
Services & apps connectors
| Connector Type |
ADF Source/Sink |
ADF Authentication |
Fabric Source/Destination |
Fabric Authentication |
| Dataverse |
✓/✓ |
Microsoft Entra service principal |
✓/✓ |
Service principal |
| Dynamics 365 |
✓/✓ |
Microsoft Entra service principal |
N |
|
| Dynamics AX |
✓/- |
OData protocol with Service Principal |
N |
|
| Dynamics CRM |
✓/✓ |
Microsoft Entra service principal |
✓/✓ |
Service principal |
| Google AdWords |
✓/- |
UserAuthentication |
N |
|
| HubSpot |
✓/- |
Access token |
N |
|
| Jira |
✓/- |
Basic |
N |
|
| Microsoft 365 |
✓/- |
Service principal |
✓/- |
Service principal |
| QuickBooks |
✓/- |
OAuth 2.0 |
N |
|
| Salesforce |
✓/✓ |
OAuth2ClientCredentials |
✓/✓ |
Organizational account |
| Salesforce Service Cloud |
✓/✓ |
OAuth2ClientCredentials |
✓/✓ |
Organizational account |
| SAP Cloud for Customer (C4C) |
✓/✓ |
Basic |
N |
|
| SAP ECC |
✓/- |
Basic |
N |
|
| ServiceNow |
✓/- |
Basic |
✓/- |
Basic |
| SharePoint Online List |
✓/- |
Service principal |
✓/- |
Service principal |
| Shopify |
✓/- |
Access token |
N |
|
| Square |
✓/- |
Access token |
N |
|
| Web Table |
✓/- |
Anonymous |
N |
|
| Xero |
✓/- |
OAuth_2.0 |
N |
|
Generic connectors
| Connector Type |
ADF Source/Sink |
ADF Authentication |
Fabric Source/Destination |
Fabric Authentication |
| HTTP |
✓/- |
Anonymous |
✓/- |
Anonymous |
| OData |
✓/- |
Anonymous |
✓/- |
Anonymous |
| ODBC |
✓/✓ |
Anonymous |
✓/✓ |
Anonymous |
| REST |
✓/✓ |
Anonymous |
✓/✓ |
Anonymous |
Conclusion
To learn how to use the connectors available in Data Factory in Fabric, refer to Connector overview.