Azure Data Factory connector overview

  • 2 minutes to read

Azure Data Factory support the following data stores via Copy activity, Data Flow, Lookup activity, Get Metadata activity and Delete activity. Click each data store to learn the supported capabilities in details and the corresponding configurations.

Category Data store Copy activity (source/sink) Mapping Data Flow (source/sink) Lookup Activity Get Metadata Activity Delete Activity
Azure Azure Blob Storage ✓/✓ ✓/✓
Supported Formats: Delimited Text, Parquet, JSON, Avro		 ✓ ✓ ✓
  Azure Cosmos DB (SQL API) ✓/✓ ✓/✓ ✓
  Azure Cosmos DB's API for MongoDB ✓/✓
  Azure Data Explorer ✓/✓ ✓
  Azure Data Lake Storage Gen1 ✓/✓ ✓/✓
Supported Formats: Delimited Text, Parquet, JSON, Avro		 ✓ ✓ ✓
  Azure Data Lake Storage Gen2 ✓/✓ ✓/✓
Supported Formats: Delimited Text, Parquet, JSON, Avro		 ✓ ✓ ✓
  Azure Database for MariaDB ✓/− ✓
  Azure Database for MySQL ✓/✓ ✓
  Azure Database for PostgreSQL ✓/✓ ✓
  Azure File Storage ✓/✓ ✓ ✓ ✓
  Azure SQL Database ✓/✓ ✓/✓
MSI authentication not supported		 ✓ ✓
  Azure SQL Database Managed Instance ✓/✓ ✓ ✓
  Azure SQL Data Warehouse ✓/✓ ✓/✓ ✓ ✓
  Azure Cognitive Search Index −/✓
  Azure Table Storage ✓/✓ ✓
Database Amazon Redshift ✓/− ✓
  DB2 ✓/− ✓
  Drill ✓/− ✓
  Google BigQuery ✓/− ✓
  Greenplum ✓/− ✓
  HBase ✓/− ✓
  Hive ✓/− ✓
  Apache Impala ✓/− ✓
  Informix ✓/− ✓
  MariaDB ✓/− ✓
  Microsoft Access ✓/− ✓
  MySQL ✓/− ✓
  Netezza ✓/− ✓
  Oracle ✓/✓ ✓
  Phoenix ✓/− ✓
  PostgreSQL ✓/− ✓
  Presto (Preview) ✓/− ✓
  SAP Business Warehouse Open Hub ✓/− ✓
  SAP Business Warehouse via MDX ✓/− ✓
  SAP HANA ✓/✓ ✓
  SAP Table ✓/− ✓
  Spark ✓/− ✓
  SQL Server ✓/✓ ✓ ✓
  Sybase ✓/− ✓
  Teradata ✓/− ✓
  Vertica ✓/− ✓
NoSQL Cassandra ✓/− ✓
  Couchbase (Preview) ✓/− ✓
  MongoDB ✓/−
File Amazon S3 ✓/− ✓ ✓ ✓
  File System ✓/✓ ✓ ✓ ✓
  FTP ✓/− ✓ ✓ ✓
  Google Cloud Storage ✓/− ✓ ✓ ✓
  HDFS ✓/− ✓
  SFTP ✓/− ✓ ✓ ✓
Generic protocol Generic HTTP ✓/− ✓
  Generic OData ✓/− ✓
  Generic ODBC ✓/✓ ✓
  Generic REST ✓/−
Services and apps Amazon Marketplace Web Service ✓/− ✓
  Common Data Service for Apps ✓/✓ ✓
  Concur (Preview) ✓/− ✓
  Dynamics 365 ✓/✓ ✓
  Dynamics AX ✓/− ✓
  Dynamics CRM ✓/✓ ✓
  Google AdWords ✓/− ✓
  HubSpot (Preview) ✓/− ✓
  Jira ✓/− ✓
  Magento (Preview) ✓/− ✓
  Marketo (Preview) ✓/− ✓
  Office 365 ✓/−
  Oracle Eloqua (Preview) ✓/− ✓
  Oracle Responsys (Preview) ✓/− ✓
  Oracle Service Cloud (Preview) ✓/− ✓
  PayPal (Preview) ✓/− ✓
  QuickBooks (Preview) ✓/− ✓
  Salesforce ✓/✓ ✓
  Salesforce Service Cloud ✓/✓ ✓
  Salesforce Marketing Cloud ✓/− ✓
  SAP Cloud for Customer (C4C) ✓/✓ ✓
  SAP ECC ✓/− ✓
  ServiceNow ✓/− ✓
  Shopify (Preview) ✓/− ✓
  Square (Preview) ✓/− ✓
  Web Table (HTML table) ✓/− ✓
  Xero ✓/− ✓
  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.

Next steps