data-factory-v2-supported-data-stores.md

title	description	services	author	ms.service	ms.topic	ms.date	ms.author	ms.custom
include file	include file	data-factory	linda33wj	data-factory	include	11/28/2018	jingwang	include file

Category	Data store	Supported as a source	Supported as a sink	Supported by Azure IR	Supported by Self-hosted IR
Azure	Azure Blob Storage	✓	✓	✓	✓
	Azure Cosmos DB	✓	✓	✓	✓
	Azure Data Lake Storage Gen1	✓	✓	✓	✓
	Azure Data Lake Storage Gen2 (Preview)	✓	✓	✓	✓
	Azure Database for MySQL	✓		✓	✓
	Azure Database for PostgreSQL	✓		✓	✓
	Azure File Storage	✓	✓	✓	✓
	Azure SQL Database	✓	✓	✓	✓
	Azure SQL Database Managed Instance		✓	✓	✓
	Azure SQL Data Warehouse	✓	✓	✓	✓
	Azure Search Index		✓	✓	✓
	Azure Table Storage	✓	✓	✓	✓
Database	Amazon Redshift	✓		✓	✓
	DB2	✓		✓	✓
	Drill (Preview)	✓		✓	✓
	Google BigQuery	✓		✓	✓
	Greenplum	✓		✓	✓
	HBase	✓		✓	✓
	Hive	✓		✓	✓
	Apache Impala (Preview)	✓		✓	✓
	Informix	✓			✓
	MariaDB	✓		✓	✓
	Microsoft Access	✓			✓
	MySQL	✓		✓	✓
	Netezza	✓		✓	✓
	Oracle	✓	✓	✓	✓
	Phoenix	✓		✓	✓
	PostgreSQL	✓		✓	✓
	Presto (Preview)	✓		✓	✓
	SAP Business Warehouse	✓			✓
	SAP HANA	✓	✓		✓
	Spark	✓		✓	✓
	SQL Server	✓	✓	✓	✓
	Sybase	✓			✓
	Teradata	✓			✓
	Vertica	✓		✓	✓
NoSQL	Cassandra	✓		✓	✓
	Couchbase (Preview)	✓		✓	✓
	MongoDB	✓		✓	✓
File	Amazon S3	✓		✓	✓
	File System	✓	✓	✓	✓
	FTP	✓		✓	✓
	HDFS	✓		✓	✓
	SFTP	✓		✓	✓
Generic protocol	Generic HTTP	✓		✓	✓
	Generic OData	✓		✓	✓
	Generic ODBC	✓	✓		✓
Services and apps	Amazon Marketplace Web Service (Preview)	✓		✓	✓
	Common Data Service for Apps	✓	✓	✓	✓
	Concur (Preview)	✓		✓	✓
	Dynamics 365	✓	✓	✓	✓
	Dynamics AX (Preview)	✓		✓	✓
	Dynamics CRM	✓	✓	✓	✓
	Google AdWords (Preview)	✓		✓	✓
	HubSpot (Preview)	✓		✓	✓
	Jira (Preview)	✓		✓	✓
	Magento (Preview)	✓		✓	✓
	Marketo (Preview)	✓		✓	✓
	Office 365 (Preview)	✓		✓	✓
	Oracle Eloqua (Preview)	✓		✓	✓
	Oracle Responsys (Preview)	✓		✓	✓
	Oracle Service Cloud (Preview)	✓		✓	✓
	Paypal (Preview)	✓		✓	✓
	QuickBooks (Preview)	✓		✓	✓
	Salesforce	✓	✓	✓	✓
	Salesforce Service Cloud	✓	✓	✓	✓
	Salesforce Marketing Cloud (Preview)	✓		✓	✓
	SAP Cloud for Customer (C4C)	✓	✓	✓	✓
	SAP ECC	✓		✓	✓
	ServiceNow	✓		✓	✓
	Shopify (Preview)	✓		✓	✓
	Square (Preview)	✓		✓	✓
	Web Table (HTML table)	✓			✓
	Xero (Preview)	✓		✓	✓
	Zoho (Preview)	✓		✓	✓

Note

Any connector marked as Preview means that you can try it out and give us feedback. If you want to take a dependency on preview connectors in your solution, please contact Azure support.