data-factory-v2-connector-overview.md

author	jianleishen
ms.topic	include
ms.date	07/12/2024
ms.author	jianleishen

Note

Connectors marked Preview are available to try, but are not recommended for production workloads. Certain features might not be supported or might have constrained capabilities.

Category	Data store	Copy activity (source/sink)	Mapping Data Flow (source/sink)	Lookup Activity	Get Metadata Activity/Validation Activity	Delete Activity	Managed private endpoint
Azure	Azure Blob Storage	✓/✓	✓/✓	✓	✓	✓	✓Exclude storage account V1
	Azure Cognitive Search Index	−/✓					✓
	Azure Cosmos DB for NoSQL	✓/✓	✓/✓	✓			✓
	Azure Cosmos DB for PostgreSQL	✓/✓	✓/✓	✓
	Azure Cosmos DB for MongoDB	✓/✓					✓
	Azure Data Explorer	✓/✓	✓/✓	✓		✓
	Azure Data Lake Storage Gen1	✓/✓	✓/✓	✓	✓	✓
	Azure Data Lake Storage Gen2	✓/✓	✓/✓	✓	✓	✓	✓
	Azure Database for MariaDB	✓/−		✓			✓
	Azure Database for MySQL	✓/✓	✓/✓	✓			✓
	Azure Database for PostgreSQL	✓/✓	✓/✓	✓			✓
	Azure Databricks Delta Lake	✓/✓	✓/✓ Use delta format	✓
	Azure Files	✓/✓		✓	✓	✓	✓Exclude storage account V1
	Azure SQL Database	✓/✓	✓/✓	✓	✓		✓
	Azure SQL Managed Instance	✓/✓	✓/✓	✓	✓		✓
	Azure Synapse Analytics	✓/✓	✓/✓	✓	✓		✓
	Azure Table Storage	✓/✓		✓			✓Exclude storage account V1
Database	Amazon RDS for Oracle	✓/−		✓
	Amazon RDS for SQL Server	✓/−		✓	✓
	Amazon Redshift	✓/−		✓
	DB2	✓/−		✓
	Drill	✓/−		✓
	Google BigQuery	✓/−		✓
	Greenplum	✓/−		✓
	HBase	✓/−		✓
	Hive	✓/−	✓/−	✓
	Apache Impala	✓/−		✓
	Informix	✓/✓		✓
	MariaDB	✓/−		✓
	Microsoft Access	✓/✓		✓
	MySQL	✓/−		✓
	Netezza	✓/−		✓
	Oracle	✓/✓		✓
	Phoenix	✓/−		✓
	PostgreSQL	✓/−		✓
	Presto	✓/−		✓
	SAP Business Warehouse Open Hub	✓/−		✓
	SAP Business Warehouse via MDX	✓/−		✓
	SAP HANA	✓/✓		✓
	SAP Table	✓/−		✓
	Snowflake	✓/✓	✓/✓	✓
	Spark	✓/−		✓
	SQL Server	✓/✓	✓/✓ Use Managed VNET	✓	✓
	Sybase	✓/−		✓
	Teradata	✓/−		✓
	Vertica	✓/−		✓
NoSQL	Cassandra	✓/−		✓
	Couchbase (Preview)	✓/−		✓
	MongoDB	✓/✓
	MongoDB Atlas	✓/✓
File	Amazon S3	✓/−	✓/✓	✓	✓	✓
	Amazon S3 Compatible Storage	✓/−		✓	✓	✓
	File System	✓/✓		✓	✓	✓
	FTP	✓/−		✓	✓	✓
	Google Cloud Storage	✓/−		✓	✓	✓
	HDFS	✓/−		✓		✓
	Oracle Cloud Storage	✓/−		✓	✓	✓
	SFTP	✓/✓	✓/✓	✓	✓	✓
Generic protocol	Generic HTTP	✓/−		✓
	Generic OData	✓/−		✓
	Generic ODBC	✓/✓		✓
	Generic REST	✓/✓	✓/✓
Microsoft Fabric	Microsoft Fabric Lakehouse	✓/✓	✓/✓
	Microsoft Fabric Warehouse	✓/✓	✓/✓	✓	✓		✓
Services and apps	Amazon Marketplace Web Service (Deprecated)
	Appfigures (Preview)		✓/-
	Asana (Preview)		✓/−
	Concur (Preview)	✓/−		✓
	data.world (Preview)		✓/−
	Dataverse	✓/✓	✓/✓	✓
	Dynamics 365	✓/✓	✓/✓	✓
	Dynamics AX	✓/−		✓
	Dynamics CRM	✓/✓	✓/✓	✓
	GitHub		For Common Data Model entity reference
	Google AdWords	✓/−		✓
	Google Sheets (Preview)		✓/−
	HubSpot	✓/−		✓
	Jira	✓/−		✓
	Magento (Preview)	✓/−		✓
	Marketo (Preview)	✓/−		✓
	Microsoft 365	✓/−	✓/−	✓
	Oracle Eloqua (Preview)	✓/−		✓
	Oracle Responsys (Preview)	✓/−		✓
	Oracle Service Cloud (Preview)	✓/−		✓
	PayPal (Preview)	✓/−		✓
	Quickbase (Preview)		✓/−
	QuickBooks (Preview)	✓/−		✓
	Salesforce	✓/✓		✓
	Salesforce Service Cloud	✓/✓		✓
	Salesforce Marketing Cloud	✓/−		✓
	SAP Cloud for Customer (C4C)	✓/✓		✓
	SAP ECC	✓/−		✓
	ServiceNow	✓/−		✓
	SharePoint Online List	✓/−		✓
	Shopify (Preview)	✓/−		✓
	Smartsheet (Preview)		✓/−
	Square (Preview)	✓/−		✓
	TeamDesk (Preview)		✓/−
	Twilio (Preview)		✓/−
	Web Table (HTML table)	✓/−		✓
	Xero	✓/−		✓
	Zendesk (Preview)		✓/−
	Zoho (Preview)	✓/−		✓