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.
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
- Microsoft Fabric & data warehouse connectors
- Database connectors
- File connectors
- File format connectors
- NoSQL connectors
- Services and apps connectors
- Generic connectors
Azure connectors
| Connector Type | ADF Source/Sink | ADF Authentication | ADF Other Settings | Fabric Source/Destination | Fabric Authentication | Fabric Other Settings |
|---|---|---|---|---|---|---|
| Azure Blob Storage | ✓/✓ | Anonymous | Service principal authentication type supports azureCloudType, accountKind, servicePrincipalCredentialType and servicePrincipalCert. |
✓/✓ | Anonymous | azureCloudType, accountKind, servicePrincipalCredentialType and servicePrincipalCert are not supported for service principal authentication type. |
| Account key | Account key | |||||
| Shared Access Signature (SAS) | Shared Access Signature (SAS) | |||||
| Service principal | Service principal | |||||
| System-assigned managed identity | Workspace identity | |||||
| User-assigned managed 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 | Workspace identity | |||||
| User-assigned managed identity | ||||||
| Organizational account | ||||||
| Azure Cosmos DB for MongoDB | ✓/✓ | Basic | Version 1.1 is not supported. Differences are in the data type mapping: Date -> Int64 TimeStamp (the most significant 32 bits) -> Int64 Min key -> Int64 Max key -> Int64 Binary -> String |
✓/✓ | Basic | Support version 1.1. Differences are in the data type mapping: Date -> DateTime TimeStamp (the most significant 32 bits) -> DateTime Min key -> String Max key -> String Binary -> GUID (when SubType is "04") / String |
| Azure Data Explorer | ✓/✓ | Service principal | ✓/✓ | |||
| System-assigned managed identity | Workspace identity | |||||
| User-assigned managed identity | ||||||
| Organizational account | ||||||
| ADLS Gen2 | ✓/✓ | Account key | Service principal authentication type supports azureCloudType, servicePrincipalCredentialType and servicePrincipalCert. |
✓/✓ | Account key | azureCloudType, servicePrincipalCredentialType and servicePrincipalCert are not supported for service principal authentication type. |
| Service principal | Service principal | |||||
| Shared Access Signature (SAS) | Shared Access Signature (SAS) | |||||
| System-assigned managed identity | Workspace identity | |||||
| User-assigned managed identity | ||||||
| Organizational account | ||||||
| Azure Database for MySQL | ✓/✓ | Basic | Support SSLMode and UseSystemTrustStore. |
✓/✓ | Basic | SSLMode and UseSystemTrustStore are not supported. |
| Azure Databricks Delta Lake | ✓/✓ | Access token | Support domain and clusterId.Support Lookup activity. |
✓/✓ | Personal Access Token | Support Server Hostname, HTTP Path. Lookup activity is not supported. |
| 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 | Support sslMode. Support additional connection properties: schema, pooling, connectionTimeout, commandTimeout, trustServerCertificate, readBufferSize, timezone, encoding. |
✓/✓ | Basic | sslMode is not supported. Additional connection properties are not supported. |
| System-assigned managed identity | ||||||
| User-assigned managed identity | ||||||
| Service principal | ||||||
| Azure Table Storage | ✓/✓ | Account key | ✓/✓ | Account key | ||
| Shared access signature | ||||||
| System-assigned managed identity | Workspace identity | |||||
| User-assigned managed identity | ||||||
| Azure SQL Database | ✓/✓ | SQL | Support alwaysEncryptedSettings, encrypt, trustServerCertificate and hostNameInCertificate. Support additional connection properties: applicationIntent, connectTimeout, connectRetryCount, connectRetryInterval, loadBalanceTimeout, commandTimeout, integratedSecurity, failoverPartner, maxPoolSize, minPoolSize, multipleActiveResultSets, multiSubnetFailover, packetSize, pooling. |
✓/✓ | Basic | alwaysEncryptedSettings, encrypt, trustServerCertificate and hostNameInCertificate are not supported. Additional connection properties are not supported. |
| Service principal | Service principal | |||||
| System-assigned managed identity | Workspace identity | |||||
| User-assigned managed identity | ||||||
| Organizational account | ||||||
| Azure SQL Managed Instance | ✓/✓ | SQL | Support alwaysEncryptedSettings, encrypt, trustServerCertificate and hostNameInCertificate. Support additional connection properties: applicationIntent, connectTimeout, connectRetryCount, connectRetryInterval, loadBalanceTimeout, commandTimeout, integratedSecurity, failoverPartner, maxPoolSize, minPoolSize, multipleActiveResultSets, multiSubnetFailover, packetSize, pooling. |
✓/✓ | Basic | alwaysEncryptedSettings, encrypt, trustServerCertificate and hostNameInCertificate are not supported. Additional connection properties are not supported. |
| Service principal | Service principal | |||||
| System-assigned managed identity | ||||||
| User-assigned managed identity | ||||||
| Organizational account | ||||||
| Azure Synapse Analytics | ✓/✓ | SQL | Support encrypt, trustServerCertificate and hostNameInCertificate. Support additional connection properties: applicationIntent, connectTimeout, connectRetryCount, connectRetryInterval, loadBalanceTimeout, commandTimeout, integratedSecurity, failoverPartner, maxPoolSize, minPoolSize, multipleActiveResultSets, multiSubnetFailover, packetSize, pooling. |
✓/✓ | Basic | encrypt, trustServerCertificate and hostNameInCertificate are not supported. Additional connection properties are not supported. |
| Service principal | Service principal | |||||
| System-assigned managed identity | Workspace identity | |||||
| User-assigned managed identity | ||||||
| Organizational account | ||||||
| Azure File Storage | ✓/✓ | Account key | Support fileShare. |
✓/✓ | Account key | Support Share URL. |
| Shared access signature | ||||||
| System-assigned managed identity | ||||||
| User-assigned managed identity |
Microsoft Fabric & data warehouse connectors
| Connector Type | ADF Source/Sink | ADF Authentication | ADF Other Settings | Fabric Source/Destination | Fabric Authentication | Fabric Other Settings |
|---|---|---|---|---|---|---|
| Microsoft Fabric Lakehouse | ✓/✓ | Service principal | Upsert for Table is not supported | ✓/✓ | Support Upsert for Table | |
| 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 | ||||||
| Microsoft Fabric KQL Database | N | ✓/✓ | Organizational account | |||
| Microsoft Fabric SQL database | N | ✓/✓ | Organizational account |
Database connectors
| Connector Type | ADF Source/Sink | ADF Authentication | ADF Other Settings | Fabric Source/Destination | Fabric Authentication | Fabric Other Settings |
|---|---|---|---|---|---|---|
| Amazon Redshift | ✓/- | Basic | Support Amazon Redshift UNLOAD | ✓/- | Amazon Redshift | Amazon Redshift UNLOAD is not supported |
| DB2 | ✓/- | Basic | ✓/- | Basic | ||
| Google BigQuery | ✓/- | UserAuthentication | Support version 1.1 (Return the results of the first statement after excluding the evaluation statements when executing multiple statements) Service Account Email is not supported for Service Account Login authentication type. |
✓/- | Version 1.1 is not supported. (Return the result of the first statement when executing multiple statements) Service Account Login authentication type supports Service Account Email. |
|
| ServiceAuthentication | Service Account Login | |||||
| Greenplum | ✓/- | Basic | Support sslMode. |
✓/- | Basic | sslMode is not supported. |
| Hive | ✓/- | Anonymous | N | |||
| UsernameAndPassword | ||||||
| WindowsAzureHDInsightService | ||||||
| Impala | ✓/- | Anonymous | N | |||
| UsernameAndPassword | ||||||
| Informix | ✓/✓ | Anonymous | Support credential. |
✓/✓ | Anonymous | credential is not supported.Support Server, Host, Service, Protocol and Database. |
| Basic | Basic | |||||
| MariaDB | ✓/- | Basic | Support sslMode and useSystemTrustStore. |
✓/- | Basic | sslMode and useSystemTrustStore are not supported. |
| Microsoft Access | ✓/✓ | Anonymous | Support credential. |
✓/✓ | Anonymous | credential is not supported. |
| Basic | Basic | |||||
| MySQL | ✓/- | Basic | Support port, sslMode and useSystemTrustStore.Support additional connection properties: allowZeroDateTime, connectionTimeout, convertZeroDateTime, guidFormat, sslCert, sslKey, treatTinyAsBoolean. |
✓/- | Basic | port, sslMode and useSystemTrustStore are not supported.Additional connection properties are not supported. |
| Netezza | ✓/- | Basic | N | |||
| Oracle | ✓/✓ | Basic | Support additional connection properties: encryptionClient, encryptionTypesClient, cryptoChecksumClient, cryptoChecksumTypesClient, initialLobFetchSize, fetchSize, statementCacheSize, initializationString, enableBulkLoad, supportV1DataTypes, and fetchTswtzAsTimestamp. |
✓/✓ | Basic | Additional connection properties are not supported. |
| Amazon RDS for Oracle | ✓/- | Basic | Support additional connection properties: encryptionClient, encryptionTypesClient, cryptoChecksumClient, cryptoChecksumTypesClient, initialLobFetchSize, fetchSize, statementCacheSize, initializationString, enableBulkLoad, supportV1DataTypes, and fetchTswtzAsTimestamp. |
✓/− | Basic | Additional connection properties are not supported. |
| PostgreSQL | ✓/- | Basic | Support port and sslMode.Support additional connection properties: schema, pooling, connectionTimeout, commandTimeout, trustServerCertificate, sslCertificate, sslKey, sslPassword, readBufferSize, logParameters, timezone, encoding. |
✓/- | Basic | port and sslMode are not supported.Additional connection properties are not supported. |
| Presto | ✓/- | Anonymous | Support enableSsl. |
✓/- | Anonymous | enableSsl is not supported. |
| LDAP | LDAP | |||||
| SAP BW Open Hub | ✓/- | Basic | ✓/- | Basic | ||
| SAP BW MDX | ✓/- | Basic | N | |||
| SAP HANA | ✓/✓ | Basic | SSL crypto provider is not supported. | ✓/- | Basic | Support SSL crypto provider: CommonCrypto, MsCrypto, SapCrypto. |
| Windows | Windows | |||||
| SAP Table | ✓/- | Basic | Support sncMode, sncMyName, sncPartnerName, sncLibraryPath, and sncQop. |
✓/− | Basic | sncMode, sncMyName, sncPartnerName, sncLibraryPath, and sncQop are not supported. |
| Secure Network Communications (SNC) | ||||||
| Snowflake | ✓/✓ | Basic | Support accountIdentifier, database, UseUtcTimestamps, treatDecimalAsString and schema. |
✓/✓ | accountIdentifier, database, UseUtcTimestamps, treatDecimalAsString and schema are not supported. |
|
| KeyPair | KeyPair | |||||
| Snowflake | ||||||
| Microsoft Account | ||||||
| Amazon RDS for SQL Server | ✓/- | SQL | Support alwaysEncryptedSettings, encrypt, trustServerCertificate, and hostNameInCertificate.Support additional connection properties: applicationIntent, connectTimeout, connectRetryCount, connectRetryInterval, loadBalanceTimeout, commandTimeout, integratedSecurity, failoverPartner, maxPoolSize, minPoolSize, multipleActiveResultSets, multiSubnetFailover, packetSize, pooling. |
✓/- | Basic | alwaysEncryptedSettings, encrypt, trustServerCertificate, and hostNameInCertificate are not supported.Additional connection properties are not supported. |
| Windows | ||||||
| SQL Server | ✓/✓ | SQL | Support alwaysEncryptedSettings, encrypt, trustServerCertificate, and hostNameInCertificate.Support additional connection properties: applicationIntent, connectTimeout, connectRetryCount, connectRetryInterval, loadBalanceTimeout, commandTimeout, integratedSecurity, failoverPartner, maxPoolSize, minPoolSize, multipleActiveResultSets, multiSubnetFailover, packetSize, pooling. |
✓/✓ | Basic | alwaysEncryptedSettings, encrypt, trustServerCertificate, and hostNameInCertificate are not supported.Additional connection properties are not supported. |
| Windows | Windows (Only for on-premises gateway) | |||||
| Organizational account | ||||||
| Service principal | ||||||
| Spark | ✓/- | Anonymous | N | |||
| UsernameAndPassword | ||||||
| WindowsAzureHDInsightService | ||||||
| Sybase | ✓/- | Basic | N | |||
| Windows | ||||||
| Teradata | ✓/- | Basic | Support sslMode, portNumber, httpsPortNumber, UseDataEncryption, CharacterSet and MaxRespSize. |
✓/✓ | Basic | sslMode, portNumber, httpsPortNumber, UseDataEncryption, CharacterSet and MaxRespSize are not supported. |
| Windows | Windows | |||||
| LDAP | ||||||
| Vertica | ✓/- | Basic | Support port. |
✓/− | Basic | port is not supported. |
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 | ✓/✓ | HMAC key |
| HDFS | ✓/- | Windows | ✓/- | |
| Anonymous | Anonymous | |||
| Oracle Cloud Storage | ✓/- | Access key | ✓/- | Access Key |
| SFTP | ✓/✓ | Basic | ✓/✓ | Basic |
| SSH public key | ||||
| multifactor |
File format connectors
| Connector Type | ADF Source/Sink | ADF Other Settings | Fabric Source/Destination | Fabric Other Settings |
|---|---|---|---|---|
| AVRO | ✓/✓ | ✓/✓ | ||
| Binary | ✓/✓ | ✓/✓ | ||
| Delimited Text | ✓/✓ | Support skipLineCount | ✓/✓ | skipLineCount is not supported |
| Excel | ✓/- | ✓/- | ||
| JSON | ✓/✓ | ✓/✓ | ||
| ORC | ✓/✓ | ✓/✓ | ||
| Parquet | ✓/✓ | ✓/✓ | ||
| XML | ✓/- | ✓/- |
NoSQL connectors
| Connector Type | ADF Source/Sink | ADF Authentication | ADF Other Settings | Fabric Source/Destination | Fabric Authentication | Fabric Other Settings |
|---|---|---|---|---|---|---|
| Cassandra | ✓/- | Anonymous | ✓/- | Anonymous | ||
| Basic | Basic | |||||
| MongoDB | ✓/✓ | Basic | Version 1.1 is not supported. Differences are in the data type mapping: Date -> Int64 TimeStamp (the most significant 32 bits) -> Int64 Min key -> Int64 Max key -> Int64 Binary -> String |
✓/✓ | Basic | Support version 1.1. Differences are in the data type mapping: Date -> DateTime TimeStamp (the most significant 32 bits) -> DateTime Min key -> String Max key -> String Binary -> GUID (when SubType is "04") / String |
| MongoDB Atlas | ✓/✓ | Basic | Version 1.1 is not supported. Differences are in the data type mapping: Date -> String TimeStamp (the most significant 32 bits) -> Int64 TimeStamp (the least significant 32 bits) -> Int64 Double -> String Int32 -> String Int64 -> String Min key -> Int64 Max key -> Int64 Binary -> String |
✓/✓ | Basic | Support version 1.1. Differences are in the data type mapping: Date -> DateTime TimeStamp (the most significant 32 bits) -> DateTime TimeStamp (the least significant 32 bits) -> Int32 Double -> Double Int32 -> Int32 Int64 -> Int64 Min key -> String Max key -> String Binary -> GUID (when SubType is "04") / String |
Services & apps connectors
| Connector Type | ADF Source/Sink | ADF Authentication | ADF Other Settings | Fabric Source/Destination | Fabric Authentication | Fabric Other Settings |
|---|---|---|---|---|---|---|
| Dataverse | ✓/✓ | Microsoft Entra service principal | ✓/✓ | Service principal | ||
| Office 365 | ||||||
| User-assigned managed identity | ||||||
| Workspace identity | ||||||
| Organizational account | ||||||
| Dynamics 365 | ✓/✓ | Service principal | ✓/✓ | Service principal | ||
| Office 365 | ||||||
| User-assigned managed identity | ||||||
| Workspace identity | ||||||
| Dynamics AX | ✓/- | OData protocol with Service Principal | ✓/- | Service principal | ||
| Workspace identity | ||||||
| Dynamics CRM | ✓/✓ | Microsoft Entra service principal | ✓/✓ | Service principal | ||
| Office 365 | ||||||
| User-assigned managed identity | ||||||
| Workspace identity | ||||||
| Google Ads | ✓/- | User authentication | N | |||
| Service authentication | ||||||
| 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 | Support pageSize | ✓/- | Basic | pageSize is not supported |
| OAuth2 | ||||||
| SharePoint Online List | ✓/- | Service principal | ✓/- | Service principal | ||
| Organizational account | ||||||
| Workspace identity | ||||||
| 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 |
| Basic | Basic | |||
| Digest | ||||
| Windows | ||||
| Client certificate | ||||
| OData | ✓/- | Anonymous | ✓/- | Anonymous |
| Basic authentication | Basic | |||
| Windows authentication | ||||
| Service principal with Key | ||||
| Service principal with Cert | ||||
| ODBC | ✓/✓ | Anonymous | ✓/✓ | Anonymous |
| Basic | Basic | |||
| REST | ✓/✓ | Anonymous | ✓/✓ | Anonymous |
| Basic | Basic | |||
| Service principal | Service principal | |||
| OAuth 2.0 Client Credential | Organizational account | |||
| System-assigned managed identity | ||||
| User-assigned managed identity |
Conclusion
To learn how to use the connectors available in Data Factory in Fabric, refer to Connector overview.