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 article provides an in-depth comparison of connector availability between Azure Data Factory and Data Factory in Fabric. Connectors are essential for data integration, enabling data to flow between various sources and destinations. Understanding connector continuity between these two platforms helps you plan your data workflows.
With Data Factory in Microsoft Fabric, pipelines provide connectivity to a rich set of data sources. The following connectors are 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 aren't 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 isn't 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 | ||||||
| Azure Data Lake Storage Gen2 | ✓/✓ | Account key | Service principal authentication type supports azureCloudType, servicePrincipalCredentialType, and servicePrincipalCert. |
✓/✓ | Account key | azureCloudType, servicePrincipalCredentialType, and servicePrincipalCert aren't 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 aren't supported. |
| Azure Databricks Delta Lake | ✓/✓ | Access token | Support domain and clusterId. |
✓/✓ | Personal Access Token | Support Server Hostname, HTTP Path. |
| 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 isn't supported. Additional connection properties aren't 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 aren't supported. Additional connection properties aren't 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 aren't supported. Additional connection properties aren't 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 aren't supported. Additional connection properties aren't 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 and 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 isn't 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 | Automatic table creation in the destination is not supported. Write behavior in the destination is not supported. Support additional connection properties: encryptionClient, encryptionTypesClient, cryptoChecksumClient, cryptoChecksumTypesClient, initialLobFetchSize, fetchSize, statementCacheSize, initializationString, enableBulkLoad, supportV1DataTypes, and fetchTswtzAsTimestamp. |
✓/✓ | Basic | Support automatic table creation in the destination. Support Write behavior in the destination. 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 | Automatic table creation in the destination is not supported. Write behavior in the destination is not supported. Support accountIdentifier, database, UseUtcTimestamps, treatDecimalAsString and schema. |
✓/✓ | Support automatic table creation in the destination. Support Write behavior in the destination. 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 | ADF Other Settings | Fabric Source/Destination | Fabric Authentication | Fabric Other Settings |
|---|---|---|---|---|---|---|
| Amazon S3 | ✓/- | Access key | Support sessionToken. |
✓/✓ | Access key | sessionToken is not supported. |
| Temporary security credential | ||||||
| Amazon S3 Compatible | ✓/- | Access key | Support forcePathStyle. |
✓/✓ | Access key | forcePathStyle is not supported. |
| File System | ✓/✓ | Windows | ✓/✓ | Windows | ||
| FTP | ✓/- | Basic | Support enableSsl and enableServerCertificateValidation. |
✓/- | Basic | enableSsl and enableServerCertificateValidation are not supported. |
| Anonymous | Anonymous | |||||
| Google Cloud Storage | ✓/- | Access key | ✓/✓ | HMAC key | ||
| HDFS | ✓/- | Windows | ✓/- | |||
| Anonymous | Anonymous | |||||
| Oracle Cloud Storage | ✓/- | Access key | ✓/- | Access Key | ||
| SFTP | ✓/✓ | Basic | Support skipHostKeyValidation. |
✓/✓ | Basic | skipHostKeyValidation is not supported. |
| 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 isn't 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 isn't 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 Support connectionString and database. |
✓/✓ | 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 Support server. |
| MongoDB Atlas | ✓/✓ | Basic | Version 1.1 isn't 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 Support connectionString and database. |
✓/✓ | 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 Support Server and Cluster. |
Services and 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 | Support deploymentType, serviceUri, servicePrincipalCredentialType, and credentials. |
✓/✓ | Service principal | deploymentType, serviceUri, servicePrincipalCredentialType, and credentials aren't supported.Support Environment domain. |
| Office 365 | ||||||
| User-assigned managed identity | ||||||
| Workspace identity | ||||||
| Organizational account | ||||||
| Dynamics 365 | ✓/✓ | Service principal | Support deploymentType, serviceUri, servicePrincipalCredentialType, and credentials. |
✓/✓ | Service principal | deploymentType, serviceUri, servicePrincipalCredentialType, and credentials aren't supported.Support Environment domain. |
| Office 365 | ||||||
| User-assigned managed identity | ||||||
| Workspace identity | ||||||
| Dynamics AX | ✓/- | OData protocol with Service Principal | Support aadResourceId. |
✓/- | Service principal | aadResourceId isn't supported. |
| Workspace identity | ||||||
| Dynamics CRM | ✓/✓ | Microsoft Entra service principal | Support deploymentType, serviceUri, servicePrincipalCredentialType, and credentials. |
✓/✓ | Service principal | deploymentType, serviceUri, servicePrincipalCredentialType, and credentials aren't supported.Support Environment domain. |
| 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 | Support clientId, clientSecret, and apiVersion. |
✓/✓ | Organizational account | clientId, clientSecret, and apiVersion aren't supported. |
| Salesforce Service Cloud | ✓/✓ | OAuth2ClientCredentials | ✓/✓ | Organizational account | ||
| SAP Cloud for Customer (C4C) | ✓/✓ | Basic | N | |||
| SAP ECC | ✓/- | Basic | N | |||
| ServiceNow | ✓/- | Basic | Support pageSize | ✓/- | Basic | pageSize isn't supported |
| OAuth2 | ||||||
| SharePoint Online File | N | ✓/✓ | Organizational account | |||
| Workspace identity | ||||||
| SharePoint Online List | ✓/- | Service principal | Support servicePrincipalCredentialType, ServicePrincipalCert, servicePrincipalEmbeddedCert, and servicePrincipalEmbeddedCertPassword. |
✓/- | servicePrincipalCredentialType, ServicePrincipalCert, servicePrincipalEmbeddedCert, and servicePrincipalEmbeddedCertPassword aren't supported.Support Implementation and View mode. |
|
| 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 | ADF Other Settings | Fabric Source/Destination | Fabric Authentication | Fabric Other Settings |
|---|---|---|---|---|---|---|
| HTTP | ✓/- | Anonymous | Support enableServerCertificateValidation. Support authHeaders. |
✓/- | Anonymous | Support Disable server certificate validation. authHeaders is not supported. |
| Basic | Basic | |||||
| Digest | ||||||
| Windows | ||||||
| Client certificate | ||||||
| OData | ✓/- | Anonymous | Support authHeaders, aadResourceId and azureCloudType. |
✓/- | Anonymous | authHeaders, aadResourceId and azureCloudType are not supported. |
| Basic authentication | Basic | |||||
| Windows authentication | ||||||
| Service principal with Key | ||||||
| Service principal with Cert | ||||||
| ODBC | ✓/✓ | Anonymous | Support credential. |
✓/✓ | Anonymous | credential is not supported.Support SQL statement. |
| Basic | Basic | |||||
| REST | ✓/✓ | Anonymous | Support enableServerCertificateValidation. Support authHeaders. |
✓/✓ | Anonymous | Support Disable server certificate validation. Support Token Audience Uri. authHeaders is not supported. |
| 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, see Connector overview.